Skip to content

sql-statement-show-plugins.md

Latest commit

 

History

History
56 lines (42 loc) · 1.85 KB

sql-statement-show-plugins.md

File metadata and controls

56 lines (42 loc) · 1.85 KB
title SHOW PLUGINS
summary An overview of the usage of SHOW PLUGINS for the TiDB database.
aliases
/docs/dev/sql-statements/sql-statement-show-plugins/

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