8.12.5 Examining Thread Information Thread Command Values General Thread States Delayed-Insert Thread States Query Cache Thread States Replication Master Thread States Replication Slave I/O Thread States Replication Slave SQL Thread States Replication Slave Connection Thread States MySQL Cluster Thread States Event Scheduler Thread States

When you are attempting to ascertain what your MySQL server is doing, it can be helpful to examine the process list, which is the set of threads currently executing within the server. Process list information is available from these sources:

Access to threads does not require a mutex and has minimal impact on server performance. INFORMATION_SCHEMA.PROCESSLIST and SHOW PROCESSLIST have negative performance consequences because they require a mutex. threads also shows information about background threads, which INFORMATION_SCHEMA.PROCESSLIST and SHOW PROCESSLIST do not. This means that threads can be used to monitor activity the other thread information sources cannot.


Each process list entry contains several pieces of information:
