> 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/the-mysql-database-tables/mysql-plugin-table.md).

# mysql.plugin Table

1. PARTITION BY SYSTEM\_TIME is not supported for transaction-precise system-versioned tables. Attempting

The `mysql.plugin` table can be queried to get information about installed [plugins](/docs/server/reference/plugins.md).

This table only contains information about [plugins](/docs/server/reference/plugins.md) that have been installed via the following methods:

* The [INSTALL SONAME](/docs/server/reference/sql-statements/administrative-sql-statements/plugin-sql-statements/install-soname.md) statement.
* The [INSTALL PLUGIN](/docs/server/reference/sql-statements/administrative-sql-statements/plugin-sql-statements/install-plugin.md) statement.
* The [mariadb-plugin](/docs/server/clients-and-utilities/administrative-tools/mariadb-plugin.md) utility.

This table does not contain information about:

* Built-in plugins.
* Plugins loaded with the [--plugin-load-add](/docs/server/server-management/starting-and-stopping-mariadb/mariadbd-options.md) option.
* Plugins loaded with the [--plugin-load](/docs/server/server-management/starting-and-stopping-mariadb/mariadbd-options.md) option.

This table only contains enough information to reload the plugin when the server is restarted, which means it only contains the plugin name and the plugin library.

This table uses the [Aria](/docs/server/server-usage/storage-engines/aria.md) storage engine.

The `mysql.plugin` table contains the following fields:

| Field | Type         | Null | Key | Default | Description                 |
| ----- | ------------ | ---- | --- | ------- | --------------------------- |
| name  | varchar(64)  | NO   | PRI |         | Plugin name.                |
| dl    | varchar(128) | NO   |     |         | Name of the plugin library. |

## Example

```sql
SELECT * FROM mysql.plugin;
+---------------------------+------------------------+
| name                      | dl                     |
+---------------------------+------------------------+
| spider                    | ha_spider.so           |
| spider_alloc_mem          | ha_spider.so           |
| METADATA_LOCK_INFO        | metadata_lock_info.so  |
| OQGRAPH                   | ha_oqgraph.so          |
| cassandra                 | ha_cassandra.so        |
| QUERY_RESPONSE_TIME       | query_response_time.so |
| QUERY_RESPONSE_TIME_AUDIT | query_response_time.so |
| LOCALES                   | locales.so             |
| sequence                  | ha_sequence.so         |
+---------------------------+------------------------+
```

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

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