Home » Posts tagged with » MyISAM

How to change the storage engine for MySQL tables

MySQL server sets the MyISAM to default of storage engine which is storage engine that faster and simpler. However the MyISAM doesn’t support transactions and operations are slow when frequently to insert or update, because the entire table is locked for any insert or update. So, if your website is frequently update post or comment [...]

March 26, 2012 / No Comment / Read More

How to fix “The Used Table Type Doesn’t Support FULLTEXT Indexes” when convert a MySQL table to InnoDB

How to fix “The Used Table Type Doesn’t Support FULLTEXT Indexes” when convert a MySQL table to InnoDB

I received “The Used Table Type Doesn’t Support FULLTEXT Indexes” message when I was trying to convert a MySQL table from MyISAM to InnoDB storage engine. The cause of error is the InnoDB database engine does not support the “FULLTEXT Indexes”. So, I was run the SQL query below to find the FULLTEXT indexes Incoming [...]

March 9, 2012 | Filed under Database | Read More