Wed.Jan 30, 2019

article thumbnail

MySQL Tutorial – Understanding The Seconds Behind Master Value

Scalegrid

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

Speed 197