The INFORMATION_SCHEMA PROCESSLIST Table • PLUGIN_LICENSE • LOAD_OPTION • 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. • ID • USER A short description of the plugin. How the plugin is licensed (for example,  GPL ). How the plugin was loaded. The value is  OFF ,  ON ,  FORCE , or  FORCE_PLUS_PERMANENT . See Section 5.6.1, “Installing and Uninstalling Plugins” . Plugin information is also available from the  SHOW PLUGINS  statement. See Section 13.7.7.25, “SHOW PLUGINS Statement” . These statements are equivalent: 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: 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. 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” ). 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” ). Note 26.3.23 The INFORMATION_SCHEMA PROCESSLIST Table Notes SELECT PLUGIN_NAME, PLUGIN_STATUS, PLUGIN_TYPE, PLUGIN_LIBRARY, PLUGIN_LICENSE FROM INFORMATION_SCHEMA.PLUGINS; SHOW PLUGINS; 4809