Movatterモバイル変換

The Information SchemaPLUGINS table contains a row for each loaded plugin. Any that have aPLUGIN_LIBRARY value ofNULL are built in and cannot be unloaded.

mysql> SELECT * FROM INFORMATION_SCHEMA.PLUGINS\G*************************** 1. row ***************************           PLUGIN_NAME: binlog        PLUGIN_VERSION: 1.0         PLUGIN_STATUS: ACTIVE           PLUGIN_TYPE: STORAGE ENGINE   PLUGIN_TYPE_VERSION: 50158.0        PLUGIN_LIBRARY: NULLPLUGIN_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...*************************** 10. row ***************************           PLUGIN_NAME: InnoDB        PLUGIN_VERSION: 1.0         PLUGIN_STATUS: ACTIVE           PLUGIN_TYPE: STORAGE ENGINE   PLUGIN_TYPE_VERSION: 50158.0        PLUGIN_LIBRARY: ha_innodb_plugin.soPLUGIN_LIBRARY_VERSION: 1.0         PLUGIN_AUTHOR: Oracle Corporation    PLUGIN_DESCRIPTION: Supports transactions, row-level locking,                        and foreign keys        PLUGIN_LICENSE: GPL           LOAD_OPTION: ON...

TheSHOW PLUGINS statement displays a row for each loaded plugin. Any that have aLibrary value ofNULL are built in and cannot be unloaded.

mysql> SHOW PLUGINS\G*************************** 1. row ***************************   Name: binlog Status: ACTIVE   Type: STORAGE ENGINELibrary: NULLLicense: GPL...*************************** 10. row ***************************   Name: InnoDB Status: ACTIVE   Type: STORAGE ENGINELibrary: ha_innodb_plugin.soLicense: GPL...

Themysql.plugin table shows which plugins have been registered withINSTALL PLUGIN. The table contains only plugin names and library file names, so it does not provide as much information as thePLUGINS table or theSHOW PLUGINS statement.