MySQL Forums
Forum List  »  Replication

"Seconds behind master"-Value jumping
Posted by: Moritz Honig
Date: April 13, 2009 08:15AM


we have a MySQL-Replication with one master and one slave. From today one my monitoring system started sending me SMS as the "Seconds behind master"-Value on our slave (looked up with "SHOW SLAVE STATUS\G") was between 554 and 557. The only thing we changed today: We started sending Select-Queiies to our slave too.

Interesting: There is no difference in data. When I check the consistency of the data manually, everything is okay. When i execute the "SHOW SLAVE STATUS\G"-Query 20 times on the slave manually (twice a second), in 18 cases the "Seconds behind master"-Value is 0 and in 2 cases it's between 554 and 557. Absolutely strange...

Maybe anybody has an idea here? The server times are identically.

Thanks in advance,

Options: ReplyQuote

Written By
"Seconds behind master"-Value jumping
April 13, 2009 08:15AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.