Re: fulltext matches failing on simple selects
Posted by:
Barbie .
Date: November 17, 2009 10:28AM
In the event that someone else experiences something similar, it appears that this is related to the stopwords, but perhaps not in the way anticipated. After struggling over this, our DBA went back to basics and removed all entries in our stopwords file. He then restarted the mysqld server and repaired both quick and full (to make sure) the 'title' table. he then added back the stopwords entries, restarted mysqld and again repaired the 'title' table with quick and full (again, just to be sure).
After this all the queries worked!
It seems that going from the built-in stopwords to a list of our own stopwords wasn't working after a repair table (despite the show variables entries all looking correct). No idea why, (glitch or bug?) but it seems repairing with an empty list of stopwords before adding your own stopwords and then repairing the table again works.
Maybe our server just doesn't like Tuesdays ;)
Subject
Views
Written By
Posted
4169
November 17, 2009 08:24AM
Re: fulltext matches failing on simple selects
2636
November 17, 2009 10:28AM
2550
November 18, 2009 11:10PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.