You have a server that has very limited memory but has a very large table. You will use
mysqldump to back up this table. Which option will ensure mysqldump will process a row at
a time instead of buffering a set of rows?
A.
— quick
B.
— skip-buffer
C.
— single-transaction
D.
— tab
A
A
Why are so many highlighted answers (from pressing the “Show Answer” button) obv. wrong, such as this one? –quick is the obvious correct answer here, yet the key says –single-transaction, which is pretty ridiculous, really.