I have server with db(36Gb data), only mysql access. When i’m trying to use mysqldump utility, i get connection timeout(or something like this).
I doesn’t have ssh access for copy /var/mysql/data.
It’s a production server and i want copy data without any loads on server CPU/IOdisk.
Now i have only one solution. Read batch of data (1000-10000 lines) with script, insert in local database, wait xxx ms.
May be exists ready solutions?
You might try mydumper which is multi-threaded whereas mysqldump is single-threaded.
Percona have also improved the less locking feature in the most recent version.
The excellent Mysql Performance Blog has this useful article.