MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0

25.9 The INFORMATION_SCHEMA ENGINES Table

The ENGINES table provides information about storage engines. This is particularly useful for checking whether a storage engine is supported, or to see what the default engine is.

The ENGINES table has these columns:

Notes

Storage engine information is also available from the SHOW ENGINES statement. See Section 13.7.6.16, “SHOW ENGINES Syntax”. The following statements are equivalent:

SELECT * FROM INFORMATION_SCHEMA.ENGINES

SHOW ENGINES