SHOW PLUGINS

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

SHOW PLUGINS - 图1

Note

This feature is not available on TiDB Serverless clusters.

Synopsis

ShowStmt:

ShowStmt

ShowTargetFilterable:

ShowTargetFilterable

Examples

  1. SHOW PLUGINS;
  1. +-------+--------------+-------+-----------------------------+---------+---------+
  2. | Name | Status | Type | Library | License | Version |
  3. +-------+--------------+-------+-----------------------------+---------+---------+
  4. | audit | Ready-enable | Audit | /tmp/tidb/plugin/audit-1.so | | 1 |
  5. +-------+--------------+-------+-----------------------------+---------+---------+
  6. 1 row in set (0.000 sec)
  1. SHOW PLUGINS LIKE 'a%';
  1. +-------+--------------+-------+-----------------------------+---------+---------+
  2. | Name | Status | Type | Library | License | Version |
  3. +-------+--------------+-------+-----------------------------+---------+---------+
  4. | audit | Ready-enable | Audit | /tmp/tidb/plugin/audit-1.so | | 1 |
  5. +-------+--------------+-------+-----------------------------+---------+---------+
  6. 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.