Experimental native FTS on MySQL; please test
Alex Vandiver <[email protected]>
| Newsgroups | gmane.comp.bug-tracking.request-tracker.devel |
|---|---|
| Organization | Best Practical Solutions, LLC |
| Message-ID | <[email protected]> |
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 -- RT Training - Dallas May 20-21 http://bestpractical.com/training