← Back to team overview

launchpad-dev team mailing list archive

Re: DB replication lag events

 

On Wed, Aug 25, 2010 at 9:09 AM, Stuart Bishop
<stuart.bishop@xxxxxxxxxxxxx> wrote:

> I'm not sure what this script is doing. Perhaps it is committing all
> its changes in a single transaction? Perhaps it is sometimes touching
> far more rows than expected?

If I narrow down the window, I get a much bigger spike so it looks
like a single commit containing too many changes to swallow:

$ ./report-database-stats.py --from='2010-08-24 01:33'
--until='2010-08-24 01:39'

                        pofiletranslator ||    1063.01 tuples/sec

(I can't narrow the window any further - the statistics snapshots are
only updated every few minutes)



-- 
Stuart Bishop <stuart@xxxxxxxxxxxxxxxx>
http://www.stuartbishop.net/



Follow ups

References