MySQL Forums
Forum List  »  Backup

Re: What's the '--quick' meaning in mysqldump?
Posted by: feng guo
Date: June 02, 2014 08:30PM

Rick James Wrote:
-------------------------------------------------------
> 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.

I just do one thing all my life--do things interesting me!
Blog: www.leafonsword.org

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: What's the '--quick' meaning in mysqldump?
1406
June 02, 2014 08:30PM


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.