Re: [webmin-l] slowing down mysql backup

[Pat E. <pe...@gm...>]

no it's system load, I think. magento get's sluggish easily when the DB is
not responsive.

the change shortened the downtime to 120 secs from 5 minutes before. it's at
night so no biggy..

PAT

On Tue, Oct 25, 2011 at 22:42, Joshua J. Kugler <jo...@az...> wrote:

> 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
>
>
> ------------------------------------------------------------------------------
> The demand for IT networking professionals continues to grow, and the
> demand for specialized networking skills is growing even more rapidly.
> Take a complimentary Learning@Cisco Self-Assessment and learn
> about Cisco certifications, training, and career opportunities.
> http://p.sf.net/sfu/cisco-dev2dev
> -
> Forwarded by the Webmin mailing list at
> web...@li...
> To remove yourself from this list, go to
> http://lists.sourceforge.net/lists/listinfo/webadmin-list
>



-- 
*Pat Erler*
Gtalk/G+: pe...@gm...
<pe...@gm...>Skype: pat_erler