Documentation Home
MySQL 8.3 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.8Mb
PDF (A4) - 40.9Mb
Man Pages (TGZ) - 294.0Kb
Man Pages (Zip) - 409.0Kb
Info (Gzip) - 4.0Mb
Info (Zip) - 4.0Mb
Excerpts from this Manual

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

17.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;