Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?

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?

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



Leave a Reply 3

Your email address will not be published. Required fields are marked *


Cristian

Cristian

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.