MySQL - Changing FT_MIN_WORD_LEN

4.9k views Asked by At

I've recently asked my server administrator, for my Windows dedicated server, to change the MySQL configuration file (my.cnf) to allow search words of 2 characters or more, from the default of 4.

They said the changed it, restarted MySQL and re-booted the server but I have seen no changes. I've rebuilt the indexes only on the tables that this particular script uses, using the REPAIR TABLE method but still doesn't work as it should.

Do I have to rebuild all indexes, on all tables, even though they're not being used for this full-text query?

EDIT

Is this right? After searching my server for my.ini files? 5.0 is my latest version.

enter image description here

1

There are 1 answers

5
Ike Walker On BEST ANSWER

Those changes should have been sufficient. You should verify by running this:

show variables like 'ft_min_word_len';

Typically if you are changing ft_min_word_len you also want to change ft_stopword_file since many short words are also stopwords. You can just set that variable to '' if you don't want any stopwords. Otherwise specify a path to an alternate stopwords file. That could be your problem, depending on what you are searching for.