General Thread States The thread is flushing table, logs, or caches, or resetting status variable or replication server information. The thread is registering a replica server. The thread is resetting a prepared statement. The thread is setting or resetting a client statement execution option. The thread is shutting down the server. The thread is waiting for the client to send a new statement to it. The thread is producing server status information. 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. 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. The thread is calculating a  MyISAM  table key distributions (for example, for  ANALYZE TABLE ). The server is in the process of executing an in-place  ALTER TABLE . The thread is checking whether the server has the required privileges to execute the statement. The thread is performing a table check operation. 1847 •  Checking table •  checking permissions •  Analyzing •  altering table •  After create •  Time 8.14.3 General Thread States •  Sleep •  Statistics •  Shutdown •  Set option •  Register Slave •  Reset stmt