The Information Schema PLUGINS
table contains information about server plugins.
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 or DELETED . |
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 Introduced in MariaDB 5.2.1. |
PLUGIN_AUTH_VERSION |
Plugin's version as determined by the plugin author. An example would be '0.99 beta 1'. Introduced in MariaDB 5.2.1 |
It provides a superset of the information shown by the SHOW PLUGINS
statement. For specific information about storage engines (a particular type of plugins), see the information_schema.ENGINES
table and the SHOW ENGINES
statement.
This table provides a subset of the Information Schema information_schema.ALL_PLUGINS
table, which contains all available plugins, installed or not.
The table is not a standard Information Schema table, and is a MySQL and MariaDB extension.
The easiest way to get basic information on plugins is with SHOW PLUGINS
:
SHOW PLUGINS; +----------------------------+----------+--------------------+-------------+---------+ | Name | Status | Type | Library | License | +----------------------------+----------+--------------------+-------------+---------+ | binlog | ACTIVE | STORAGE ENGINE | NULL | GPL | | mysql_native_password | ACTIVE | AUTHENTICATION | NULL | GPL | | mysql_old_password | ACTIVE | AUTHENTICATION | NULL | GPL | | MRG_MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL | | MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL | | CSV | ACTIVE | STORAGE ENGINE | NULL | GPL | | MEMORY | ACTIVE | STORAGE ENGINE | NULL | GPL | | FEDERATED | ACTIVE | STORAGE ENGINE | NULL | GPL | | PERFORMANCE_SCHEMA | ACTIVE | STORAGE ENGINE | NULL | GPL | | Aria | ACTIVE | STORAGE ENGINE | NULL | GPL | | InnoDB | ACTIVE | STORAGE ENGINE | NULL | GPL | | INNODB_TRX | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | INNODB_LOCKS | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | INNODB_LOCK_WAITS | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | INNODB_CMP | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | INNODB_CMP_RESET | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | INNODB_CMPMEM | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | INNODB_CMPMEM_RESET | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | INNODB_BUFFER_PAGE | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | INNODB_BUFFER_PAGE_LRU | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | INNODB_BUFFER_POOL_STATS | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | INNODB_METRICS | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | INNODB_FT_DEFAULT_STOPWORD | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | INNODB_FT_INSERTED | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | INNODB_FT_DELETED | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | INNODB_FT_BEING_DELETED | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | INNODB_FT_CONFIG | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | INNODB_FT_INDEX_CACHE | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | INNODB_FT_INDEX_TABLE | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | INNODB_SYS_TABLES | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | INNODB_SYS_TABLESTATS | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | INNODB_SYS_INDEXES | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | INNODB_SYS_COLUMNS | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | INNODB_SYS_FIELDS | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | INNODB_SYS_FOREIGN | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | INNODB_SYS_FOREIGN_COLS | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | SPHINX | ACTIVE | STORAGE ENGINE | NULL | GPL | | ARCHIVE | ACTIVE | STORAGE ENGINE | NULL | GPL | | BLACKHOLE | ACTIVE | STORAGE ENGINE | NULL | GPL | | FEEDBACK | DISABLED | INFORMATION SCHEMA | NULL | GPL | | partition | ACTIVE | STORAGE ENGINE | NULL | GPL | | pam | ACTIVE | AUTHENTICATION | auth_pam.so | GPL | +----------------------------+----------+--------------------+-------------+---------+
SELECT LOAD_OPTION FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE 'tokudb'; Empty set
The equivalent SELECT query would be:
SELECT PLUGIN_NAME, PLUGIN_STATUS, PLUGIN_TYPE, PLUGIN_LIBRARY, PLUGIN_LICENSE FROM INFORMATION_SCHEMA.PLUGINS;
Other SELECT
queries can be used to see additional information. For example:
SELECT PLUGIN_NAME, PLUGIN_DESCRIPTION, PLUGIN_MATURITY, PLUGIN_AUTH_VERSION FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_TYPE='STORAGE ENGINE' ORDER BY PLUGIN_MATURITY \G *************************** 1. row *************************** PLUGIN_NAME: FEDERATED PLUGIN_DESCRIPTION: FederatedX pluggable storage engine PLUGIN_MATURITY: Beta PLUGIN_AUTH_VERSION: 2.1 *************************** 2. row *************************** PLUGIN_NAME: Aria PLUGIN_DESCRIPTION: Crash-safe tables with MyISAM heritage PLUGIN_MATURITY: Gamma PLUGIN_AUTH_VERSION: 1.5 *************************** 3. row *************************** PLUGIN_NAME: PERFORMANCE_SCHEMA PLUGIN_DESCRIPTION: Performance Schema PLUGIN_MATURITY: Gamma PLUGIN_AUTH_VERSION: 0.1 *************************** 4. row *************************** PLUGIN_NAME: binlog PLUGIN_DESCRIPTION: This is a pseudo storage engine to represent the binlog in a transaction PLUGIN_MATURITY: Stable PLUGIN_AUTH_VERSION: 1.0 *************************** 5. row *************************** PLUGIN_NAME: MEMORY PLUGIN_DESCRIPTION: Hash based, stored in memory, useful for temporary tables PLUGIN_MATURITY: Stable PLUGIN_AUTH_VERSION: 1.0 *************************** 6. row *************************** PLUGIN_NAME: MyISAM PLUGIN_DESCRIPTION: MyISAM storage engine PLUGIN_MATURITY: Stable PLUGIN_AUTH_VERSION: 1.0 *************************** 7. row *************************** PLUGIN_NAME: MRG_MyISAM PLUGIN_DESCRIPTION: Collection of identical MyISAM tables PLUGIN_MATURITY: Stable PLUGIN_AUTH_VERSION: 1.0 *************************** 8. row *************************** PLUGIN_NAME: CSV PLUGIN_DESCRIPTION: CSV storage engine PLUGIN_MATURITY: Stable PLUGIN_AUTH_VERSION: 1.0 *************************** 9. row *************************** PLUGIN_NAME: InnoDB PLUGIN_DESCRIPTION: Supports transactions, row-level locking, and foreign keys PLUGIN_MATURITY: Stable PLUGIN_AUTH_VERSION: 1.2.5 *************************** 10. row *************************** PLUGIN_NAME: BLACKHOLE PLUGIN_DESCRIPTION: /dev/null storage engine (anything you write to it disappears) PLUGIN_MATURITY: Stable PLUGIN_AUTH_VERSION: 1.0 *************************** 11. row *************************** PLUGIN_NAME: ARCHIVE PLUGIN_DESCRIPTION: Archive storage engine PLUGIN_MATURITY: Stable PLUGIN_AUTH_VERSION: 1.0 *************************** 12. row *************************** PLUGIN_NAME: partition PLUGIN_DESCRIPTION: Partition Storage Engine Helper PLUGIN_MATURITY: Stable PLUGIN_AUTH_VERSION: 1.0
Check if a given plugin is available:
SELECT LOAD_OPTION FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE 'tokudb'; Empty set
Show authentication plugins:
SELECT PLUGIN_NAME, LOAD_OPTION FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_TYPE LIKE 'authentication' \G *************************** 1. row *************************** PLUGIN_NAME: mysql_native_password LOAD_OPTION: FORCE *************************** 2. row *************************** PLUGIN_NAME: mysql_old_password LOAD_OPTION: FORCE
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/information-schema-plugins-table/