set new value for "ft_min_word_len " FULLTEXT in mysql

This is what I use for getting all needed repair commands:

SELECT DISTINCT CONCAT("REPAIR TABLE `", TABLE_SCHEMA, "`.`", 
TABLE_NAME, "` QUICK;") FROM information_schema.STATISTICS 
WHERE index_type = 'FULLTEXT';

I think you should try altering table by drop index and again add index. It will surely work.


You should change this system parameter, restart server and then rebuild ALL FULLTEXT indexes.

REPAIR TABLE <TableName> QUICK;
  • Change the full text index minimum word length with MySQL