MySQL Engine

To see what storage engine is used by the server by default:

mysql> show variables like '%storage_engine';

To find out what storage engine your tables are using by schema:

mysql> select TABLE_SCHEMA, TABLE_NAME, ENGINE from information_schema.tables;