MySQL - SHOW PLUGINS 语句

上一页
下一页

除了现有的服务器组件外，您还可以使用服务器支持的插件 API 在服务器中创建新的必需组件。使用此 API，您可以安装其他软件，例如存储引擎、全文解析器插件和服务器扩展。

SHOW PLUGINS 语句

MySQL 的 SHOW PLUGINS 语句列出服务器中所有已安装的插件。此语句显示的信息包含每个插件的以下值：

  • 名称 - 插件的名称。

  • 活动 - 指定插件当前是活动、非活动、禁用、正在删除还是已删除。

  • 类型 - 插件的类型。

  • 库 - 它指定插件的共享库文件的名称。

  • 许可证 - 指定插件的许可方式。

示例

您可以使用如下所示的 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
.......................................................
.................................................
.............................................
打印页面
上一页
下一页
广告

© . All rights reserved.