Documentation Home
MySQL 8.4 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 39.8Mb
PDF (A4) - 39.9Mb
Man Pages (TGZ) - 257.9Kb
Man Pages (Zip) - 364.9Kb
Info (Gzip) - 4.0Mb
Info (Zip) - 4.0Mb


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

17.1.3 验证 InnoDB 是否为默认存储引擎

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;