Performance Schema Miscellaneous Tables 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 • USER • HOST • DB 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 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. 5086