MySQL 8.3 Release Notes
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 7.6.1, “Installing and Uninstalling Plugins”.
Notes
-
PLUGINSis 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 The MySQL Plugin API.
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;