MySQL Forums
Forum List  »  Replication

Seconds_Behind_Master strangely fluctuating
Posted by: Julien Walther
Date: November 05, 2005 03:49AM

Hello, everyone,

on one of our latest slaves in a one master/three slaves relication scenario, one slave is showing strange fluctuations of the value "Seconds_Behind_Master". Even during low-accessed times, when all other slaves with the same configuration show 0 as value, it sometimes goes to 15 seconds, then 14, then back to 0 again. But not slowly as it would during high load. if you refresh the value very often, you get results like:
0 0 0 0 15 14 0 0 0 0 0 15 14 ... sometimes also 7 and 6 instead of 15/14. this is strange.

fedora core 2, mysql 4.1.11

any advice highly appreciated.

thank you very much,
julien

Options: ReplyQuote


Subject
Views
Written By
Posted
Seconds_Behind_Master strangely fluctuating
2466
November 05, 2005 03:49AM


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.