Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 43.3Mb
PDF (A4) - 43.4Mb
Man Pages (TGZ) - 297.3Kb
Man Pages (Zip) - 402.5Kb
Info (Gzip) - 4.3Mb
Info (Zip) - 4.3Mb
Excerpts from this Manual

MySQL 8.0 Reference Manual  / ...  / INFORMATION_SCHEMA Tables  / INFORMATION_SCHEMA General Tables  /  The INFORMATION_SCHEMA ENGINES Table

28.3.13 The INFORMATION_SCHEMA ENGINES Table

TheENGINES 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.

TheENGINES table has these columns:

  • ENGINE

    The name of the storage engine.

  • SUPPORT

    The server's level of support for the storage engine, as shown in the following table.

    ValueMeaning
    YESThe engine is supported and is active
    DEFAULTLikeYES, plus this is the default engine
    NOThe engine is not supported
    DISABLEDThe engine is supported but has been disabled

    A value ofNO means that the server was compiled without support for the engine, so it cannot be enabled at runtime.

    A value ofDISABLED occurs either because the server was started with an option that disables the engine, or because not all options required to enable it were given. In the latter case, the error log should contain a reason indicating why the option is disabled. SeeSection 7.4.2, “The Error Log”.

    You might also seeDISABLED for a storage engine if the server was compiled to support it, but was started with a--skip-engine_name option. For theNDB storage engine,DISABLED means the server was compiled with support for NDB Cluster, but was not started with the--ndbcluster option.

    All MySQL servers supportMyISAM tables. It is not possible to disableMyISAM.

  • COMMENT

    A brief description of the storage engine.

  • TRANSACTIONS

    Whether the storage engine supports transactions.

  • XA

    Whether the storage engine supports XA transactions.

  • SAVEPOINTS

    Whether the storage engine supports savepoints.

Notes

  • ENGINES is a nonstandardINFORMATION_SCHEMA table.

Storage engine information is also available from theSHOW ENGINES statement. SeeSection 15.7.7.16, “SHOW ENGINES Statement”. The following statements are equivalent:

SELECT * FROM INFORMATION_SCHEMA.ENGINESSHOW ENGINES