List:Replication« Previous MessageNext Message »
From:Revathi Rangachari Date:April 2 2012 10:07pm
Subject:RE: Seconds Behind Master increasing in slave
View as plain text  
The update statements run very fast.  Not more than 1 or 2 seconds

Thanks
Revathi R

--- On Tue, 4/3/12, David Lerer <DLerer@stripped> wrote:

> From: David Lerer <DLerer@stripped>
> Subject: RE: Seconds Behind Master increasing in slave
> To: "'masirrev@stripped'" <masirrev@stripped>, "replication@stripped"
<replication@stripped>
> Date: Tuesday, April 3, 2012, 1:56 AM
> How long did the one update statement
> run?
> (A slow update, even if it is a single transaction, can slow
> down replication.
> David.
> 
> -----Original Message-----
> From: Revathi Rangachari [mailto:masrrev@stripped]
> 
> Sent: Monday, April 02, 2012 3:42 PM
> To: replication@stripped
> Subject: Seconds Behind Master increasing in slave
> 
> Hi
> 
> We have a master-slave setup.  The slave acts only as a
> replicate and does not cater to any client requests.
> 
> Over the last 24 hours there has been more than 4 to 6 hours
> delay in the replication.  The CPU, IO, memory usage
> all seem to be under control.  I changed the  SET
> GLOBAL innodb_flush_log_at_trx_commit = 0 ;
> 
> The slave sql and io threads are running.
> show processlist shows only one update statement on a
> table.
> 
> In spite of all this the slave still lags behind in
> replication by 5 hours. 
>  
> Any suggestion to improve the replication performance is
> highly appreciated.
> 
> Thanks
> Revathi R
> 
> 
> 
> -- 
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe:    http://lists.mysql.com/replication
> 
> 
> The information contained in this e-mail and any attached
> documents may be privileged, confidential and protected
> from
> disclosure.  If you are not the intended recipient you
> may not
> read, copy, distribute or use this information.  If you
> have
> received this communication in error, please notify the
> sender
> immediately by replying to this message and then delete it
> from your system.
> 
> --
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe:    http://lists.mysql.com/replication
> 
> 
Thread
adding another slavenhadie ramos1 Apr
  • Re: adding another slavea.smith1 Apr
  • Re: adding another slaveNeil Armitage1 Apr
    • Re: adding another slavenhadie ramos1 Apr
      • Seconds Behind Master increasing in slaveRevathi Rangachari2 Apr
        • RE: Seconds Behind Master increasing in slaveDavid Lerer2 Apr
          • Re: Seconds Behind Master increasing in slaveArthur Fuller2 Apr
            • Re: Seconds Behind Master increasing in slaveRick James2 Apr
              • Re: Seconds Behind Master increasing in slaveRevathi Rangachari2 Apr
                • Re: Seconds Behind Master increasing in slavePankaj Joshi3 Apr
            • Re: Seconds Behind Master increasing in slaveRevathi Rangachari2 Apr
              • Re: Seconds Behind Master increasing in slavenehal dattani2 Apr
                • Re: Seconds Behind Master increasing in slaveRevathi Rangachari2 Apr
          • RE: Seconds Behind Master increasing in slaveRevathi Rangachari2 Apr