By default a FULL TEXT index is created to perform a search with a minimum of 4 words, in some cases it is useful to be able to lower this limit but making good attention to performance.
The parameter to use is ft_min_word_len to be set in the configuration file of MySQL. Set this parameter to 4 below may invalidate performance, although in some cases it is necessary, especially in the back-end operations.
| Command-Line Format |
--ft_min_word_len=# |
||
| Option-File Format |
ft_min_word_len |
||
| System Variable Name |
ft_min_word_len |
||
| Variable Scope | Global | ||
| Dynamic Variable | No | ||
| Permitted Values | |||
| Type |
numeric |
||
| Default |
4 |
||
| Min Value |
1 |
||
The minimum length of the word to be included in a FULLTEXT index.
Note
FULLTEXT indexes must be rebuilt after changing this variable. Use REPAIR TABLE .tbl_name QUICK
It 's just need to set it to the desired value is to recreate the index.
di GuiZ
05/09/2013