Performance Impact of changing "ft min word len" from 4 to 3

Forum Moderators: open

Message Too Old, No Replies

Performance Impact of changing "ft min word len" from 4 to 3

What does your experience tell about that change?

sambadelic

4:41 pm on Dec 3, 2007 (gmt 0)

Hi,

We're about to change the variable of our MySQL Full-Text Search index that sets the minimum length of words (ft_min_word_len) to be indexed. The default is 4 and we're changing to 3, because we already know that will improve our searching results.

What I would like to know is if anyone have done that before and what was the impact of overall performance. Our full index has now 0.5 GB (about the same size of our database).

If anyone has any hint, even without the real experience changing the variable, that could be helpful too.

I appreciate your answers.

Thanks.

physics

8:31 pm on Dec 3, 2007 (gmt 0)

I've done this and (I believe ... it's hard to tell what the cause is sometimes with complex systems) INSERT statements were slowed down considerably but SELECT statements were not affected much...