content_image/705703.jpg
• 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. 

<img src='content_image/705703.jpg'>

## Note 

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

## 8.14.2 Thread Command Values 

A thread can have any of the following Command  values: 

## • Binlog Dump 

This is a thread on a replication source for sending binary log contents to a replica. 

## • Change user 

The thread is executing a change user operation. 

## • Close stmt 

The thread is closing a prepared statement. 

## • Connect 

Used by replication receiver threads connected to the source, and by replication worker threads. 

## • Connect Out 

A replica is connecting to its source. 

## • Create DB 

The thread is executing a create database operation. 

## • Daemon 

This thread is internal to the server, not a thread that services a client connection. 

