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/ -------- RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 & 29, 2011
