Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 35.1Mb
PDF (A4) - 35.2Mb
Man Pages (TGZ) - 256.4Kb
Man Pages (Zip) - 361.2Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

8.14.5 Replication Source Thread States

The following list shows the most common states you may see in theState column for theBinlog Dump thread of the replication source. If you see noBinlog Dump threads on a source, this means that replication is not running; that is, that no replicas are currently connected.

  • 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 replica.

  • Master has sent all binlog to slave; waiting for more updates

    The thread has read all remaining updates from the binary logs and sent them to the replica. The thread is now idle, waiting for new events to appear in the binary log resulting from new updates occurring on the source.

  • Sending binlog event to slave

    Binary logs consist ofevents, where an event is usually an update plus some other information. The thread has read an event from the binary log and is now sending it to the replica.

  • Waiting to finalize termination

    A very brief state that occurs as the thread is stopping.