Documentation Home
MySQL 9.4 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 41.2Mb
PDF (A4) - 41.3Mb
Man Pages (TGZ) - 262.8Kb
Man Pages (Zip) - 368.8Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb


MySQL 9.4 Reference Manual  / ...  / The InnoDB Storage Engine  / Introduction to InnoDB  /  Verifying that InnoDB is the Default Storage Engine

17.1.3 Verifying that InnoDB is the Default Storage Engine

Issue aSHOW ENGINES statement to view the available MySQL storage engines. Look forDEFAULT in theSUPPORT column.

mysql> SHOW ENGINES;

Alternatively, query the Information SchemaENGINES table.

mysql> SELECT * FROM INFORMATION_SCHEMA.ENGINES;