MySQL Forums :: Performance :: How can I improve the import speed of a large SQL file?


Advanced Search

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
How can I improve the import speed of a large SQL file? 901 Jeff Vincent 05/06/2016 09:46AM
Re: How can I improve the import speed of a large SQL file? 451 Peter Brawley 05/06/2016 11:49AM
Re: How can I improve the import speed of a large SQL file? 431 Jeff Vincent 05/06/2016 12:17PM
Re: How can I improve the import speed of a large SQL file? 423 Rick James 05/06/2016 05:44PM
Re: How can I improve the import speed of a large SQL file? 441 Shane Bester 05/08/2016 04:49AM


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.