MySQL Forums
Forum List  »  Backup

Performance problem during mysqldump backup
Posted by: Romain LAMAISON
Date: March 04, 2008 05:16AM


when I'm backuping some big databases with mysqldump, I have performance problems on the server.

I tried to nice the mysqldump process but the fact is mysqldump calls a mysql process which is not niced.

Does anyone has an idea about this issue ? How to backup my databases without impacting the global performances ?

I looked on mysqlhotcopy which is a fast way (and not slowing performances a lot) to do backups but this generates binary files and I need to have text files. So if anyone knows how to convert binary files to text files, I can do something with it.

Thanks for your help.


Options: ReplyQuote

Written By
Performance problem during mysqldump backup
March 04, 2008 05:16AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.