• PROCESSLIST_DB 

The default database for the thread, or NULL  if none has been selected. 

• PROCESSLIST_COMMAND 

For foreground threads, the type of command the thread is executing on behalf of the client, or Sleep  if the session is idle. For descriptions of thread commands, see Section 8.14, “Examining Server Thread (Process) Information” . The value of this column corresponds to the COM_ xxx  commands of the client/ server protocol and Com_ xxx  status variables. See Section 5.1.10, “Server Status Variables” 

Background threads do not execute commands on behalf of clients, so this column may be NULL . 

• PROCESSLIST_TIME 

The time in seconds that the thread has been in its current state. For a replica SQL thread, the value is the number of seconds between the timestamp of the last replicated event and the real time of the replica host. See Section 17.2.3, “Replication Threads” . 

• PROCESSLIST_STATE 

An action, event, or state that indicates what the thread is doing. For descriptions of PROCESSLIST_STATE  values, see Section 8.14, “Examining Server Thread (Process) Information” . If the value if NULL , the thread may correspond to an idle client session or the work it is doing is not instrumented with stages. 

Most states correspond to very quick operations. If a thread stays in a given state for many seconds, there might be a problem that bears investigation. 

• PROCESSLIST_INFO 

The statement the thread is executing, or NULL  if it is executing no statement. The statement might be the one sent to the server, or an innermost statement if the statement executes other statements. For example, if a CALL  statement executes a stored procedure that is executing a SELECT  statement, the PROCESSLIST_INFO  value shows the SELECT  statement. 

• PARENT_THREAD_ID 

If this thread is a subthread (spawned by another thread), this is the THREAD_ID  value of the spawning thread. 

• ROLE 

Unused. 

• INSTRUMENTED 

Whether events executed by the thread are instrumented. The value is YES  or NO . 

•For foreground threads, the initial INSTRUMENTED  value is determined by whether the user account associated with the thread matches any row in the setup_actors  table. Matching is based on the values of the PROCESSLIST_USER  and PROCESSLIST_HOST  columns. 

If the thread spawns a subthread, matching occurs again for the threads  table row created for the subthread. 

•For background threads, INSTRUMENTED  is YES  by default. setup_actors  is not consulted because there is no associated user for background threads. 

