Skip to content

sql-statement-show-plugins.md

Latest commit

 

History

History
55 lines (41 loc) · 1.79 KB

sql-statement-show-plugins.md

File metadata and controls

55 lines (41 loc) · 1.79 KB
title SHOW PLUGINS
summary An overview of the usage of SHOW PLUGINS for the TiDB database.

SHOW PLUGINS

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

Note:

This feature is not available on {{{ .starter }}} and {{{ .essential }}} clusters.

Synopsis

ShowPluginsStmt ::=
    "SHOW" "PLUGINS" ShowLikeOrWhere?

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.

See also