mysqldump affecting performance

[Pablogc]

Hello.

We're facing some issues when Nagios generates mysql backups as this task is slowing down the system a little bit.

We think we can optimice this making backups slower but less intrusive jus applying a couple of parameters to mysqldump:

Code: Select all

--single-transaction --quick

Is there any reason we shouldn't do this?

Thank you very much.

[tmcdonald]

I'm not aware of any issues this might cause, but I can check with the developers to confirm. Just note that any changes you make to the code will be overwritten on an upgrade, and strictly-speaking cannot be guaranteed to work since we did not write the changes ourselves.

[tmcdonald]

Got some updates from the devs. Looks like --single-transaciton will only work in InnoDB tables, where we use MyISAM. --quick also seems to be set to true by default, so those changes likely won't have any effect.