Menu
My MySQL database contains several tables using different storage engines (specifically myisam and innodb). How can I find out which tables are using which engine?
642
SHOW TABLE STATUS from yourDatabaseName LIKE 'yourTableName'. The above syntax tells about the specific table engine. Now you can apply the above syntax to know whether the MySQL table engine is using MyISAM or InnoDB.
InnoDB : The default storage engine in MySQL 8.0. InnoDB is a transaction-safe (ACID compliant) storage engine for MySQL that has commit, rollback, and crash-recovery capabilities to protect user data.
To determine whether your server supports InnoDB : Issue the SHOW ENGINES statement to view the available MySQL storage engines. mysql> SHOW ENGINES; Alternatively, query the INFORMATION_SCHEMA.
Access phpMyAdmin and select your database. Then click on SQL, place the following query and click on Go: ALTER TABLE my_table ENGINE = InnoDB; If the query is executed properly, the database engine of the table will be changed to InnoDB.
SHOW TABLE STATUS WHERE Name = 'xxx'
This will give you (among other things) an Engine column, which is what you want.
197
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
