Fulltext for innoDB? or a good solution for php app
- by Joshua
I have a table I want to run a fulltext search on, but it is currently innoDB and is using a lot of foreign keys for other kinds of queries.
Should I make like a 1:1 "meta-data" table that is myisam for fulltext?
Also I am reading some things that say that fulltext corrupts MySQL tables pretty randomly? I dunno, the articles are a couple years…