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

URL: https://mariadb.com/kb/en/show-plugins/