The mysql.plugin table records information about installed server plugins, ensuring they are reloaded automatically upon server startup.
The mysql.plugin table can be queried to get information about installed plugins.
This table only contains information about plugins that have been installed via the following methods:
The INSTALL SONAME statement.
The INSTALL PLUGIN statement.
The utility.
This table does not contain information about:
Built-in plugins.
Plugins loaded with the option.
Plugins loaded with the 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 storage engine.
The mysql.plugin table contains the following fields:
This page is licensed: CC BY-SA / Gnu FDL
Name of the plugin library.
name
varchar(64)
NO
PRI
Plugin name.
dl
varchar(128)
NO
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 |
+---------------------------+------------------------+System tables should not normally be edited directly. Use the related SQL statements instead.