2 May
2017
2 May
'17
3:17 p.m.
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.