Not the answer you need?
Register and ask your own question!

Replication show unexpected seconds_behind_master

susantomahato88susantomahato88 EntrantCurrent User Role Beginner
On slave status some time it shows seconds_behind_master 0 and suddenly 16555 and again 0 ,is it any type of bug or what can any one please elaborate why it happen i am using percona server 5.6.

Comments

  • scott.nemesscott.nemes MySQL Sage Current User Role Patron
    Hi susantomahato88;

    The seconds_behind_master status variable is just an estimate. You likely have DML (i.e. ALTER TABLE) or a large bulk INSERT/UPDATE/DELETE that just finished running. MySQL will see that, and guess that it will take a certain period of time (16555 seconds in your case), but it ends up going much quicker in a lot of cases.

    -Scott
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.