MySQL 8.0 Release Notes
MySQL 8.0 Source Code Documentation
The following list shows the most common states you may see in
the State column for the master's
Binlog Dump thread. If you see no
Binlog Dump threads on a master server, this
means that replication is not running; that is, that no slaves
are currently connected.
Finished reading one binlog; switching to next binlogThe thread has finished reading a binary log file and is opening the next one to send to the slave.
Master has sent all binlog to slave; waiting for more updatesThe thread has read all remaining updates from the binary logs and sent them to the slave. The thread is now idle, waiting for new events to appear in the binary log resulting from new updates occurring on the master.
Binary logs consist of events, 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 slave.
Waiting to finalize terminationA very brief state that occurs as the thread is stopping.