CODEWITHSUNDEEP
mysqlfull-text-searchinnodb
Ben
Ben

Reputation: 62356

Which search to perform in InnoDB/MySQL

I've done some searching into fulltext searches for MySQL InnoDB and found a few on stack overflow, but they either don't provide an exact solution or they are a bit dated and I think it's time to rediscuss.

All of my tables are InnoDB and I'd prefer not to lock the entire database with MyISAM. What are my options in regards to fulltext searching? Are there any simple solutions? I'd like to do the equivalant of MATCH (content) AGAINST ("my search query" IN BOOLEAN MODE)

Upvotes: 2

Views: 430

Answers (2)

joashp
joashp

Reputation: 375

InnoDB full-text search (FTS) is finally available in MySQL 5.6.4 release.

These indexes are physically represented as entire InnoDB tables, which are acted upon by SQL keywords such as the FULLTEXT clause of the CREATE INDEX statement, the MATCH() ... AGAINST syntax in a SELECT statement, and the OPTIMIZE TABLE statement. From FULLTEXT Indexes

Upvotes: 1

Andrej
Andrej

Reputation: 7504

There is no equivalant of MATCH AGAINST in Innodb. Fulltext searching is one of pros of using MyIsam. So you should use standalone seaching server like Sphinx or Solr

Upvotes: 2

Related Questions