1.

The option which delays index flushing for slave server is _________________(a) –delay-write-key=ALL(b) –delay-key-write=ALL(c) –key-write-delay=NONE(d) –key-delay-write=NONE

Answer» Right option is (b) –delay-key-write=ALL

The best I can explain: For the replication slave servers, the –delay-key-write=ALL option delays index flushing for all MyISAM tables, regardless of how they were created originally on the master server.


Discussion

No Comment Found