SHOW Statements Savepoints: NO *************************** 6. row *************************** Engine: PERFORMANCE_SCHEMA Support: YES Comment: Performance Schema Transactions: NO XA: NO Savepoints: NO *************************** 7. row *************************** Engine: InnoDB Support: DEFAULT Comment: Supports transactions, row-level locking, and foreign keys Transactions: YES XA: YES Savepoints: YES *************************** 8. row *************************** Engine: MEMORY Support: YES Comment: Hash based, stored in memory, useful for temporary tables Transactions: NO XA: NO Savepoints: NO *************************** 9. row *************************** Engine: CSV Support: YES Comment: CSV storage engine Transactions: NO XA: NO Savepoints: NO The output from  SHOW ENGINES  may vary according to the MySQL version used and other factors. SHOW ENGINES  output has these columns: The name of the storage engine. A value of  NO  means that the server was compiled without support for the engine, so it cannot be enabled at runtime. A value of  DISABLED  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. See Section 5.4.2, “The Error Log” . You might also see  DISABLED  for a storage engine if the server was compiled to support it, but was started with a  --skip- engine_name  option. For the  NDB  storage engine,  DISABLED  means the server was compiled with support for NDB Cluster, but was not started with the  --ndbcluster  option. All MySQL servers support  MyISAM  tables. It is not possible to disable  MyISAM . 2928 • Engine • Support The server’s level of support for the storage engine, as shown in the following table. Value Meaning YES The engine is supported and is active DEFAULT Like  YES , plus this is the default engine NO The engine is not supported DISABLED The engine is supported but has been disabled