content_image/808725.jpg
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: 

• Engine 

The name of the storage engine. 

• Support 

<img src='content_image/808725.jpg'>

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 . 

