You are viewing the archived documentation of TiDB, which no longer receives updates.

View latest LTS version docs

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

The SHOW PLUGINS statement in TiDB is fully compatible with MySQL. If you find any compatibility differences, report a bug.