MySQL Forums
Forum List  »  Performance

Re: Which Restore goes faster: mysqldump vs. Load Data INFILE
Posted by: Bing Wu
Date: September 09, 2011 11:13PM

Tony - the "copying data files directly" is a very insightful idea. It so happens that I am using MyISAM tables so this idea should worth a try at least.

While waiting for replies to my original question, I did a test with a smaller test set (10G). After created two dump files--one from "select into" and the other "mysqldump", I restored them on to the same host, same DB and same table (truncated after each restore), to my surprise, restore from the mysqldump file was the faster option. It took only half the time to finish.

Anyway, just want to share the result. It may not be the most authoritative since the disk i/o could be well primed, etc. But the time difference is very significant.

Bing

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Which Restore goes faster: mysqldump vs. Load Data INFILE
4551
September 09, 2011 11:13PM


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.