Edit mysql variables for full text search January 22, 2008
Posted by amithasija in MYSql.add a comment
If you want to change the value of ft_min_word_len to some new variables (for eg:ft_min_word_len= 2)
which is by default 4 ,you just have to drag the my.cnf file placed in your mysql/bin to some editor (notepad) and under the heading [mysqld] place this line ft_min_word_len= 2,and now stop mysql server and restart it.To see the reflected changes you have to run the query ‘ show variables like ‘ft%’ and you’ll change the value of mysql variable changed to
ft_min_word_len= 2 from ft_min_word_len= 4.
