Skip navigation links

MySQL Forums :: Replication :: measuring slave lag without sysdate() - 4.1.13


Advanced Search

Re: measuring slave lag without sysdate() - 4.1.13
Posted by: Rick James ()
Date: February 11, 2012 12:00AM

Well, I learned something!

Still I think this should work in any version:

Master: UPDATE Heartbeat SET master_time = NOW();

Slave: SELECT UNIX_TIMESTAMP() - UNIX_TIMESTAMP(master_time) FROM Heartbeat;

Options: ReplyQuote


Subject Views Written By Posted
measuring slave lag without sysdate() - 4.1.13 1514 wildcat crazy 02/07/2012 05:54AM
Re: measuring slave lag without sysdate() - 4.1.13 539 Rick James 02/08/2012 02:09AM
Re: measuring slave lag without sysdate() - 4.1.13 694 wildcat crazy 02/08/2012 04:26AM
Re: measuring slave lag without sysdate() - 4.1.13 584 Rick James 02/09/2012 11:05AM
Re: measuring slave lag without sysdate() - 4.1.13 866 wildcat crazy 02/09/2012 02:08PM
Re: measuring slave lag without sysdate() - 4.1.13 423 Rick James 02/11/2012 12:00AM
Re: measuring slave lag without sysdate() - 4.1.13 456 Baron Schwartz 02/20/2012 06:25AM


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.