PLUGINS table provides
information about server plugins.
PLUGINS table has these columns:
The name used to refer to the plugin in statements such as
The version from the plugin's general type descriptor.
The plugin status, one of
The type of plugin, such as
The version from the plugin's type-specific descriptor.
The name of the plugin shared library file. This is the name used to refer to the plugin file in statements such as
UNINSTALL PLUGIN. This file is located in the directory named by the
plugin_dirsystem variable. If the library name is
NULL, the plugin is compiled in and cannot be uninstalled with
The plugin API interface version.
The plugin author.
A short description of the plugin.
How the plugin is licensed (for example,
How the plugin was loaded. The value is
FORCE_PLUS_PERMANENT. See Installing and Uninstalling Plugins.
PLUGINSis a nonstandard
For plugins installed with
INSTALL PLUGIN, the
PLUGIN_LIBRARYvalues are also registered in the
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
SHOW PLUGINS Statement. These statements are equivalent:
SELECT PLUGIN_NAME, PLUGIN_STATUS, PLUGIN_TYPE, PLUGIN_LIBRARY, PLUGIN_LICENSE FROM INFORMATION_SCHEMA.PLUGINS; SHOW PLUGINS;