Can I change MySQL ft_min_word_len on a specific database or table?

Question

How can I change ft_min_word_len only for a specific database or table? Is it possible?

Thanks!

I have written a blog post on how this can be done http://www.linux-hosting.net/article/setting-minimum-length-indexed-words-3-mysql-ft_min_word_len — perpetual_dream, Apr 02 '12 at 10:23

score 1 · Accepted Answer · edited May 23 '17 at 10:34

1

MySQL's ft_min_word_len is a global server-system variable and cannot be separately set for individual databases or tables.
As a workaround, as suggested in this other SO question, you could "pad" each word and search with some placeholder value.

edited May 23 '17 at 10:34

Community

1
1

answered Apr 01 '12 at 20:24

mechanical_meat

163,903
24
228
223

score 0 · Answer 2 · answered Apr 01 '12 at 20:18

0

It is a database parameter, it cannot store the values for defined schemes or tables. Here you can see how it should be changing for DB server : http://www.tiplib.com/117/change-ft_min_word_len-variable

answered Apr 01 '12 at 20:18

denied

598
3
9

Can I change MySQL ft_min_word_len on a specific database or table?

2 Answers2