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
Explanation:
Reference: http://dev.mysql.com/doc/refman/4.1/en/mysqldump.html
the answer should be B
http://dev.mysql.com/doc/refman/5.6/en/mysqldump.html
–quick, -q
This option is useful for dumping large tables. It forces mysqldump to retrieve rows for a table from the server a row at a time rather than retrieving the entire row set and buffering it in memory before writing it out.
-quick is answer A *_*
I agree, it’s A
A
A