MySQL Forums
Forum List  »  Performance

Re: How can I improve the import speed of a large SQL file?
Posted by: Rick James
Date: May 06, 2016 05:44PM

Turning off autocommit means that the entire file will be one transaction.

And then, I don't see the final COMMIT. Did it actually get saved?

A huge set of data is likely to be slower as a single transaction than a bunch of autocommitted INSERTs.

What is the source file like? Is it multi-statement INSERTs? Hopefully it is.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How can I improve the import speed of a large SQL file?
584
May 06, 2016 05:44PM


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.