(mysql.info) slave-sql-thread-states

Info Catalog

(mysql.info) slave-io-thread-states

(mysql.info) replication-implementation-details

(mysql.info) slave-logs

 
 6.3.3 Replication Slave SQL Thread States
 -----------------------------------------
 
 The following list shows the most common states you may 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 the event
      can be processed.
 
    * `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
      now 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) slave-io-thread-states

(mysql.info) replication-implementation-details

(mysql.info) slave-logs