Hello.

I am trying to upload a MySQL database dump to a local server, which weighs more than 14GB. Pour through the console

mysql> \. C: \ myFile.sql

But at some stage the import process hangs. And in the MySQL log there is nothing that could help me. After a rather long period of time, the process continues (again, without any errors in the log). As a result, the whole process of importing this dump lasts about 24 hours.

In mysql.ini in max_allowed_packet was 100M, but I changed to 1024M - it did not help.

How to fix it?

  • How do you distinguish "freezes" from "importing data"? - etki
  • one
    Execute SHOW PROCESSLIST and see which command takes a long time to execute. Think again - Anton Shchyrov
  • one
    I suspect this is normal - andreymal
  • Thank you. I did not have this parameter at all. I set myisam_max_sort_file_size = 10G and everything started working much faster. - Hennadii Shvedko

1 answer 1

Thank you @AntonShchyrov

Indeed, when viewing the list of processes, I found the answer to my question [ https://stackoverflow.com/questions/1067367/how-to-avoid-repair-with-keycache] .

It turns out the whole thing in MyISAM and in myisam_max_sort_file_size. I did not have this parameter at all. I set myisam_max_sort_file_size = 10G and everything started working much faster. The import process has been reduced from approximately 24 hours to 2.