content_image/775638.jpg
The processlist  table contains a row for each server process: 

mysql> SELECT * FROM performance_schema.processlist\G *************************** 1. row *************************** ID: 5 USER: event_scheduler HOST: localhost DB: NULL COMMAND: Daemon TIME: 137 STATE: Waiting on empty queue INFO: NULL *************************** 2. row *************************** ID: 9 USER: me HOST: localhost:58812 DB: NULL COMMAND: Sleep TIME: 95 STATE: INFO: NULL *************************** 3. row *************************** ID: 10 USER: me HOST: localhost:58834 DB: test COMMAND: Query TIME: 0 STATE: executing INFO: SELECT * FROM performance_schema.processlist ... 

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/775638.jpg'>

• HOST 

## 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” ). 

The host name of the client issuing the statement (except for system user , for which there is no host). The host name for TCP/IP connections is reported in host_name : client_port  format to make it easier to determine which client is doing what. 

• DB 

