List:Replication« Previous MessageNext Message »
From:ron ramos Date:April 24 2012 1:59pm
Subject:Re: tracing cause of lag
View as plain text  
Hi All,

I just added show full processlist on my script as suggested by Stanislaw,
so i would know what query is causing it.

Regards,
Ron

On Tue, Apr 24, 2012 at 9:01 PM, Eber Duarte <ebermduarte@stripped>wrote:

> Did you try to calculate diff between master and slave binlog positions?
> Can be a measure for delay not based on timestamps, that are only updated
> after statement is finished on slave host (at least for MySQL version
> without heart beat).
>
> Regards,
>
> Eber.
>
> --- Em *dom, 22/4/12, Stanisław Stadnicki <stadnicki@stripped>* escreveu:
>
>
> De: Stanisław Stadnicki <stadnicki@stripped>
> Assunto: Re: tracing cause of lag
> Para: "ron ramos" <nhadie@stripped>
> Cc: "replication@stripped" <replication@stripped>
> Data: Domingo, 22 de Abril de 2012, 4:05
>
>
> Hi,
> Try to run "show full processlist" and check the time of currently
> executed processes.
>
> Regards
> Stan
>
>
>
> Dnia 22 kwi 2012 o godz. 04:53 ron ramos
> <nhadie@stripped<http://mc/compose?to=nhadie@ style="color:#666">stripped>>
> napisał(a):
>
> > Hi,
> >
> > 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!
> >
> > Regards,
> > Ron
> >
> > --
> > MySQL Replication Mailing List
> > For list archives: http://lists.mysql.com/replication
> > To unsubscribe:    http://lists.mysql.com/replication
> >
>
> --
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe:    http://lists.mysql.com/replication
>
>

Thread
tracing cause of lagron ramos22 Apr
  • Re: tracing cause of lagStanisław Stadnicki22 Apr
    • RE: tracing cause of lagRick James23 Apr
    • Re: tracing cause of lagEber Duarte24 Apr
      • Re: tracing cause of lagron ramos24 Apr