List:Replication« Previous MessageNext Message »
From:Revathi Rangachari Date:April 2 2012 7:41pm
Subject:Seconds Behind Master increasing in slave
View as plain text  
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


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