[rt-users] Native FullText Search in mysql
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! RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
Re: [rt-users] Native FullText Search in mysql
Never mind... looks likt it's MyISAM only :( On Wed, Nov 2, 2011 at 11:59 AM, Ram Moskovitz ram0...@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! RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
Re: [rt-users] Native FullText Search in mysql
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
Re: [rt-users] Native FullText Search in mysql
On Wed, Nov 02, 2011 at 11:59:40AM -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? 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 RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011