> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/all-plugins-table-information-schema.md).

# Information Schema ALL\_PLUGINS Table

## Description

The [Information Schema](/docs/server/reference/system-tables/information-schema.md) `ALL_PLUGINS` table contains information about [server plugins](/docs/server/reference/plugins.md), 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="/pages/xrSGScA0IcbzH0p9P6k8#plugin_dir">plugin_dir</a> system variable, and used by the <a href="/pages/SKUQBnv7kLk3GoYGF4HQ">INSTALL PLUGIN</a> and <a href="/pages/3F4i3fyYrxH3kzKTSLQ2">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="/pages/supdhvkisHlRkiVk4061#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](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-plugins-soname.md) statement, as well as the [information\_schema.PLUGINS](/docs/server/reference/system-tables/information-schema/information-schema-tables/plugins-table-information-schema.md) table. For specific information about storage engines (a particular type of plugin), see the [Information Schema ENGINES table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-engines-table.md) and the [SHOW ENGINES](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engines.md) 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" %}