MySQL 5.6 Reference Manual Including MySQL NDB Cluster 7.3-7.4 Reference Guide
SHOW PLUGINS
SHOW PLUGINS
displays information
about server plugins.
Example of SHOW PLUGINS
output:
mysql> SHOW PLUGINS\G
*************************** 1. row ***************************
Name: binlog
Status: ACTIVE
Type: STORAGE ENGINE
Library: NULL
License: GPL
*************************** 2. row ***************************
Name: CSV
Status: ACTIVE
Type: STORAGE ENGINE
Library: NULL
License: GPL
*************************** 3. row ***************************
Name: MEMORY
Status: ACTIVE
Type: STORAGE ENGINE
Library: NULL
License: GPL
*************************** 4. row ***************************
Name: MyISAM
Status: ACTIVE
Type: STORAGE ENGINE
Library: NULL
License: GPL
...
SHOW PLUGINS
output has these
columns:
Name
The name used to refer to the plugin in statements such as
INSTALL PLUGIN
and
UNINSTALL PLUGIN
.
Status
The plugin status, one of ACTIVE
,
INACTIVE
, DISABLED
, or
DELETED
.
Type
The type of plugin, such as STORAGE
ENGINE
, INFORMATION_SCHEMA
, or
AUTHENTICATION
.
Library
The name of the plugin shared library 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
.
License
How the plugin is licensed (for example,
GPL
).
For plugins installed with INSTALL
PLUGIN
, the Name
and
Library
values are also registered in the
mysql.plugin
system table.
For information about plugin data structures that form the basis
of the information displayed by SHOW
PLUGINS
, see The MySQL Plugin API.
Plugin information is also available from the
INFORMATION_SCHEMA
.PLUGINS
table. See
Section 21.15, “The INFORMATION_SCHEMA PLUGINS Table”.