Change Minimum Word Length In Fulltext Search

By admin on April 21, 2017 in MySQL

By default, MySQL sets the minimum word length in full text search indexes to 4 characters. Here are the steps to lower this limit to 3.

Edit /etc/my.cnf and add

ft_min_word_len = 3

1	ft_min_word_len = 3

Restart MySQL to apply the change.

Get a list of full text indexes using this query:

use information_schema;
SELECT TABLE_SCHEMA, TABLE_NAME FROM statistics WHERE index_type LIKE 'FULLTEXT%';

1 2	use information_schema; SELECT TABLE_SCHEMA, TABLE_NAME FROM statistics WHERE index_type LIKE 'FULLTEXT%';

Do a repair on each table with a full text index:

repair table [dbname].[tablename] quick;

1	repair table [dbname].[tablename] quick;