Bacula-users

Re: [Bacula-users] Fixing InnoDB lock wait timeouts

2010-03-08 16:34:03
Subject: Re: [Bacula-users] Fixing InnoDB lock wait timeouts
From: Jesper Krogh <jesper AT krogh DOT cc>
To: Phil Stracchino <alaric AT metrocast DOT net>
Date: Mon, 08 Mar 2010 22:31:30 +0100
Phil Stracchino wrote:
> On 03/08/10 13:32, Jesper Krogh wrote:
>> Phil Stracchino wrote:
>>> If the problem still occurs, something else is going on.  But this
>>> should fix the problem in probably >99% of cases in which the 50-second
>>> timeout is only infrequently being exceeded.
>> It hugely depends on your fileset sizes.. I have some in the order of
>> 10m records.. and exceeding 100s is definately not a problem.
> 
> Yes, but when you're dealing with filesets that large, you're going to
> be REGULARLY exceeding it, right?  Doubling it to 100s *should* take
> care of almost all cases in which it just occasionally goes over 50s.

I didn't .. it mainly happened when two "large" backups ended up
"Inserting attributes" at the same time. Which didnt happen regulary.

-- 
Jesper

------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users

<Prev in Thread] Current Thread [Next in Thread>