MySQL: list storage engines and the engine of each table
SHOW ENGINES and an information_schema.TABLES query to find each table's engine.
To see which storage engines MySQL offers, then which one each table uses.
-- Available engines and the default engine
SHOW ENGINES;
-- Engine of each table
SELECT TABLE_NAME, ENGINE
FROM information_schema.TABLES;
SHOW ENGINESlists the engines (InnoDB, MyISAM, MEMORY...), their support level (YES,NO,DEFAULT) and transaction support.- The
information_schema.TABLESquery returns the engine of each table; addWHERE TABLE_SCHEMA = 'AppDb'to restrict it to one database.