← Back to team overview

launchpad-dev team mailing list archive

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