Information Schema ALL_PLUGINS Table

Description

The Information Schema ALL_PLUGINS table contains information about server plugins, whether installed or not.

It contains the following columns:

Column	Description
PLUGIN_NAME	Name of the plugin.
PLUGIN_VERSION	Version from the plugin's general type descriptor.
PLUGIN_STATUS	Plugin status, one of ACTIVE, INACTIVE, DISABLED, DELETED or NOT INSTALLED.
PLUGIN_TYPE	Plugin type; STORAGE ENGINE, INFORMATION_SCHEMA, AUTHENTICATION, REPLICATION, DAEMON or AUDIT.
PLUGIN_TYPE_VERSION	Version from the plugin's type-specific descriptor.
PLUGIN_LIBRARY	Plugin's shared object file name, located in the directory specified by the plugin_dir system variable, and used by the INSTALL PLUGIN and UNINSTALL PLUGIN statements. NULL if the plugin is complied in and cannot be uninstalled.
PLUGIN_LIBRARY_VERSION	Version from the plugin's API interface.
PLUGIN_AUTHOR	Author of the plugin.
PLUGIN_DESCRIPTION	Description.
PLUGIN_LICENSE	Plugin's licence.
LOAD_OPTION	How the plugin was loaded; one of OFF, ON, FORCE or FORCE_PLUS_PERMANENT. See Installing Plugins.
PLUGIN_MATURITY	Plugin's maturity level; one of Unknown, Experimental, Alpha, Beta,'Gamma, and Stable.
PLUGIN_AUTH_VERSION	Plugin's version as determined by the plugin author. An example would be '0.99 beta 1'.

It provides a superset of the information shown by the SHOW PLUGINS SONAME statement, as well as the information_schema.PLUGINS table. For specific information about storage engines (a particular type of plugin), see the Information Schema ENGINES table and the SHOW ENGINES statement.

The table is not a standard Information Schema table, and is a MariaDB extension.

Example

SELECT * FROM information_schema.all_plugins\G *************************** 1. row ***************************  PLUGIN_NAME: binlog  PLUGIN_VERSION: 1.0  PLUGIN_STATUS: ACTIVE  PLUGIN_TYPE: STORAGE ENGINE  PLUGIN_TYPE_VERSION: 100314.0  PLUGIN_LIBRARY: NULL PLUGIN_LIBRARY_VERSION: NULL  PLUGIN_AUTHOR: MySQL AB  PLUGIN_DESCRIPTION: This is a pseudo storage engine to represent the binlog in a transaction  PLUGIN_LICENSE: GPL  LOAD_OPTION: FORCE  PLUGIN_MATURITY: Stable  PLUGIN_AUTH_VERSION: 1.0 *************************** 2. row ***************************  PLUGIN_NAME: mysql_native_password  PLUGIN_VERSION: 1.0  PLUGIN_STATUS: ACTIVE  PLUGIN_TYPE: AUTHENTICATION  PLUGIN_TYPE_VERSION: 2.1  PLUGIN_LIBRARY: NULL PLUGIN_LIBRARY_VERSION: NULL  PLUGIN_AUTHOR: R.J.Silk, Sergei Golubchik  PLUGIN_DESCRIPTION: Native MySQL authentication  PLUGIN_LICENSE: GPL  LOAD_OPTION: FORCE  PLUGIN_MATURITY: Stable  PLUGIN_AUTH_VERSION: 1.0 *************************** 3. row ***************************  PLUGIN_NAME: mysql_old_password  PLUGIN_VERSION: 1.0  PLUGIN_STATUS: ACTIVE  PLUGIN_TYPE: AUTHENTICATION  PLUGIN_TYPE_VERSION: 2.1  PLUGIN_LIBRARY: NULL PLUGIN_LIBRARY_VERSION: NULL  PLUGIN_AUTHOR: R.J.Silk, Sergei Golubchik  PLUGIN_DESCRIPTION: Old MySQL-4.0 authentication  PLUGIN_LICENSE: GPL  LOAD_OPTION: FORCE  PLUGIN_MATURITY: Stable  PLUGIN_AUTH_VERSION: 1.0 ... *************************** 104. row ***************************  PLUGIN_NAME: WSREP_MEMBERSHIP  PLUGIN_VERSION: 1.0  PLUGIN_STATUS: NOT INSTALLED  PLUGIN_TYPE: INFORMATION SCHEMA  PLUGIN_TYPE_VERSION: 100314.0  PLUGIN_LIBRARY: wsrep_info.so PLUGIN_LIBRARY_VERSION: 1.13  PLUGIN_AUTHOR: Nirbhay Choubey  PLUGIN_DESCRIPTION: Information about group members  PLUGIN_LICENSE: GPL  LOAD_OPTION: OFF  PLUGIN_MATURITY: Stable  PLUGIN_AUTH_VERSION: 1.0 *************************** 105. row ***************************  PLUGIN_NAME: WSREP_STATUS  PLUGIN_VERSION: 1.0  PLUGIN_STATUS: NOT INSTALLED  PLUGIN_TYPE: INFORMATION SCHEMA  PLUGIN_TYPE_VERSION: 100314.0  PLUGIN_LIBRARY: wsrep_info.so PLUGIN_LIBRARY_VERSION: 1.13  PLUGIN_AUTHOR: Nirbhay Choubey  PLUGIN_DESCRIPTION: Group view information  PLUGIN_LICENSE: GPL  LOAD_OPTION: OFF  PLUGIN_MATURITY: Stable

_{This page is licensed: CC BY-SA / Gnu FDL}