MySQL Forums
Forum List  »  Full-Text Search

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 ;)

Options: ReplyQuote

Written By
November 17, 2009 08:24AM
Re: fulltext matches failing on simple selects
November 17, 2009 10:28AM

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.