(mysql.info.gz) Slave SQL thread states
Info Catalog
(mysql.info.gz) Slave I/O thread states
(mysql.info.gz) Replication Implementation Details
(mysql.info.gz) Slave logs
6.3.3 Replication Slave SQL Thread States
-----------------------------------------
The following list shows the most common states you will see in the
`State' column for a slave server SQL thread:
`Reading event from the relay log'
The thread has read an event from the relay log so that it can
process it.
`Has read all relay log; waiting for the slave I/O thread to update it'
The thread has processed all events in the relay log files and is
waiting for the I/O thread to write new events to the relay log.
`Waiting for slave mutex on exit'
A 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.
Info Catalog
(mysql.info.gz) Slave I/O thread states
(mysql.info.gz) Replication Implementation Details
(mysql.info.gz) Slave logs
automatically generated byinfo2html