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

8.4 中文镜像

MySQL 8.4 参考手册 · 中文镜像

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

打开官方英文原文 ↗

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

MySQL 8.4 参考手册 / 28 个 INFORMATION_SCHEMA 表 / 28.3 INFORMATION_SCHEMA 总表 / 28.3.22 INFORMATION_SCHEMA PLUGINS 表

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

28.3.22 INFORMATION_SCHEMA 插件表28.3.22 The INFORMATION_SCHEMA PLUGINS Table

PLUGINS 表提供有关服务器插件的信息。The PLUGINS table provides information about server plugins.

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

PLUGIN_NAME
在诸如 INSTALL PLUGIN 和 UNINSTALL PLUGIN 语句中用于引用插件的名称。The name used to refer to the plugin in statements such as INSTALL PLUGIN and UNINSTALL PLUGIN.
PLUGIN_VERSION
来自插件通用类型描述符的版本。The version from the plugin's general type descriptor.
PLUGIN_STATUS
插件状态，可以是 ACTIVE、INACTIVE、DISABLED、DELETING 或 DELETED。The plugin status, one of ACTIVE, INACTIVE, DISABLED, DELETING, or DELETED.
PLUGIN_TYPE
插件类型，例如 STORAGE ENGINE、INFORMATION_SCHEMA 或 AUTHENTICATION。The type of plugin, such as STORAGE ENGINE, INFORMATION_SCHEMA, or AUTHENTICATION.
PLUGIN_TYPE_VERSION
来自插件类型特定描述符的版本。The version from the plugin's type-specific descriptor.
PLUGIN_LIBRARY
插件共享库文件的名称。这个名称用于在诸如 INSTALL PLUGIN 和 UNINSTALL PLUGIN 语句中引用插件文件。该文件位于由 plugin_dir 系统变量指定的目录中。如果库名称为 NULL，则插件已被编译进系统，无法使用 UNINSTALL PLUGIN 卸载。The name of the plugin shared library file. This is the name used to refer to the plugin file in statements such as INSTALL PLUGIN and UNINSTALL PLUGIN. This file is located in the directory named by the plugin_dir system variable. If the library name is NULL, the plugin is compiled in and cannot be uninstalled with UNINSTALL PLUGIN.
PLUGIN_LIBRARY_VERSION
插件 API 接口版本。The plugin API interface version.
PLUGIN_AUTHOR
插件作者。The plugin author.
PLUGIN_DESCRIPTION
插件的简短描述。A short description of the plugin.
PLUGIN_LICENSE
插件的许可方式（例如，GPL）。How the plugin is licensed (for example, GPL).
LOAD_OPTION
插件的加载方式。值为 OFF、ON、FORCE 或 FORCE_PLUS_PERMANENT。参见第 7.6.1 节，“安装和卸载插件”。How the plugin was loaded. The value is OFF, ON, FORCE, or FORCE_PLUS_PERMANENT. See Section 7.6.1, “Installing and Uninstalling Plugins”.

注意事项Notes

PLUGINS 是一个非标准的 INFORMATION_SCHEMA 表。PLUGINS is a nonstandard INFORMATION_SCHEMA table.
对于使用 INSTALL PLUGIN 安装的插件，PLUGIN_NAME 和 PLUGIN_LIBRARY 的值也会在 mysql.plugin 表中注册。For plugins installed with INSTALL PLUGIN, the PLUGIN_NAME and PLUGIN_LIBRARY values are also registered in the mysql.plugin table.
有关构成 PLUGINS 表信息基础的插件数据结构的信息，请参见 MySQL 插件 API。For information about plugin data structures that form the basis of the information in the PLUGINS table, see The MySQL Plugin API.

插件信息也可以通过 SHOW PLUGINS 语句获取。参见第 15.7.7.27 节，“SHOW PLUGINS 语句”。这些语句是等价的：Plugin information is also available from the SHOW PLUGINS statement. See Section 15.7.7.27, “SHOW PLUGINS Statement”. These statements are equivalent:

SELECT
  PLUGIN_NAME, PLUGIN_STATUS, PLUGIN_TYPE,
  PLUGIN_LIBRARY, PLUGIN_LICENSE
FROM INFORMATION_SCHEMA.PLUGINS;

SHOW PLUGINS;

首页上一级下一节