# innobackupex --incremental is very slow

**URL:** <https://forums.percona.com/t/innobackupex-incremental-is-very-slow/6931>\
**Category:** Percona XtraBackup\
**Created:** [March 27, 2019, 10:03am UTC](https://forums.percona.com/t/innobackupex-incremental-is-very-slow/6931 "2019-03-27T10:03:52Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![hvardan71](https://avatars.discourse-cdn.com/v4/letter/h/7ba0ec/32.png) [@hvardan71](https://forums.percona.com/u/hvardan71)\
**Post date:** [March 27, 2019, 10:03am UTC](https://forums.percona.com/t/innobackupex-incremental-is-very-slow/6931/1 "2019-03-27T10:03:52Z")

</div>

Hello  
We running a incremental right after the full backup is completing (3h)

Full:  
innobackupex --no-backup-locks --throttle=40 --parallel=4 --use-memory=5G --rsync --no-timestamp --user=root --password=VOqvfKCc7mB\_jM --databases=“${db\_list}” $BACKUP\_FOLDER

Incremental:  
to\_lsn=`grep to_lsn ${BACKUP_FOLDER}/xtrabackup_checkpoints | awk '{ print $3 }'`  
innobackupex --no-lock --safe-slave-backup --no-backup-locks --throttle=30 --parallel=4 --use-memory=5G --rsync --no-timestamp --user=root --password=VOqvfKCc7mB\_jM --databases=“${db\_list}” --incremental /bkp/inc --incremental-lsn=$to\_lsn

And now this incremental is taking longer than full backup - running already 4h

Any one can help?

---

<div class="post-metadata">

**Author:** ![lorraine.pocklington](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lorraine.pocklington/32/37_2.png) [@lorraine.pocklington](https://forums.percona.com/u/lorraine.pocklington)\
**Post date:** [March 27, 2019, 10:19am UTC](https://forums.percona.com/t/innobackupex-incremental-is-very-slow/6931/2 "2019-03-27T10:19:04Z")

</div>

Hi there, is this a new set up? Or is it a long lived process that’s suddenly started acting differently?

Could you let us have the version of innbackupex, what you’re backing up (e.g. MySQL, Percona Server for MySQL), versions and environment info? Meanwhile I’ll see if there’s anyone about with suggestions…

---

<div class="post-metadata">

**Author:** ![hvardan71](https://avatars.discourse-cdn.com/v4/letter/h/7ba0ec/32.png) [@hvardan71](https://forums.percona.com/u/hvardan71)\
**Post date:** [March 27, 2019, 2:03pm UTC](https://forums.percona.com/t/innobackupex-incremental-is-very-slow/6931/3 "2019-03-27T14:03:31Z")

</div>

MySQL is Percona:  
Welcome to the MySQL monitor. Commands end with ; or \g.  
Your MySQL connection id is 1244039  
Server version: 5.7.19-17-log Percona Server (GPL), Release 17, Revision e19a6b7b73f

Innobackupex:  
innobackupex version 2.4.13 based on MySQL server 5.7.19 Linux (x86\_64) (revision id: 3e7ca7c)

OS:  
CentOS Linux release 7.3.1611 (Core)

Disk:  
SSD

Location: Google Cloud

I tried with 40 also - same result.

It is a new setup - the backup solution.  
The server is already running for about 1-1.5 year

Thank you

---

<div class="post-metadata">

**Author:** ![lorraine.pocklington](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lorraine.pocklington/32/37_2.png) [@lorraine.pocklington](https://forums.percona.com/u/lorraine.pocklington)\
**Post date:** [April 11, 2019, 5:09am UTC](https://forums.percona.com/t/innobackupex-incremental-is-very-slow/6931/4 "2019-04-11T05:09:28Z")

</div>

Hello again, apologies for the delay in response, I’ve been out of office.  
Would you be able to provide the logs of full and incremental backup? We need to be able to pinpoint where the back up is taking its time. I can let you have an email address if you don’t want them to be made publicly available.