[LRUG] Sites drop off web

[Max Williams]

I'm not sure if this helps your specific problem but there is a mysqldump
option "--single-transaction" which stops it from locking the db:

http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html#option_mysqldump_single-transaction

On 8 August 2011 11:53, Andrew Stewart <boss at airbladesoftware.com> wrote:

> Tim,
>
> > I had a similar problem with CentOS. mysqldump was stalling everything
> for a couple of minutes when it ran.
> >
> > Saw some pretty epic query times popping up in NewRelic RPM around that
> time. The site just stalled for a few minutes.
> >
> > Pingdom reported a minute or two of downtime.
>
> Thanks for the information.  I use mysqldump too -- with increasing
> reluctance because I've been seeing the same behaviour as you.  As a stopgap
> measure I wrapped it in a timeout[1] but I think the real solution is to
> move to Postgres and whatever backup mechanism it has.
>
> Cheers,
> Andy
>
> [1]
> https://github.com/airblade/mysql_s3_backup/commit/457d73efeb47dbb26f0ad8782776cbec490d5f05
> _______________________________________________
> Chat mailing list
> Chat at lists.lrug.org
> http://lists.lrug.org/listinfo.cgi/chat-lrug.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lrug.org/pipermail/chat-lrug.org/attachments/20110808/ca1e215c/attachment-0003.html>