InterviewSolution
Saved Bookmarks
| 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. |
|