Hi Kristian, Thanks I will look into it. Regards sachin On Tue, May 2, 2017 at 6:47 PM, Kristian Nielsen <knielsen@knielsen-hq.org> wrote:
Sachin Setiya <sachin.setiya@mariadb.com> writes:
Then I executed Show slave status (couple of times in a second), and found Seconds_behind_master is changing arbitrarily
I have always found the semantics of Seconds_behind_master complex to understand.
I wrote an analysis some time ago:
https://lists.launchpad.net/maria-developers/msg08958.html https://lists.launchpad.net/maria-developers/msg08961.html
Maybe with that background, you can go back to the binlog and compare time stamps and see if the behaviour you see makes sense.
Maybe there are other places in the code where wrong timestamp is binlogged?
I do not remember if the change discussed in that email thread was ever implemented (for non-parallel replication).
- Kristian.
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp