Best way to emulate fulltext search in a InnoDB/MySQL database using Codeigniter
I suggest you update your MySQL simple.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
The easiest way will be to create an MyISAM table for the text data for the product and run the search queries against it. Then you can rebuild the data in the MyISAM table every day with a cron job, to ensure consistency. Or you can make your models to update the data in the MyISAM table on every update.