[rt-devel] Experimental native FTS on MySQL; please test

Alex Vandiver alexmv at bestpractical.com
Fri Apr 4 14:28:56 EDT 2014


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



More information about the rt-devel mailing list