Skip navigation links

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


Advanced Search

measuring slave lag without sysdate() - 4.1.13
Posted by: wildcat crazy ()
Date: February 07, 2012 05:54AM

Hi everyone,

I'm forced to use 4.1.13 still, and was surprised to discover that sysdate() seems to be affected by Set Timestamp in this version?

The problem with this is that I can't measure the replication lag using the usual method of inserting "heartbeat" in master and slave time using sysdate().

Does anyone have any ideas how else I might be able to hack this up until I can get the people involved to agree to upgrading?

thanks!

Options: ReplyQuote


Subject Views Written By Posted
measuring slave lag without sysdate() - 4.1.13 1266 wildcat crazy 02/07/2012 05:54AM
Re: measuring slave lag without sysdate() - 4.1.13 481 Rick James 02/08/2012 02:09AM
Re: measuring slave lag without sysdate() - 4.1.13 627 wildcat crazy 02/08/2012 04:26AM
Re: measuring slave lag without sysdate() - 4.1.13 535 Rick James 02/09/2012 11:05AM
Re: measuring slave lag without sysdate() - 4.1.13 756 wildcat crazy 02/09/2012 02:08PM
Re: measuring slave lag without sysdate() - 4.1.13 360 Rick James 02/11/2012 12:00AM
Re: measuring slave lag without sysdate() - 4.1.13 400 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.