SHOW [STORAGE] ENGINES
SHOW ENGINES displays status information about the server's storage engines. 显示有关服务器存储引擎的状态信息。This is particularly useful for checking whether a storage engine is supported, or to see what the default engine is.这对于检查是否支持存储引擎或查看默认引擎是什么特别有用。
For information about MySQL storage engines, see Chapter 15, The InnoDB Storage Engine, and Chapter 16, Alternative Storage Engines.有关MySQL存储引擎的信息，请参阅第15章，“InnoDB存储引擎”和第16章，“替代存储引擎”。
mysql> SHOW ENGINES\G
*************************** 1. row ***************************
Engine: ARCHIVE
Support: YES
Comment: Archive storage engine
Transactions: NO
XA: NO
Savepoints: NO
*************************** 2. row ***************************
Engine: BLACKHOLE
Support: YES
Comment: /dev/null storage engine (anything you write to it disappears)
Transactions: NO
XA: NO
Savepoints: NO
*************************** 3. row ***************************
Engine: MRG_MYISAM
Support: YES
Comment: Collection of identical MyISAM tables
Transactions: NO
XA: NO
Savepoints: NO
*************************** 4. row ***************************
Engine: FEDERATED
Support: NO
Comment: Federated MySQL storage engine
Transactions: NULL
XA: NULL
Savepoints: NULL
*************************** 5. row ***************************
Engine: MyISAM
Support: YES
Comment: MyISAM storage engine
Transactions: NO
XA: NO
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的输出可能因所使用的MySQL版本和其他因素而异。
SHOW ENGINES output 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.服务器对存储引擎的支持级别，如下表所示。
| Value | Meaning |
|---|---|
YES | |
DEFAULT | YES, plus this is the default engineYES，加上这是默认引擎 |
NO | |
DISABLED |
A value of 值NO means that the server was compiled without support for the engine, so it cannot be enabled at runtime.NO表示编译服务器时不支持引擎，因此无法在运行时启用。
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. DISABLED值的原因可能是服务器启动时使用了禁用引擎的选项，也可能是因为没有提供启用引擎所需的所有选项。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”.请参阅第5.4.2节，“错误日志”。
You might also see 如果服务器是为了支持它而编译的，但是使用DISABLED for a storage engine if the server was compiled to support it, but was started with a --skip- option. engine_name--skip-engine_name选项启动的，那么您可能还会看到存储引擎的DISABLED。For the 对于NDB存储引擎，NDB storage engine, DISABLED means the server was compiled with support for NDB Cluster, but was not started with the --ndbcluster option.DISABLED表示服务器是在支持NDB Cluster的情况下编译的，但不是使用--ndbcluster选项启动的。
All MySQL servers support 所有MySQL服务器都支持MyISAM tables. It is not possible to disable MyISAM.MyISAM表。无法禁用MyISAM。
Comment
A brief description of the storage engine.存储引擎的简要说明。
Transactions
Whether the storage engine supports transactions.存储引擎是否支持事务。
XA
Whether the storage engine supports XA transactions.存储引擎是否支持XA事务。
Savepoints
Whether the storage engine supports savepoints.存储引擎是否支持保存点。
Storage engine information is also available from the 存储引擎信息也可从INFORMATION_SCHEMA ENGINES table. INFORMATION_SCHEMA ENGINES表中获得。See Section 26.3.13, “The INFORMATION_SCHEMA ENGINES Table”.请参阅第26.3.13节，“INFORMATION_SCHEMA ENGINES表”。