launchpad-dev team mailing list archive
-
launchpad-dev team
-
Mailing list archive
-
Message #04474
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