- 7.5.6 Examining Thread Information
- 7.5.6.1 Thread Command Values
- 7.5.6.2 General Thread States
- 7.5.6.3 Delayed-Insert Thread States
- 7.5.6.4 Query Cache Thread States
- 7.5.6.5 Replication Master Thread States
- 7.5.6.6 Replication Slave I/O Thread States
- 7.5.6.7 Replication Slave SQL Thread States
- 7.5.6.8 Replication Slave Connection Thread States
- 7.5.6.9 Event Scheduler Thread States
The following list shows the most common states you may see in
the State column for a slave server SQL
thread:
-
Waiting for the next event in relay logThe initial state before
Reading event from the relay log. -
Reading event from the relay logThe thread has read an event from the relay log so that the event can be processed.
-
Has read all relay log; waiting for the slave I/O thread to update itThe thread has processed all events in the relay log files, and is now waiting for the I/O thread to write new events to the relay log.
-
The thread is executing a
LOAD DATA INFILEstatement and is creating a temporary file containing the data from which the slave will read rows. -
Waiting for slave mutex on exitA very brief state that occurs as the thread is stopping.
The State column for the I/O thread may
also show the text of a statement. This indicates that the
thread has read an event from the relay log, extracted the
statement from it, and is executing it.
User Comments
Add your own comment.