[rt-users] Native FullText Search in mysql

Alex Vandiver alexmv at bestpractical.com
Wed Nov 2 15:06:11 EDT 2011

On Wed, 2011-11-02 at 11:59 -0700, Ram Moskovitz wrote:
> Hey folks,
> Looks like MySQL has FTS built in :
> http://dev.mysql.com/doc/refman/5.5/en/fulltext-search.html
> Is this supported by RT 4.0x?

No.  That fulltext indexing is only on MyISAM tables, which are not used
in RT because they lack transaction isolation.  RT 4 only supports
fulltext indexing on mysql using the external Sphinx engine, until
InnoDB fulltext indexing is integrated into mysql.
  There is ongoing work on this support (see [1], [2]) but it isn't in a
released version yet.
 - Alex

[1] http://blogs.innodb.com/wp/2011/07/overview-and-getting-started-with-innodb-fts/
[2] http://blogs.innodb.com/wp/2011/07/innodb-full-text-search-tutorial/

More information about the rt-users mailing list