How can I speed up a MySQL restore from a dump file?
Posted
by Dave Forgac
on Server Fault
See other posts from Server Fault
or by Dave Forgac
Published on 2010-05-29T15:37:49Z
Indexed on
2010/05/29
15:54 UTC
Read the original article
Hit count: 168
I am restoring a 30GB database from a mysqldump file to an empty database on a new server. When running the SQL from the dump file, the restore starts very quickly and then starts to get slower and slower. Individual inserts are now taking 15+ seconds. The tables are MyISAM. The server has no other active connections. SHOW PROCESSLIST;
only shows the insert from the restore (and the show processlist itself).
Does anyone have any ideas what could be causing the dramatic slowdown?
Are there any MySQL variables that I can change to speed the restore while it is progressing?
© Server Fault or respective owner