Wrong practice of creating a mirrored table (MyISAM) of records in an InnoDB table for full-text search purposes? As I understand it, I'm just looking for a copy of the data, and if something happens to this data, it is not as much as a deal, because it can always be recreated. But it is just inconvenient.
(MyISAM is the only full-text search engine, but I need to use the foreign key constraints suggested by InnoDB)
Should I avoid this?
source
share