MariaDB starting with 10.0.2

The ALL_PLUGINS table was introduced in MariaDB 10.0.2

Description

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

It contains the following columns:

ColumnDescription
PLUGIN_NAMEName of the plugin.
PLUGIN_VERSIONVersion from the plugin's general type descriptor.
PLUGIN_STATUSPlugin status, one of ACTIVE, INACTIVE, DISABLED, DELETED or NOT INSTALLED.
PLUGIN_TYPEPlugin type; STORAGE ENGINE, INFORMATION_SCHEMA, AUTHENTICATION, REPLICATION, DAEMON or AUDIT.
PLUGIN_TYPE_VERSIONVersion from the plugin's type-specific descriptor.
PLUGIN_LIBRARYPlugin'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_VERSIONVersion from the plugin's API interface.
PLUGIN_AUTHORAuthor of the plugin.
PLUGIN_DESCRIPTIONDescription.
PLUGIN_LICENSEPlugin's licence.
LOAD_OPTIONHow the plugin was loaded; one of OFF, ON, FORCE or FORCE_PLUS_PERMANENT. See Installing Plugins.
PLUGIN_MATURITYPlugin's maturity level; one of Unknown, Experimental, Alpha, Beta,'Gamma, and Stable.
PLUGIN_AUTH_VERSIONPlugin'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.

Comments

Comments loading...