…. At the very bottom, the page claims that you can speed up bulk loading into an InnoDB FT index by declaring…: mysql> alter table dir_test_innodb ADD FULLTEXT KEY (full_name, details), ADD FULLTEXT KEY (details); ERROR 1795 (HY000): InnoDB presently supports one FULLTEXT… what happens: mysql> set global innodb_ft_aux_table=’test/dir_test_innodb’; mysql> set global innodb_optimize_fulltext_only=1; mysql> select * from…

… address, and the like. We are using MySQL 5.5.30 and MySQL 5.6.10 with no configuration …escape hatch from this rabbit hole. When defining a FULLTEXT KEY, you can use the “WITH PARSER” modifier to… will take a look at performance. How does the speed of InnoDB FTS compare to its MyISAM counterpart, …