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;
Subject
Views
Written By
Posted
3080
February 07, 2012 05:54AM
1006
February 08, 2012 02:09AM
1175
February 08, 2012 04:26AM
1122
February 09, 2012 11:05AM
1462
February 09, 2012 02:08PM
Re: measuring slave lag without sysdate() - 4.1.13
906
February 11, 2012 12:00AM
925
February 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.