MySQL 9.3 Reference Manual Including MySQL NDB Cluster 9.3
There are several ways to determine which plugins are installed in the server:
The Information Schema PLUGINS
table contains a row for each loaded plugin. Any that have a
PLUGIN_LIBRARY
value of
NULL
are built in and cannot be unloaded.
mysql> TABLE INFORMATION_SCHEMA.PLUGINS\G
*************************** 1. row ***************************
PLUGIN_NAME: binlog
PLUGIN_VERSION: 1.0
PLUGIN_STATUS: ACTIVE
PLUGIN_TYPE: STORAGE ENGINE
PLUGIN_TYPE_VERSION: 90100.0
PLUGIN_LIBRARY: NULL
PLUGIN_LIBRARY_VERSION: NULL
PLUGIN_AUTHOR: Oracle Corporation
PLUGIN_DESCRIPTION: This is a pseudo storage engine to represent the binlog in a transaction
PLUGIN_LICENSE: GPL
LOAD_OPTION: FORCE
*************************** 2. row ***************************
PLUGIN_NAME: sha256_password
PLUGIN_VERSION: 1.1
PLUGIN_STATUS: ACTIVE
PLUGIN_TYPE: AUTHENTICATION
PLUGIN_TYPE_VERSION: 2.1
PLUGIN_LIBRARY: NULL
PLUGIN_LIBRARY_VERSION: NULL
PLUGIN_AUTHOR: Oracle Corporation
PLUGIN_DESCRIPTION: SHA256 password authentication
PLUGIN_LICENSE: GPL
LOAD_OPTION: FORCE
...
The SHOW PLUGINS
statement
displays a row for each loaded plugin. Any that have a
Library
value of NULL
are built in and cannot be unloaded.
mysql> SHOW PLUGINS\G
*************************** 1. row ***************************
Name: binlog
Status: ACTIVE
Type: STORAGE ENGINE
Library: NULL
License: GPL
*************************** 2. row ***************************
Name: sha256_password
Status: ACTIVE
Type: AUTHENTICATION
Library: NULL
License: GPL
...
The mysql.plugin
table shows which plugins
have been registered with INSTALL
PLUGIN
. The table contains only plugin names and
library file names, so it does not provide as much information
as the PLUGINS
table or the
SHOW PLUGINS
statement.