(mysql.info.gz) Master thread states

(mysql.info.gz) Replication Implementation Details

(mysql.info.gz) Slave I/O thread states

 
 6.3.1 Replication Master Thread States
 --------------------------------------
 
 The following list shows the most common states you will see in the
 `State' column for the master's `Binlog Dump' thread. If you don't see
 any `Binlog Dump' threads on a master server, replication is not
 running. That is, no slaves currently are connected.
 
 `Sending binlog event to slave'
      Binary logs consist of events, where an event is usually an update
      statement plus some other information. The thread has read an
      event from the binary log and is sending it to the slave.
 
 `Finished reading one binlog; switching to next binlog'
      The thread has finished reading a binary log file and is opening
      the next one to send to the slave.
 
 `Has sent all binlog to slave; waiting for binlog to be updated'
      The thread has read all outstanding updates from the binary logs
      and sent them to the slave. It is idle, waiting for new events to
      appear in the binary log resulting from new update statements
      being executed on the master.
 
 `Waiting to finalize termination'
      A very brief state that occurs as the thread is stopping.

Info Catalog

(mysql.info.gz) Replication Implementation Details

(mysql.info.gz) Slave I/O thread states

automatically generated byinfo2html