MySQL - SHOW PLUGINS Statement

In addition to existing server components, you can create a new required component in the server using the plugin API supported by the server. Using this API, you can install additional softwares such as storage engines, full-text parser plugins, and server extensions.

SHOW PLUGINS Statement

The SHOW PLUGINS statement of MySQL lists out all the installed plugins in the server. The information displayed by this statement contains following values for each plugin −

  • Name − Name of the plugin.

  • Active − Specifies whether the plugin is currently active, inactive, disabled, deleting, or deleted.

  • Type − Type of the plugin.

  • Library − It specifies the name of the shared library file of the plugin.

  • License − Specifies how the plugin is licensed.

Example

You can get the list of plugins currently installed in the server using the SHOW PLUGINS Statement as shown below −

SHOW PLUGINS\G;

Output

Following is the output of the above query −

************** 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
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . .

Now let us install two more plugins in MySQL using the install plugin statement −

Install plugin validate_password soname 'validate_password.dll';
INSTALL PLUGIN clone SONAME 'mysql_clone.dll';

If you verify the plugins list again at the bottom of the list you can observe the installed newly installed plugins −

SHOW PLUGINS\G;

Output

The above query produces the following output −

************** 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
.......................................................
.................................................
.............................................
Advertisements