MySQL Forums
Forum List  »  General

Re: Import of SQL file slow or freezes
Posted by: Peter Brawley
Date: August 26, 2018 06:29PM

The script you posted already turns off fk checks.

Did you restart the server after changing ibpsize?

You could try alternative values of network_buffer_length on the mysqldump cmd line, and try autocommit on, but we're looking for a factor that makes Load File slower on this box by an order of magnitude. I don't suppose you've run a disk i/o benchmark on the two systems?

Options: ReplyQuote

Sorry, only registered users may post in this forum.

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.