How can i make dump of big mysql table? [closed]

Posted on

Question :

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?

Answer :

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.

Leave a Reply

Your email address will not be published. Required fields are marked *