… happens: mysql> alter table dir_test_innodb ADD FULLTEXT KEY (full_name, details), ADD FULLTEXT KEY (details); ERROR 1795 (HY000): InnoDB presently supports one FULLTEXT index… happens: mysql> set global innodb_ft_aux_table=’test/dir_test_innodb‘; mysql> set global innodb_optimize_fulltext_only=1; mysql> select * from information_schema.innodb_ft_config…

…) mysql: SET GLOBAL innodb_ft_server_stopword_table=’test/innodb_ft_list2′; Query OK, 0 rows affected (0.00 sec) mysql: INSERT INTO innodb_ft… of InnoDB FTS configuration which are both letter-case and character-set sensitive. Watch out! When you add your first FULLTEXT KEY to an InnoDB table, be prepared for a table rebuild. Calculation…

…When defining a FULLTEXT KEY, you can use the “WITH PARSER” modifier to specify … name of a UDF which references your own custom-written fulltext parser plugin. Thus I am thinking that it may be…’t work as WITH PARSER currently doesn’t work with InnoDB. http://bugs.mysql.com/bug.php?id=62004