• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Innodb to get Full Text Indexing

Deebs

Well-known member
#1
Guys,

MySQL Labs have just released 5.6 (preview/testing only) which includes some pretty nifty enhancements to InnoDB including Full Text Indexing on InnoDB tables.

Thankfully they have decided to use the same Full Text syntax as MyISAM tables so you shouldn't have to change anything to take advantage of their implementation and first impressions look very promising!

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

Hopefully this will allow even better search performance out of the box for XF when officially available as GA.
 

Rudy

Well-known member
#2
That will be interesting to see. My "big board" is running Sphinx, but for other sites, it will be an improvement.

Then I just have to wait for our host to upgrade... ;)