How can it
affect the replication lag then? Please find out
the real source of these problems and do not kill random
processes.
It was definitely the cause. it was the only thing that was started when
replag started to rise, and when it was killed, replag dropped instantly
(it did not drop while the script was paused). it *was* your script. I'm
not sure why, but it was.
I asked DaB to save a copy of SHOW FULL PROCESSLIST next time something
like this happens, so we can investigate more closely. Right now I don't
have enough information to tell you what precisely happened.
I have no idea how this can happen and how a script
can affect the replication lag while it does nothing than
sleeping. But I will not start it again - then there are just
no statistic updates anymore.
BTW, the lag raises very often even if this scripts
does'nt run ..
-- Aka