Hi
I’m doing backup each 30min,… and all my process is more less 21-23min until Monday.
Since yesterday and today I’m starting to get backup from near to my limit 30min more less each 2 hours… what could be happen?
so reading in my log of xtrabackup job I found scanning log time is more longer than the rest intermediates jobs
for example:
00.00 is normal get almost 27 because is full but…the next incrementals until each 2 hour are.
00.30 19min (scanning logs 3min)
01.00 20min (scanning logs 4min)
01.30 20min (scanning logs 4min)
02.00 27min (scanning logs 9min)
02.30 19min (scanning logs 3min)
03.00 20min (scanning logs 4min)
03.30 20min (scanning logs 4min)
04.00 27min (scanning logs 9min)
xtrabackup_delay_job_2h_scanning.PNG
and so on…to get today this
The script of backup is working fine since 2 month ago… could be some kind of process to save in the logs to can do this kind of delay when hit this coincidence hours because was registred into binlogs ?