load 9GB sql

MySQL & MariaDB Other MySQL® Questions
1

Hello. I need to move database from one server (Mysql 5.1.73) to another Percona 5.6.25-73.1.
I made a dump
mysqldump --opt db > db.sql
copy db.sql
and trying to load it to mysql
mysql db < db.sql

db.sql - 9GB
DB engine - Innodb.
CentOS 7.1 64 Software raid 1 2xSata disk tps 150-250

I have already loading for 6 hours and it seems load only about half of data. Can i somehow speed up this process ?

2

Hi silent-ion;

The likely limiting factor is your disk speed. But you probably can speed it up using a parallel dump / restore tool like MyDumper:

[url]https://launchpad.net/mydumper[/url]

-Scott