Vidyalelo
MySQL · Q406

MySQL

Programming · MySQL · question 406

Q406

The log enabled by -relay-log-index is . . . . . . . .

A.
relay log index
Answer
B.
relay log
C.
binary log
D.
error log

Answer: Option A

Solution

Answer: Option A
Solution:
This question is about the MySQL replication process.

Replication is the process where a MySQL server (the master) copies its changes to another server (the slave).

The relay log is a file on the slave server that stores the events from the master server, and it helps the slave server to apply these changes.

The -relay-log-index option is used to enable a secondary index for the relay log.

This index makes it faster to look up specific events in the relay log, which is helpful for troubleshooting and debugging.

Therefore, the answer is Option A: relay log index.