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

View latest LTS version docs

SHOW PLUGINS

yikeke
TomShawn
Oreoxmt
dveeden
qiancai

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.