1.

Under which option are index changes not flushed until tables close?(a) –delay-write-key(b) –delay-key-write(c) –write-key-delay(d) –key-write-delay

Answer» Right choice is (b) –delay-key-write

For explanation I would say: In MySQL, the MyISAM recovery is important if the server is run with the ‘–delay-key-write’ option. Under this condition, the index changes are not flushed until the tables close.


Discussion

No Comment Found