MySQL 8.0 Release Notes
MySQL 8.0 Source Code Documentation
The PLUGINS table provides
information about server plugins.
The PLUGINS table has these columns:
PLUGIN_NAMEThe name used to refer to the plugin in statements such as
INSTALL PLUGINandUNINSTALL PLUGIN.PLUGIN_VERSIONThe version from the plugin's general type descriptor.
PLUGIN_STATUSThe plugin status, one of
ACTIVE,INACTIVE,DISABLED,DELETING, orDELETED.PLUGIN_TYPEThe type of plugin, such as
STORAGE ENGINE,INFORMATION_SCHEMA, orAUTHENTICATION.PLUGIN_TYPE_VERSIONThe version from the plugin's type-specific descriptor.
PLUGIN_LIBRARYThe name of the plugin shared library file. This is the name used to refer to the plugin file in statements such as
INSTALL PLUGINandUNINSTALL PLUGIN. This file is located in the directory named by theplugin_dirsystem variable. If the library name isNULL, the plugin is compiled in and cannot be uninstalled withUNINSTALL PLUGIN.PLUGIN_LIBRARY_VERSIONThe plugin API interface version.
PLUGIN_AUTHORThe plugin author.
PLUGIN_DESCRIPTIONA short description of the plugin.
PLUGIN_LICENSEHow the plugin is licensed (for example,
GPL).LOAD_OPTIONHow the plugin was loaded. The value is
OFF,ON,FORCE, orFORCE_PLUS_PERMANENT. See Section 5.6.1, “Installing and Uninstalling Plugins”.
Notes
The
PLUGINStable is a nonstandardINFORMATION_SCHEMAtable.For plugins installed with
INSTALL PLUGIN, thePLUGIN_NAMEandPLUGIN_LIBRARYvalues are also registered in themysql.plugintable.For information about plugin data structures that form the basis of the information in the
PLUGINStable, see Section 29.2, “The MySQL Plugin API”.
Plugin information is also available from the
SHOW PLUGINS statement. See
Section 13.7.6.25, “SHOW PLUGINS Syntax”. These statements are equivalent:
SELECT
PLUGIN_NAME, PLUGIN_STATUS, PLUGIN_TYPE,
PLUGIN_LIBRARY, PLUGIN_LICENSE
FROM INFORMATION_SCHEMA.PLUGINS;
SHOW PLUGINS;