… set innodb_ft_min_token_size to 4 (rather than the default of 3) so that it matches MyISAM’s default ft_min_word…’s middle initial. To test this hypothesis, I reset innodb_ft_min_token_size to 1, dropped/rebuilt the InnoDB index, and… raise the question of why it works with MyISAM when ft_min_word_length defaults to 4, but that is a topic…

…. The second part will compare query results between MyISAM FTS and InnoDB FTS over the same data sets, and then finally in… rows affected (8 min 13.13 sec) Records: 245051 Duplicates: 0 Warnings: 0 mysql> select * from information_schema.innodb_ft_config; +—————————+———+ | KEY… for MySQL 5.6, and that was to change innodb_ft_min_token_size from the default of 3 to a value…