LLI Wiki — My Digital Knowledge Base

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;
Mastodon LLIMastodon SocialFosstodon