# The value of Seconds\_Behind\_Master is increasing

**URL:** <https://forums.percona.com/t/the-value-of-seconds-behind-master-is-increasing/5799>\
**Category:** Other MySQL® Questions\
**Created:** [August 8, 2017, 10:01pm UTC](https://forums.percona.com/t/the-value-of-seconds-behind-master-is-increasing/5799 "2017-08-08T22:01:17Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![keith](https://avatars.discourse-cdn.com/v4/letter/k/f05b48/32.png) [@keith](https://forums.percona.com/u/keith)\
**Post date:** [August 8, 2017, 10:01pm UTC](https://forums.percona.com/t/the-value-of-seconds-behind-master-is-increasing/5799/1 "2017-08-08T22:01:17Z")

</div>

I saw on the slave Seconds\_Behind\_Master increasing.But the master did not perform large transactions.

This is ‘show slave status \G’ part of the results：  
Slave\_IO\_Running: Yes  
Slave\_SQL\_Running: Yes  
Replicate\_Do\_DB:  
Replicate\_Ignore\_DB: test  
Replicate\_Do\_Table:  
Replicate\_Ignore\_Table:  
Replicate\_Wild\_Do\_Table:  
Replicate\_Wild\_Ignore\_Table:  
Last\_Errno: 0  
Last\_Error:  
Skip\_Counter: 0  
Exec\_Master\_Log\_Pos: 164396778  
Relay\_Log\_Space: 654817698  
Until\_Condition: None  
Until\_Log\_File:  
Until\_Log\_Pos: 0  
Master\_SSL\_Allowed: No  
Master\_SSL\_CA\_File:  
Master\_SSL\_CA\_Path:  
Master\_SSL\_Cert:  
Master\_SSL\_Cipher:  
Master\_SSL\_Key:  
Seconds\_Behind\_Master: 10995  
Master\_SSL\_Verify\_Server\_Cert: No  
Last\_IO\_Errno: 0  
Last\_IO\_Error:  
Last\_SQL\_Errno: 0  
Last\_SQL\_Error:  
Replicate\_Ignore\_Server\_Ids:  
Master\_Server\_Id: 193  
SQL\_Delay: 0

when I run ‘show full processlist’ I can see UPDATE ,and the id is constantly changing.There is no data written in addition to master,but the value of Seconds\_Behind\_Master is increasing.

Master percona server version is 5.6.36-82.0-log,system version is centos7.  
Slave percona server version is 5.6.36-82.1-log,system version is centos5.

Tell me the way to check,Please.  
Thanks.

---

<div class="post-metadata">

**Author:** ![nvngpt31](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/nvngpt31/32/1183_2.png) [@nvngpt31](https://forums.percona.com/u/nvngpt31)\
**Post date:** [August 11, 2017, 8:27am UTC](https://forums.percona.com/t/the-value-of-seconds-behind-master-is-increasing/5799/2 "2017-08-11T08:27:55Z")

</div>

Can you confirm like Exec\_Master\_Log\_Pos: is changing?

---

<div class="post-metadata">

**Author:** ![keith](https://avatars.discourse-cdn.com/v4/letter/k/f05b48/32.png) [@keith](https://forums.percona.com/u/keith)\
**Post date:** [August 20, 2017, 8:36pm UTC](https://forums.percona.com/t/the-value-of-seconds-behind-master-is-increasing/5799/3 "2017-08-20T20:36:13Z")

</div>

> [@nvngpt31&#64;gmail.com;49384](#):
>
> Can you confirm like Exec\_Master\_Log\_Pos: is changing?

Thank you for helping me .  
Yes , It is changing. I found the reason for the problem. Scheduled tasks on the master server is working without index. And the disk of master server is SSD , the slave is HHD. Each modification of a record requires a full table scan.I stopped the scheduled task and returned to normal.