1Z0-908 practice question 15 of 25

What does the binlog dump thread do?

Full set: 140 questions
Answer options
A: It monitors and schedules the rotation/deletion of the binary logs.
B: It reads the relay log and executes the events contained in them.
C: It acquires a lock on the binary log for reading each event to be sent to the slave. Correct answer
D: It connects to the master and asks it to send updates recorded in its binary logs.
Correct Answer:
C. It acquires a lock on the binary log for reading each event to be sent to the slave.
Explanation

The binlog dump thread is a thread that runs on the source (master) server. When a replica (slave) connects, the source starts a dedicated binlog dump thread for that replica. This thread's primary responsibility is to read events from the source's binary log files and send them over the network to the replica's I/O thread. To ensure data consistency and prevent corruption while reading, the binlog dump thread acquires a lock on the binary log for each event it reads before sending it.

Why Incorrect

A. This describes binary log maintenance, which is managed by server settings like expirelogsdays or manual commands such as PURGE BINARY LOGS, not the binlog dump thread.
B. This describes the function of the SQL thread (or applier thread) on the replica server, which applies changes from the relay log to the replica's database.
D. This describes the function of the I/O thread (or receiver thread) on the replica server, which is responsible for connecting to the source and requesting the binary log stream.

References

1. MySQL 8.0 Reference Manual

Section 17.2.4

"Replication Threads":

"On the source

there is one thread per connected replica

called a binary log dump thread (or just dump thread). This thread reads events from the binary log and sends them to the replica. Before it starts sending events

it acquires a lock on the binary log. The lock is released when it has read the last requested event." This directly supports option C.

"When a START REPLICA statement is issued on a replica

the replica creates an I/O thread

which connects to the source and asks it to send the events recorded in its binary logs." This confirms that option D describes the replica's I/O thread.

"The replica has an SQL thread that reads the events from the relay log and executes them." This confirms that option B describes the replica's SQL thread.

2. MySQL 8.0 Reference Manual

Section 5.4.4

"The Binary Log":

This section details the PURGE BINARY LOGS statement and the expirelogsdays system variable

which are the mechanisms for managing binary log file deletion. This confirms that option A is a separate administrative function.

Scroll to Top