Restore Performance

You are viewing an old version of this question. View the current version here.

Is it possible to restore a 32GB dmp file generated by mysqldump in less than 1 week? I generated a dmp with mysqldump, copied it to the salve machine to set up replication and it took over 1 week to complete the restore. This was using all of the performance tricks I could locate such as turning off foreign key and unique checks.

The database being restored is running on a linux (CENTOS) VM with 8GB memory and 4 3.3GHz processors available. The mariadb version is 5.5.52. There are no other processes running on this VM other than the database.

This seems like an unacceptably slow restoration process. I have restored larger databases (non-mariadb) within a few hours, it seems mariadb would also be able to accomplish this.

Answer

You don't give any details about your data, but take a look at How to Quickly Insert Data Into MariaDB.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.