I have no idea
how this can happen and how a script
can affect the replication lag while it does nothing than
sleeping.
By holding a lock. I don't know if this is the case here, but it would
be an explanation. Are you using explicit transactions?
But I will not start it again - then there are
just
no statistic updates anymore.
Please tell me what queries exactly the script performs. I'm pretty sure
this could be done more efficiently somehow - for example, by using at
the recentchanges table instead of revisions.
BTW, the lag raises very often even if this
scripts
does'nt run ..
Every time the replag rises like this, we find a script that's causing
it. It's not always yours, sure, but it has been before.
Don't think we just want to blame you - your efforts are appreciated.
The toolserver is just at its limits right now (we *still* don't have
the fast disk online - this is really annoying). We have to cope somehow.
Regards
Daniel
Sorry to interrupt here, but I'm only getting one side of these emails
(those from Daniel); I've checked that it's not a filtering problem on
my end, so I'm a bit confused. Wondering if anyone else is having this
problem?
Essjay
--