8.14 Examining Thread Information

8.14.1 Thread Command Values
8.14.2 General Thread States
8.14.3 Delayed-Insert Thread States
8.14.4 Query Cache Thread States
8.14.5 Replication Master Thread States
8.14.6 Replication Slave I/O Thread States
8.14.7 Replication Slave SQL Thread States
8.14.8 Replication Slave Connection Thread States
8.14.9 MySQL Cluster Thread States
8.14.10 Event Scheduler Thread States

As you monitor the performance of your MySQL server, examine the process list, which is the set of threads currently executing within the server. Process list information is available from these sources:

You can always view information about your own threads. To view information about threads being executed for other accounts, you must have the PROCESS privilege.

Each process list entry contains several pieces of information:

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.