Examveda
Examveda

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

A. relay log index

B. relay log

C. binary log

D. error log

Answer: Option A

Solution(By Examveda Team)

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.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous