How can I check MySQL engine type for a specific table?
SHOW CREATE TABLE <tablename>;
Less parseable but more readable than SHOW TABLE STATUS
.
SHOW TABLE STATUS WHERE Name = 'xxx'
This will give you (among other things) an Engine
column, which is what you want.
To show a list of all the tables in a database and their engines, use this SQL query:
SELECT TABLE_NAME,
ENGINE
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'dbname';
Replace dbname
with your database name.