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 |
MySQL extension |
Notes:
The PLUGINS
table is a
nonstandard table.
PLUGIN_NAME
is the name used to refer to
the plugin in statements such as INSTALL
PLUGIN
and UNINSTALL
PLUGIN
.
PLUGIN_VERSION
is the version from the
plugin's general type descriptor.
PLUGIN_STATUS
indicates the plugin status,
one of ACTIVE
, INACTIVE
,
DISABLED
, or DELETED
.
PLUGIN_TYPE
indicates the type of plugin,
such as STORAGE ENGINE
or
INFORMATION_SCHEMA
.
PLUGIN_TYPE_VERSION
is the version from the
plugin's type-specific descriptor.
PLUGIN_LIBRARY
is the name of the plugin
shared object file. This is the name used to refer to the
plugin file in statements such as INSTALL
PLUGIN
and UNINSTALL
PLUGIN
. This file is located in the directory named
by the plugin_dir
system
variable. If the library name is NULL
, the
plugin is compiled in and cannot be uninstalled with
UNINSTALL 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
.
For plugins installed with INSTALL
PLUGIN
, the PLUGIN_NAME
and
PLUGIN_LIBARY
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 22.2, “The MySQL Plugin API”.
Plugin information is also available using the
SHOW PLUGINS
statement. See
Section 12.4.5.26, “SHOW PLUGINS
Syntax”.
User Comments
Add your own comment.