MySQL :: MySQL 8.4 参考手册 :: 28.3.13 INFORMATION

MySQL 8.4 参考手册 · 中文镜像

正文为中文，英文原文默认隐藏。点击任意中文段落即可展开 / 收起对应英文原文。

译文由机器翻译生成，仅供理解参考；有疑问请以官方英文原文为准。

MySQL 8.4 参考手册 / 28 个 INFORMATION_SCHEMA 表 / 28.3 INFORMATION_SCHEMA 总表 / 28.3.13 INFORMATION_SCHEMA ENGINES 表

中文点击中文段落可显示 / 隐藏英文原文本页译文覆盖 88%

28.3.13 INFORMATION_SCHEMA ENGINES 表28.3.13 The INFORMATION_SCHEMA ENGINES Table

ENGINES 表提供有关存储引擎的信息。这对于检查存储引擎是否受支持，或者查看默认引擎是什么特别有用。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.

ENGINES 表有以下列：The ENGINES table has these columns:

ENGINEENGINE
存储引擎的名称。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`	引擎受支持并且处于活动状态The engine is supported and is active
`DEFAULTDEFAULT`	类似 `YES`，并且这是默认引擎Like `YES`, plus this is the default engine
`NONO`	引擎不受支持The engine is not supported
`DISABLEDDISABLED`	该引擎受支持但已被禁用The engine is supported but has been disabled

值为 NO 表示服务器在编译时未启用对该引擎的支持，因此在运行时无法启用。A value of NO means that the server was compiled without support for the engine, so it cannot be enabled at runtime.

值为 DISABLED 的情况可能是因为服务器以禁用该引擎的选项启动，或者因为未提供启用它所需的所有选项。在后一种情况下，错误日志应包含指示该选项被禁用原因的信息。请参阅第 7.4.2 节，“错误日志”。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 7.4.2, “The Error Log”.

如果服务器被编译为支持某个存储引擎，但启动时使用了 --skip-engine_name 参数，你可能也会看到该存储引擎显示为 DISABLED。对于 NDB 存储引擎，DISABLED 表示服务器编译时支持 NDB Cluster，但启动时未使用 --ndbcluster 参数。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.

所有 MySQL 服务器都支持 MyISAM 表。无法禁用 MyISAM。All MySQL servers support MyISAM tables. It is not possible to disable MyISAM.

COMMENTCOMMENT
存储引擎的简要描述。A brief description of the storage engine.
TRANSACTIONSTRANSACTIONS
存储引擎是否支持事务。Whether the storage engine supports transactions.
XA
存储引擎是否支持 XA 事务。Whether the storage engine supports XA transactions.
SAVEPOINTS
存储引擎是否支持保存点。Whether the storage engine supports savepoints.

注意事项Notes

ENGINES 是一个非标准的 INFORMATION_SCHEMA 表格。ENGINES is a nonstandard INFORMATION_SCHEMA table.

存储引擎信息也可以通过 SHOW ENGINES 语句获取。参见第 15.7.7.17 节，“SHOW ENGINES 语句”。以下语句是等效的：Storage engine information is also available from the SHOW ENGINES statement. See Section 15.7.7.17, “SHOW ENGINES Statement”. The following statements are equivalent:

SELECT * FROM INFORMATION_SCHEMA.ENGINES

SHOW ENGINES

首页上一级下一节