Try to run "show full processlist" and check the time of currently executed processes.
Dnia 22 kwi 2012 o godz. 04:53 ron ramos <nhadie@stripped> napisał(a):
> Would it be possible to trace which query cause the lag on the slave?
> I have a script that runs every minute to check the lag,
> I basically have the output of "show slave status" and timestamp and
> how much delay: "Sun Apr 22 04:16:01 SGT 2012 -- Slave Lag: 120"
> would this be possible? thanks in advanced!
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe: http://lists.mysql.com/replication