MySQL 8.0 Database Administrator — Question 93

What does the slave I/O thread do?

Answer options

• A. connects to the master and requests it to send updates recorded in its binary logs
• B. monitors and schedules I/O calls to the subsystem for the relay logs
• C. acquires a lock on the binary log for reading each event to be sent to the slave
• D. reads the relay log and executes the events contained in them

Correct answer: C

Explanation

The correct answer, C, is accurate because the slave I/O thread needs to lock the binary log to read each event for transmission. Option A is incorrect as it describes the connection process but not the specific function of locking for reading. Options B and D describe other aspects of log management and event execution, which are not the primary responsibilities of the I/O thread.