DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(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