SHOW PLUGINS

SHOW PLUGINS shows all plugins installed in TiDB, including each plugin's status and version information.

Synopsis

ShowStmt:

ShowStmt

ShowTargetFilterable:

ShowTargetFilterable

Examples

SHOW PLUGINS;
+-------+--------------+-------+-----------------------------+---------+---------+ | Name | Status | Type | Library | License | Version | +-------+--------------+-------+-----------------------------+---------+---------+ | audit | Ready-enable | Audit | /tmp/tidb/plugin/audit-1.so | | 1 | +-------+--------------+-------+-----------------------------+---------+---------+ 1 row in set (0.000 sec)
SHOW PLUGINS LIKE 'a%';
+-------+--------------+-------+-----------------------------+---------+---------+ | Name | Status | Type | Library | License | Version | +-------+--------------+-------+-----------------------------+---------+---------+ | audit | Ready-enable | Audit | /tmp/tidb/plugin/audit-1.so | | 1 | +-------+--------------+-------+-----------------------------+---------+---------+ 1 row in set (0.000 sec)

MySQL compatibility

This statement is understood to be fully compatible with MySQL. Any compatibility differences should be reported via an issue on GitHub.