MySQL Tutorial – Understanding The Seconds Behind Master Value
Scalegrid
JANUARY 30, 2019
In a MySQL hosting replication setup, the parameter Seconds_Behind_Master (SBM), as displayed by the SHOW SLAVE STATUS command, is commonly used as an indication of the current replication lag of the slave. In this blog post, we examine how to understand and interpret this value in various situations. Possible Values of Seconds Behind Master. The value of SBM, as explained in the MySQL documentation , depends on the state of the MySQL slave in general, and the states of MySQL slave SQL_THREAD
Let's personalize your content