Native FullText Search in mysql

RT Users
1

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?
Thanks!

2

Never mind… looks likt it’s MyISAM only :(On Wed, Nov 2, 2011 at 11:59 AM, Ram Moskovitz ram0502@gmail.com 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?
Thanks!

3

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/

4

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?
Thanks!

No quite, I believe. Oracle just announced InnoDB fulltext
search vailability in a preview release of MySQL 5.6. Version
5.5 only supports fulltext-search with MYISM tables, and not
with InnoDB tables which are used by RT. So maybe next year…
fingers crossed.

Regards,
Ken