MySQL Forums
Forum List  »  Replication

5.6.x and show slave status
Posted by: Eugene Zheganin
Date: April 22, 2013 04:56AM

Hi.

I'm using 5.6.x as a slave to 5.5.x (it's a replication chain).
MTS is off:

mysql> show variables like '%work%';
+------------------------+-------+
| Variable_name | Value |
+------------------------+-------+
| skip_networking | OFF |
| slave_parallel_workers | 0 |
+------------------------+-------+
2 rows in set (0.01 sec)

However, when I ussue a 'show slave status' command repeatedly, in the situation when the slave has a lag (for example lost of network connectivity or slave was used for backing up a large database and some tables were locked) the seconds_behind_master field shows different numbers. For example it can show hundreds of seconds and then thousands of seconds, switching between them. Bot numbers decrease until they become 0 at some moment. No question about zero, but why there are two numbers when MTS is off ? I tried to find an answer in Mysql documentation, but didn't succeed.

Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
5.6.x and show slave status
2154
April 22, 2013 04:56AM
788
April 23, 2013 07:45AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.