List:Replication« Previous MessageNext Message »
From:David Lerer Date:April 2 2012 8:26pm
Subject:RE: Seconds Behind Master increasing in slave
View as plain text  
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.
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