Re: Import of SQL file slow or freezes
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.
Subject
Written By
Posted
Re: Import of SQL file slow or freezes
August 28, 2018 04:46AM
December 28, 2018 12:29PM
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.