| 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 slave | nhadie ramos | 1 Apr |
| • Re: adding another slave | a.smith | 1 Apr |
| • Re: adding another slave | Neil Armitage | 1 Apr |
| • Re: adding another slave | nhadie ramos | 1 Apr |
| • Seconds Behind Master increasing in slave | Revathi Rangachari | 2 Apr |
| • RE: Seconds Behind Master increasing in slave | David Lerer | 2 Apr |
| • Re: Seconds Behind Master increasing in slave | Arthur Fuller | 2 Apr |
| • Re: Seconds Behind Master increasing in slave | Rick James | 2 Apr |
| • Re: Seconds Behind Master increasing in slave | Revathi Rangachari | 2 Apr |
| • Re: Seconds Behind Master increasing in slave | Pankaj Joshi | 3 Apr |
| • Re: Seconds Behind Master increasing in slave | Revathi Rangachari | 2 Apr |
| • Re: Seconds Behind Master increasing in slave | nehal dattani | 2 Apr |
| • Re: Seconds Behind Master increasing in slave | Revathi Rangachari | 2 Apr |
| • RE: Seconds Behind Master increasing in slave | Revathi Rangachari | 2 Apr |
