The InnoDB full-text search capability is an exciting feature.
The full-text search itself is generally useful to have in an
RDBMS. If an application is using all InnoDB tables except for
one that is used for full-text searches, now that last table can
be switched to InnoDB. If putting the full-text data in a MyISAM
table led to scalability problems, duplication, or a
less-than-ideal schema design, now those issues can be addressed.
In this post, I’ll take you through some of the basics of setting
up and querying an InnoDB
FULLTEXT search index.
I’ll leave the scalability and performance aspects to Jimmy’s and Vinay’s blog posts, and just use some toy-sized
data for demonstration purposes.
Creating a Table with a …[Read more]