MySQL 8.0 Release Notes
MySQL 8.0 Source Code Documentation
- 10.14.1 Accessing the Process List
- 10.14.2 Thread Command Values
- 10.14.3 General Thread States
- 10.14.4 Replication Source Thread States
- 10.14.5 Replication I/O (Receiver) Thread States
- 10.14.6 Replication SQL Thread States
- 10.14.7 Replication Connection Thread States
- 10.14.8 NDB Cluster Thread States
- 10.14.9 Event Scheduler Thread States
To ascertain what your MySQL server is doing, it can be helpful to examine the process list, which indicates the operations currently being performed by the set of threads executing within the server. For example:
mysql> SHOW PROCESSLIST\G
*************************** 1. row ***************************
Id: 5
User: event_scheduler
Host: localhost
db: NULL
Command: Daemon
Time: 2756681
State: Waiting on empty queue
Info: NULL
*************************** 2. row ***************************
Id: 20
User: me
Host: localhost:52943
db: test
Command: Query
Time: 0
State: starting
Info: SHOW PROCESSLIST
Threads can be killed with the KILL
statement. See Section 15.7.8.4, “KILL Statement”.