Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 35.1Mb
PDF (A4) - 35.2Mb
Man Pages (TGZ) - 255.8Kb
Man Pages (Zip) - 360.8Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

MySQL 5.7 Reference Manual  /  ...  /  Verifying that InnoDB is the Default Storage Engine

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 SUPPORT column.

Press CTRL+C to copy
mysql> SHOW ENGINES;

Alternatively, query the Information Schema ENGINES table.

Press CTRL+C to copy
mysql> SELECT * FROM INFORMATION_SCHEMA.ENGINES;