MySQL Forums
Forum List  »  General

Re: Import of SQL file slow or freezes
Posted by: Daniel Blanchard
Date: August 28, 2018 04:46AM

I see in the SHOW VARIABLES OUTPUT that binary logging is ON - this is a new default in MySQL 8. Binary logging will have a significant performance impact whilst importing a large SQL file.

You could consider disabling binary logging at MySQL startup - but only if you are not using replication and are prepared for the data recovery consequences (see MySQL manual section on the binary log at https://dev.mysql.com/doc/refman/8.0/en/binary-log.html).

Alternatively, you could temporarily disable binary logging whilst importing the sql file with

SET sql_log_bin = OFF

before importing, then

SET sql_log_bin = OFF

when the import is complete. Note that this will prevent replication of the imported changes from master to slave if you have replication turned on.

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.