CODEWITHSUNDEEP
mysql
Hanz Fritz
Hanz Fritz

Reputation: 11

Slow restore of database mysqldump

5GB database takes 15 minutes to restore. CPU is utilized 10% on one thread, iotop shows 20MB/s or less. Can't understand why it is so slow and does not use all HW resources?

Upvotes: 1

Views: 471

Answers (2)

Hanz Fritz
Hanz Fritz

Reputation: 11

Mydumper/Myloader is the right choice besides binary dump restore of the whole database (mariabackup).

Upvotes: 0

jacobhobson
jacobhobson

Reputation: 1185

You need to be using mysqlpump. It is the "parallelized" version of mysqldump. This blog really divulges some of the more specific features, including how to specify parallel degree: https://mydbops.wordpress.com/2015/10/14/getting-started-with-mysqlpump-2/.

Upvotes: 1

Related Questions