Experimental native FTS on MySQL; please test

Heya,
I’ve just pushed a 4.2/mysql-native-fts [1] branch, which adds native
(non-Sphinx!) full-text search on MySQL. On MySQL 5.6 and above, it
makes use of MySQL’s new InnoDB full-text indexes. On prior versions of
MySQL, it uses a supplemental MyISAM table; this might have performance
impacts, as most RT installs are tuned for InnoDB performance, not
MyISAM performance.

This branch has been deployed on issues.bestpractical.com for a couple
weeks, but we’d appreciate some wider testing of this before it lands in
an official release – we expect there will be significant interest in
it, and we’d prefer to find and iron out any bugs in it ahead of time.

If you’re reporting successes or failures using this branch, please be
sure to note if you’re using MySQL 5.6 (and hence the InnoDB table), or
an earlier version of MySQL (and thus the MyISAM table).

  • Alex

[1] https://github.com/bestpractical/rt/compare/4.2;mysql-native-fts

Hi Alex,

What are your expectations on when this release can (or will) be be included
in the main (4.2) release?

I’ve performed some testing against MySQL 5.5 with MyISAM, which worked fine
for me.
I haven’t seen any performance issues, but won’t draw conclusions on
performance as my testing load was a bit limited. I can perform (load)
testing against MySQL 5.6. Are there specific things I should look at?

Regards,
Kees

View this message in context: http://requesttracker.8502.n7.nabble.com/rt-devel-Experimental-native-FTS-on-MySQL-please-test-tp57116p58600.html