Bug #49665 mysqldump: slow performance
Submitted: 14 Dec 2009 12:02 Modified: 14 Dec 2009 15:20
Reporter: Tomas Dalebjörk Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Backup Severity:S3 (Non-critical)
Version:5.0.45-7.el5 OS:Linux (RHEL 5.3)
Assigned to: CPU Architecture:Any
Tags: mysqldump, performance

[14 Dec 2009 12:02] Tomas Dalebjörk 
Description:
Can we apply some performance improvement parameters on the MySQL server?
The current transfer rates are appx 4GB in 6mins. While a ftp copy of the same data to the TSM Server disk took around 75 secs.

How to repeat:
rerunning mysqldump
[14 Dec 2009 12:36] Valeriy Kravchuk 
Please, check mydumper (see http://mituzas.lt/2009/02/03/mydumper/ and https://launchpad.net/mydumper). Maybe it will allow you to do dump of data really fast, if you have multiple CPUs/cores and are not disk bound.
[14 Dec 2009 13:01] Tomas Dalebjörk 
Thanks for the update.
But it is very important that the data integrity is also proven.
Do you know if there are any parameters in my.ini to change/add to improve the performance?
[14 Dec 2009 15:20] Sveta Smirnova 
Thank you for the feedback.

Your problem is not the result of a bug. The bug system is not the appropriate forum for asking help on using MySQL products.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.