SHOW PLUGINS
SHOW PLUGINS displays information
about server plugins. Plugin information is also available in
the INFORMATION_SCHEMA.PLUGINS table. See
Section 20.17, “The INFORMATION_SCHEMA PLUGINS Table”.
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 returns the
following columns:
Name: The name used to refer to the plugin in statements such asINSTALL PLUGINandUNINSTALL PLUGIN.Status: The plugin status, one ofACTIVE,INACTIVE,DISABLED, orDELETED.Type: The type of plugin, such asSTORAGE ENGINEorINFORMATION_SCHEMA.Library: The name of the plugin shared object file. This is the name used to refer to the plugin file in statements such asINSTALL 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.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 table.
For information about plugin data structures that form the basis
of the information displayed by SHOW
PLUGINS, see Section 23.2, “The MySQL Plugin API”.