SHOW PLUGINS

List installed server plugins. View the name, status, type, and library file for each active plugin.

Syntax

SHOW PLUGINS;

Description

SHOW PLUGINS displays information about installed plugins. The Library column indicates the plugin library - if it is NULL, the plugin is built-in and cannot be uninstalled.

The PLUGINS table in the information_schema database contains more detailed information.

For specific information about storage engines (a particular type of plugin), see the information_schema.ENGINES table and the SHOW ENGINES statement.

Examples

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_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 | +----------------------------+----------+--------------------+-------------+---------+

See Also

• List of Plugins

• Plugin Overview

• INFORMATION_SCHEMA.PLUGINS Table

• INSTALL PLUGIN

• INFORMATION_SCHEMA.ALL_PLUGINS Table (all plugins, installed or not)

• INSTALL SONAME

• UNINSTALL PLUGIN

• UNINSTALL SONAME

_{This page is licensed: GPLv2, originally from fill_help_tables.sql}