17.1.3 Verifying that InnoDB is the Default Storage Engine

Skip to Main Content

MySQL 8.4 Reference Manual Including MySQL NDB Cluster 8.4

17.1.3 Verifying that InnoDB is the Default Storage Engine

Issue a SHOW ENGINES statement to view the available MySQL storage engines. Look for DEFAULT in the SUPPORT column.

mysql> SHOW ENGINES;

Alternatively, query the Information Schema ENGINES table.

mysql> SELECT * FROM INFORMATION_SCHEMA.ENGINES;