MySQL Forums :: Replication :: "Seconds behind master"-Value jumping

Advanced Search

"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

Subject Views Written By Posted
"Seconds behind master"-Value jumping 4432 Moritz Honig 04/13/2009 08:15AM
Re: "Seconds behind master"-Value jumping 2164 Rick James 04/15/2009 12:28AM

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.