Thread Command Values • Id  is the connection identifier for the client associated with the thread. • User  and  Host  indicate the account associated with the thread. • db  is the default database for the thread, or  NULL  if none has been selected. • Command  and  State  indicate what the thread is doing. Most states correspond to very quick operations. If a thread stays in a given state for many seconds, there might be a problem that needs to be investigated. The following sections list the possible  Command  values, and  State  values grouped by category. The meaning for some of these values is self-evident. For others, additional description is provided. Applications that examine process list information should be aware that the commands and states are subject to change. • Time  indicates how long the thread has been in its current state. The thread’s notion of the current time may be altered in some cases: The thread can change the time with  SET TIMESTAMP =  value . 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” . • Info  indicates the statement the thread is executing, or  NULL  if it is executing no statement. For  SHOW PROCESSLIST , this value contains only the first 100 characters of the statement. To see complete statements, use  SHOW FULL PROCESSLIST  (or query a diffferent process information source). Note 8.14.2 Thread Command Values A thread can have any of the following  Command  values: This is a thread on a replication source for sending binary log contents to a replica. The thread is executing a change user operation. The thread is closing a prepared statement. Used by replication receiver threads connected to the source, and by replication worker threads. A replica is connecting to its source. The thread is executing a create database operation. This thread is internal to the server, not a thread that services a client connection. •  Daemon •  Create DB •  Connect Out •  Connect •  Close stmt •  Change user •  Binlog Dump 1845