X

MySQL and MySQL Community information

Full-Text Search with InnoDB

Dr. Dobb’s published yesterday an article by Jimmy Yang and
John Russel about
Full-Text Search with InnoDB:

"MySQL's latest InnoDB engine can
now do extensive, high-performance, full text search. A quick primer delivers
all the goodies.

Oracle recently provided
access to many new MySQL 5.6 features through http://labs.mysql.com
for the user community to test and comment on. One notable feature is the
InnoDB Full-Text Search (FTS) engine. It lets users build
FULLTEXT
indexes on InnoDB tables to represent text-based content and speed up searches
for words and phrases. Combining full-text search with InnoDB tables opens up
text capability to transactional applications, where the textual data is
frequently inserted, updated, and deleted. Given the importance of this feature
to the MySQL audience, this article explains the design of InnoDB FTS and
provides recipes for its use, as well as a short list of the limitations of
this release."....Continues....

Read the entire article here!

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.