14.1.3 Verifying that InnoDB is the Default Storage Engine
Issue the SHOW ENGINES
statement to view the available MySQL storage engines. Look for DEFAULT
in the InnoDB
line.
mysql> SHOW ENGINES;
Alternatively, query the INFORMATION_SCHEMA.ENGINES
table.
mysql> SELECT * FROM INFORMATION_SCHEMA.ENGINES;