MySQL - SHOW PLUGINS 语句
除了现有的服务器组件外，您还可以使用服务器支持的插件 API 在服务器中创建新的必需组件。使用此 API，您可以安装其他软件，例如存储引擎、全文解析器插件和服务器扩展。
SHOW PLUGINS 语句
MySQL 的 SHOW PLUGINS 语句列出服务器中所有已安装的插件。此语句显示的信息包含每个插件的以下值 -
Name - 插件的名称。
Active - 指定插件当前处于活动、非活动、禁用、正在删除还是已删除状态。
Type - 插件的类型。
Library - 指定插件的共享库文件的名称。
License - 指定插件的许可方式。
示例
您可以使用 SHOW PLUGINS 语句获取服务器中当前安装的插件列表，如下所示 -
SHOW PLUGINS\G;
输出
以下是上述查询的输出 -
************** 1. row ************** Name: binlog Status: ACTIVE Type: STORAGE ENGINE Library: NULL License: GPL ************** 2. row ************** Name: mysql_native_password Status: ACTIVE Type: AUTHENTICATION Library: NULL License: GPL ************** 3. row ************** Name: sha256_password Status: ACTIVE Type: AUTHENTICATION Library: NULL License: GPL ************** 4. row ************** Name: caching_sha2_password Status: ACTIVE Type: AUTHENTICATION Library: NULL License: GPL ************** 5. row ************** Name: sha2_cache_cleaner Status: ACTIVE Type: AUDIT Library: NULL License: GPL ************** 6. row ************** Name: daemon_keyring_proxy_plugin Status: ACTIVE Type: DAEMON Library: NULL License: GPL ************** 7. row ************** Name: CSV Status: ACTIVE Type: STORAGE ENGINE Library: NULL License: GPL ************** 8. row ************** Name: MEMORY Status: ACTIVE Type: STORAGE ENGINE Library: NULL License: GPL ************** 9. row ************** Name: InnoDB Status: ACTIVE Type: STORAGE ENGINE Library: NULL License: GPL ************** 10. row ************** Name: INNODB_TRX Status: ACTIVE Type: INFORMATION SCHEMA Library: NULL License: GPL ************** 11. row ************** Name: INNODB_CMP Status: ACTIVE Type: INFORMATION SCHEMA Library: NULL License: GPL ************** 12. row ************** Name: INNODB_CMP_RESET Status: ACTIVE Type: INFORMATION SCHEMA Library: NULL License: GPL ************** 13. row ************** Name: INNODB_CMPMEM Status: ACTIVE Type: INFORMATION SCHEMA Library: NULL License: GPL ************** 14. row ************** Name: INNODB_CMPMEM_RESET Status: ACTIVE Type: INFORMATION SCHEMA Library: NULL License: GPL ************** 15. row ************** Name: INNODB_CMP_PER_INDEX Status: ACTIVE Type: INFORMATION SCHEMA Library: NULL License: GPL ************** 16. row ************** Name: INNODB_CMP_PER_INDEX_RESET Status: ACTIVE Type: INFORMATION SCHEMA Library: NULL License: GPL ************** 17. row ************** Name: INNODB_BUFFER_PAGE Status: ACTIVE Type: INFORMATION SCHEMA Library: NULL License: GPL ************** 18. row ************** Name: INNODB_BUFFER_PAGE_LRU Status: ACTIVE Type: INFORMATION SCHEMA Library: NULL License: GPL ************** 19. row ************** Name: INNODB_BUFFER_POOL_STATS Status: ACTIVE Type: INFORMATION SCHEMA Library: NULL License: GPL ************** 20. row ************** Name: INNODB_TEMP_TABLE_INFO Status: ACTIVE Type: INFORMATION SCHEMA Library: NULL License: GPL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
现在让我们使用 install plugin 语句在 MySQL 中安装另外两个插件 -
Install plugin validate_password soname 'validate_password.dll'; INSTALL PLUGIN clone SONAME 'mysql_clone.dll';
如果您在列表底部再次验证插件列表，您可以观察到新安装的插件 -
SHOW PLUGINS\G;
输出
上述查询产生以下输出 -
************** 1. row ************** Name: binlog Status: ACTIVE Type: STORAGE ENGINE Library: NULL License: GPL ************** 2. row ************** Name: mysql_native_password Status: ACTIVE Type: AUTHENTICATION Library: NULL License: GPL ************** 3. row ************** Name: sha256_password Status: ACTIVE Type: AUTHENTICATION Library: NULL License: GPL ************** 4. row ************** Name: caching_sha2_password Status: ACTIVE Type: AUTHENTICATION Library: NULL License: GPL ************** 5. row ************** Name: sha2_cache_cleaner Status: ACTIVE Type: AUDIT Library: NULL License: GPL ************** 6. row ************** Name: daemon_keyring_proxy_plugin Status: ACTIVE Type: DAEMON Library: NULL License: GPL ************** 7. row ************** Name: CSV Status: ACTIVE Type: STORAGE ENGINE Library: NULL License: GPL ************** 8. row ************** Name: MEMORY Status: ACTIVE Type: STORAGE ENGINE Library: NULL License: GPL ************** 9. row ************** Name: InnoDB Status: ACTIVE Type: STORAGE ENGINE Library: NULL License: GPL ************** 10. row ************** Name: INNODB_TRX Status: ACTIVE Type: INFORMATION SCHEMA Library: NULL License: GPL ************** 11. row ************** Name: INNODB_CMP Status: ACTIVE Type: INFORMATION SCHEMA Library: NULL License: GPL ************** 12. row ************** Name: INNODB_CMP_RESET Status: ACTIVE Type: INFORMATION SCHEMA Library: NULL License: GPL ************** 13. row ************** Name: INNODB_CMPMEM Status: ACTIVE Type: INFORMATION SCHEMA Library: NULL License: GPL ************** 14. row ************** Name: INNODB_CMPMEM_RESET Status: ACTIVE Type: INFORMATION SCHEMA Library: NULL License: GPL ************** 15. row ************** Name: INNODB_CMP_PER_INDEX Status: ACTIVE Type: INFORMATION SCHEMA Library: NULL License: GPL ************** 16. row ************** Name: INNODB_CMP_PER_INDEX_RESET Status: ACTIVE Type: INFORMATION SCHEMA Library: NULL License: GPL ************** 17. row ************** Name: INNODB_BUFFER_PAGE Status: ACTIVE Type: INFORMATION SCHEMA Library: NULL License: GPL ************** 18. row ************** Name: INNODB_BUFFER_PAGE_LRU Status: ACTIVE Type: INFORMATION SCHEMA Library: NULL License: GPL ************** 19. row ************** Name: INNODB_BUFFER_POOL_STATS Status: ACTIVE Type: INFORMATION SCHEMA Library: NULL License: GPL ************** 20. row ************** Name: INNODB_TEMP_TABLE_INFO Status: ACTIVE Type: INFORMATION SCHEMA Library: NULL License: GPL ....................................................... ................................................. .............................................
