launchpad-dev team mailing list archive
-
launchpad-dev team
-
Mailing list archive
-
Message #07692
Re: performance tuesday - contention and the importance of short transactions
On 26 July 2011 15:57, Robert Collins <robertc@xxxxxxxxxxxxxxxxx> wrote:
> For performance tuesday today, I spent a little time checking for new
> oopses, trying to get a handle on existing ones.
>
> One in particular stood out - https://launchpad.net/bugs/816235 -
> where we had a trivial insert take over 9 seconds. We've had a number
> of this sort of thing and often handwaved it off as contention or been
> unable to really pin it down to a specific event which we can then
> design away.
The other case like this I hit recently was
<https://bugs.launchpad.net/bugs/294726>, where what should be trivial
query was timed out after nine seconds. Three years ago mwh
speculated it was contention with the scanner.
Martin
References