Re: [webmin-l] slowing down mysql backup

[Joshua J. K. <jo...@az...>]

On Monday, October 24, 2011, Pat Erler elucidated thus:
> hi jamie,
> 
> do you see a way to slow down the mysql scheduled backup a bit. I get
> timeouts, especially with websites which rely heavily on the db
> (here: magento) and would like to use some kind of "nice" for the
> scheduled backups,

Are you getting timeouts because of I/O or system load, or because the 
DB is locked? mysqldump has an option to lock the DB for dumps, which 
would cause other apps accessing the DB to be locked out until the dump 
is done.  Setting the dump to a lower priority would actually make the 
problem worse since the DB would be locked for longer.

j

-- 
Joshua J. Kugler - Fairbanks, Alaska
Azariah Enterprises - Programming and Website Design
jo...@az... - Jabber: ped...@gm...
PGP Key: http://pgp.mit.edu/  ID 0x73B13B6A