MySQL Forums
Forum List  »  Backup

Re: What's the '--quick' meaning in mysqldump?
Posted by: Rick James
Date: June 02, 2014 12:07PM

Yeah, "quick" is a confusing option. Here's an explanation of the two methods that can be used for a SELECT. Note: mysqldump is effectively doing SELECTs to fetch the data.

Plan A:
Ask the server for all the rows, collect them in a buffer in mysqldump, then write them to the output file.

Plan B:
Ask the server for the rows a few at a time, as they arrive, write them to output.

Generally, you can't tell the difference between these two schemes.

For small, or even medium sized tables, it does not matter.

For tables with many millions of rows:
Plan A could run out of RAM.
Plan B would start writing sooner, but might (or might not) take longer to finish.

I think the confusion has to do with which part it "quick". A better term would be "stream" or "buffer" or something closer to what it is doing.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: What's the '--quick' meaning in mysqldump?
1734
June 02, 2014 12:07PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.