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:
The
PLUGINS
table is a nonstandard table.PLUGIN_NAME
is the name used to refer to the plugin in statements such asINSTALL PLUGIN
andUNINSTALL PLUGIN
.PLUGIN_VERSION
is the version from the plugin's general type descriptor.PLUGIN_STATUS
indicates the plugin status, one ofACTIVE
,INACTIVE
,DISABLED
, orDELETED
.PLUGIN_TYPE
indicates the type of plugin, such asSTORAGE ENGINE
,INFORMATION_SCHEMA
, orAUTHENTICATION
.PLUGIN_TYPE_VERSION
is the version from the plugin's type-specific descriptor.PLUGIN_LIBRARY
is the name of the plugin shared library file. This is the name used to refer to the plugin file in statements such asINSTALL PLUGIN
andUNINSTALL PLUGIN
. This file is located in the directory named by theplugin_dir
system variable. If the library name isNULL
, the plugin is compiled in and cannot be uninstalled withUNINSTALL PLUGIN
.PLUGIN_LIBRARY_VERSION
indicates the plugin API interface version.PLUGIN_AUTHOR
names the plugin author.PLUGIN_DESCRIPTION
provides a short description of the plugin.PLUGIN_LICENSE
indicates how the plugin is licensed; for example,GPL
.LOAD_OPTION
indicates how the plugin was loaded. The value isOFF
,ON
,FORCE
, orFORCE_PLUS_PERMANENT
. See Section 5.5.1, “Installing and Uninstalling Plugins”.
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_LICENSE
FROM INFORMATION_SCHEMA.PLUGINS;
SHOW PLUGINS;
For information about plugin data structures that form the basis
of the information in the PLUGINS
table, see Section 24.2, “The MySQL Plugin API”.
Plugin information is also available using the
SHOW PLUGINS
statement. See
Section 13.7.5.26, “SHOW PLUGINS Syntax”.