Skip navigation links

Additional languages
7.5.5.1 Thread Command Values »
Section Navigation      [Toggle]

7.5.5. Examining Thread Information

[+/-]

7.5.5.1. Thread Command Values
7.5.5.2. General Thread States
7.5.5.3. Delayed-Insert Thread States
7.5.5.4. Replication Master Thread States
7.5.5.5. Replication Slave I/O Thread States
7.5.5.6. Replication Slave SQL Thread States
7.5.5.7. Replication Slave Connection Thread States
7.5.5.8. MySQL Cluster 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:

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:

  • 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 is 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.

  • Time indicates how long the thread has been in its current state.

  • Info contains the text of the statement being executed by the thread, or NULL if it is not executing one. By default, this value contains only the first 100 characters of the statement. To see the complete statements, use SHOW FULL PROCESSLIST.

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.