mysql fulltext长度设置,为“ft_min_word_len”设置新值MySQL中的FULLTEXT

I changed to "ft_min_word_len" = 4 by my-innodb-heavy-4G.ini located in my system path "C:\Program Files\MySQL\MySQL Server 5.1" , but when i run

SHOW VARIABLES LIKE 'ft_min_word_len'

I got still result value= 4. I did not find this variable in my.ini file. So i have also create a my logic. I copied to ft_min_word_len variable and place in my.ini file and now my result show value=3.

But it is not working for three character search. I've restarted server.

How can i achieve to be able to search three character value also.

解决方案

You should change this system parameter, restart server and then rebuild ALL FULLTEXT indexes.

REPAIR TABLE QUICK;