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

Filed under:
|

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

Related posts about mysql

Related posts about mysqldump