Spec-Zone .ru
спецификации, руководства, описания, API

20.15. The INFORMATION_SCHEMA PLUGINS Table

The PLUGINS table provides information about server plugins.

INFORMATION_SCHEMA Name SHOW Name Remarks
PLUGIN_NAME Name MySQL extension
PLUGIN_VERSION MySQL extension
PLUGIN_STATUS Status MySQL extension
PLUGIN_TYPE Type MySQL extension
PLUGIN_TYPE_VERSION MySQL extension
PLUGIN_LIBRARY Library MySQL extension
PLUGIN_LIBRARY_VERSION MySQL extension
PLUGIN_AUTHOR MySQL extension
PLUGIN_DESCRIPTION MySQL extension
PLUGIN_LICENSE License MySQL extension
LOAD_OPTION MySQL extension

Notes:

For plugins installed with INSTALL PLUGIN, the PLUGIN_NAME and PLUGIN_LIBRARY values are also registered in the mysql.plugin table.

These statements are equivalent:

SELECT  PLUGIN_NAME, PLUGIN_STATUS, PLUGIN_TYPE,  PLUGIN_LIBRARY, PLUGIN_LICENSEFROM INFORMATION_SCHEMA.PLUGINS;SHOW PLUGINS;

For information about plugin data structures that form the basis of the information in the PLUGINS table, see Section 23.2, "The MySQL Plugin API".

Plugin information is also available using the SHOW PLUGINS statement. See Section 13.7.5.26, "SHOW PLUGINS Syntax".