• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

MySQL 5.6 GA - InnoDB Fulltext

Ghan_04

Active member
#1
So has anyone tried it? Going full InnoDB on MySQL 5.6 sounds very promising now that it's GA. Supposedly it uses the same syntax as MyISAM did, so converting shouldn't be problematic, but I have yet to try it.
 

Adam Howard

Well-known member
#3
So has anyone tried it? Going full InnoDB on MySQL 5.6 sounds very promising now that it's GA. Supposedly it uses the same syntax as MyISAM did, so converting shouldn't be problematic, but I have yet to try it.
YES (I have)

I've been using 5.6 since the last beta's and all the RC's. 5.6 is very much an improvement and now that it's released is final with full InnoDB support full text search.... A Sphinx Search modification may not be to far behind (once Sphinx Search catches up with MySQL 5.6).

Performance is very much improved with MySQL 5.6 and even the default XenForo search seems to like it better (queries are processed a little quicker).
 

Ghan_04

Active member
#4
Well, converting the xf_search_index table to InnoDB doesn't work for me because of DELAYED MySQL queries. InnoDB doesn't support delayed, and the forum seems to ignore the admin CP setting for it, so....