# Information Schema ALL\_PLUGINS Table

## Description

The [Information Schema](https://mariadb.com/docs/server/reference/system-tables/information-schema) `ALL_PLUGINS` table contains information about [server plugins](https://mariadb.com/docs/server/reference/plugins), whether installed or not.

It contains the following columns:

<table data-header-hidden="false" data-header-sticky><thead><tr><th>Column</th><th>Description</th></tr></thead><tbody><tr><td>PLUGIN_NAME</td><td>Name of the plugin.</td></tr><tr><td>PLUGIN_VERSION</td><td>Version from the plugin's general type descriptor.</td></tr><tr><td>PLUGIN_STATUS</td><td>Plugin status, one of ACTIVE, INACTIVE, DISABLED, DELETED or NOT INSTALLED.</td></tr><tr><td>PLUGIN_TYPE</td><td>Plugin type; STORAGE ENGINE, INFORMATION_SCHEMA, AUTHENTICATION, REPLICATION, DAEMON or AUDIT.</td></tr><tr><td>PLUGIN_TYPE_VERSION</td><td>Version from the plugin's type-specific descriptor.</td></tr><tr><td>PLUGIN_LIBRARY</td><td>Plugin's shared object file name, located in the directory specified by the <a href="../../../../../server-management/variables-and-modes/server-system-variables#plugin_dir">plugin_dir</a> system variable, and used by the <a href="../../../sql-statements/administrative-sql-statements/plugin-sql-statements/install-plugin">INSTALL PLUGIN</a> and <a href="../../../sql-statements/administrative-sql-statements/plugin-sql-statements/uninstall-plugin">UNINSTALL PLUGIN</a> statements. NULL if the plugin is complied in and cannot be uninstalled.</td></tr><tr><td>PLUGIN_LIBRARY_VERSION</td><td>Version from the plugin's API interface.</td></tr><tr><td>PLUGIN_AUTHOR</td><td>Author of the plugin.</td></tr><tr><td>PLUGIN_DESCRIPTION</td><td>Description.</td></tr><tr><td>PLUGIN_LICENSE</td><td>Plugin's licence.</td></tr><tr><td>LOAD_OPTION</td><td>How the plugin was loaded; one of OFF, ON, FORCE or FORCE_PLUS_PERMANENT. See <a href="../../../../plugins/plugin-overview#installing-plugins">Installing Plugins</a>.</td></tr><tr><td>PLUGIN_MATURITY</td><td>Plugin's maturity level; one of Unknown, Experimental, Alpha, Beta,'Gamma, and Stable.</td></tr><tr><td>PLUGIN_AUTH_VERSION</td><td>Plugin's version as determined by the plugin author. An example would be '0.99 beta 1'.</td></tr></tbody></table>

It provides a superset of the information shown by the [SHOW PLUGINS SONAME](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-plugins-soname) statement, as well as the [information\_schema.PLUGINS](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/plugins-table-information-schema) table. For specific information about storage engines (a particular type of plugin), see the [Information Schema ENGINES table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-engines-table) and the [SHOW ENGINES](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engines) statement.

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

## Example

```sql
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
```

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}