The thread is flushing table, logs, or caches, or resetting status variable or replication server information. 

## 8.14.3 General Thread States 

• Register Slave 

The thread is registering a replica server. 

• Reset stmt 

The thread is resetting a prepared statement. 

• Set option 

The thread is setting or resetting a client statement execution option. 

• Shutdown 

The thread is shutting down the server. 

• Sleep 

The thread is waiting for the client to send a new statement to it. 

• Statistics 

The thread is producing server status information. 

• Time 

Unused. 

The following list describes thread State  values that are associated with general query processing and not more specialized activities such as replication. Many of these are useful only for finding bugs in the server. 

• After create 

This occurs when the thread creates a table (including internal temporary tables), at the end of the function that creates the table. This state is used even if the table could not be created due to some error. 

• altering table 

The server is in the process of executing an in-place ALTER TABLE . 

• Analyzing 

The thread is calculating a MyISAM  table key distributions (for example, for ANALYZE TABLE ). 

• checking permissions 

The thread is checking whether the server has the required privileges to execute the statement. 

• Checking table 

The thread is performing a table check operation. 

