content_image/690742.jpg
A short description of the plugin. 

• PLUGIN_LICENSE 

How the plugin is licensed (for example, GPL ). 

• LOAD_OPTION 

How the plugin was loaded. The value is OFF , ON , FORCE , or FORCE_PLUS_PERMANENT . See Section 5.6.1, “Installing and Uninstalling Plugins” . 

## Notes 

• PLUGINS  is a nonstandard INFORMATION_SCHEMA  table. 

•For plugins installed with INSTALL PLUGIN , the PLUGIN_NAME  and PLUGIN_LIBRARY  values are also registered in the mysql.plugin  table. 

•For information about plugin data structures that form the basis of the information in the PLUGINS  table, see The MySQL Plugin API. 

Plugin information is also available from the SHOW PLUGINS  statement. See Section 13.7.7.25, “SHOW PLUGINS Statement” . These statements are equivalent: 

SELECT PLUGIN_NAME, PLUGIN_STATUS, PLUGIN_TYPE, PLUGIN_LIBRARY, PLUGIN_LICENSE FROM INFORMATION_SCHEMA.PLUGINS; SHOW PLUGINS; 

## 26.3.23 The INFORMATION_SCHEMA PROCESSLIST Table 

The MySQL process list indicates the operations currently being performed by the set of threads executing within the server. The PROCESSLIST  table is one source of process information. For a comparison of this table with other sources, see Sources of Process Information. 

The PROCESSLIST  table has these columns: 

• ID 

The connection identifier. This is the same value displayed in the Id  column of the SHOW PROCESSLIST statement, displayed in the PROCESSLIST_ID  column of the Performance Schema threads  table, and returned by the CONNECTION_ID()  function within the thread. 

• USER 

The MySQL user who issued the statement. A value of system user  refers to a nonclient thread spawned by the server to handle tasks internally, for example, a delayed-row handler thread or an I/O or SQL thread used on replica hosts. For system user , there is no host specified in the Host  column. unauthenticated user  refers to a thread that has become associated with a client connection but for which authentication of the client user has not yet occurred. event_scheduler  refers to the thread that monitors scheduled events (see Section 25.4, “Using the Event Scheduler” ). 

<img src='content_image/690742.jpg'>

## Note 

A USER  value of system user  is distinct from the SYSTEM_USER  privilege. The former designates internal threads. The latter distinguishes the system user and regular user account categories (see Section 6.2.11, “Account Categories” ). 

