Risk changing MySQL ft_min_word_len

[eugenevdm]

I would like to know if there is any risk invovled in changing the default mysql setting "ft_min_word_len" from it's default of 4 to 2. As far as I now this is the minimum word len search.

What is the risk? Will the server take longer to run querries, is there a significant performance impact, etc.?

 

[asawyer13]

Shouldn't be an issue, full text indexes will be a little bigger, but I think you would be fine.
There are a lot of 2 letter words that you really might not want to index, so I've changed mine to 3 and it works great.
I also disabled the "noise" list for Mysql so things like "first", etc would not be ignored.

 

[joinindia]

Where is ft_min_word_len line on Server

Hello,

I edited my.cnf file and restarted the mysqld server, but it doesn't work.

I need to enter > ft_min_word_len=3
so that 3 chr. search will work

Where on the server is > ft_min_word_len=4
in which file path?
I am using Centos 5, Plesk 8.4.0

Thanks!