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
.......................................................
.................................................
.............................................
列印頁面
上一頁
下一頁
廣告