# Xtrabackup affect to the performance of the server

**URL:** <https://forums.percona.com/t/xtrabackup-affect-to-the-performance-of-the-server/7855>\
**Category:** Percona XtraBackup\
**Created:** [August 5, 2020, 10:39pm UTC](https://forums.percona.com/t/xtrabackup-affect-to-the-performance-of-the-server/7855 "2020-08-05T22:39:18Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![tiench](https://avatars.discourse-cdn.com/v4/letter/t/4491bb/32.png) [@tiench](https://forums.percona.com/u/tiench)\
**Post date:** [August 5, 2020, 10:39pm UTC](https://forums.percona.com/t/xtrabackup-affect-to-the-performance-of-the-server/7855/1 "2020-08-05T22:39:18Z")

</div>

Dear Team,I’ve run a script by cronjob with Xtrabackup to backup MySQL on the server, but the websites on the server down or load a long time when it runs.  
The options I’m used to backup in the script:  
“–user=”–password=“–backup”“–extra-lsndir=”–compress"“–encrypt=AES256"”–encrypt-key-file=“–parallel=${processors}”“–encrypt-threads=${processors}”  
Please let me know the solution can solve this problem.  
Thanks and regard.

---

<div class="post-metadata">

**Author:** ![vadimtk](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vadimtk/32/9528_2.png) [@vadimtk](https://forums.percona.com/u/vadimtk)\
**Post date:** [August 6, 2020, 7:59am UTC](https://forums.percona.com/t/xtrabackup-affect-to-the-performance-of-the-server/7855/2 "2020-08-06T07:59:56Z")

</div>

if you use&nbsp;

```auto
--parallel=${processors}

```

then you allocate all your CPUs to the XtraBackup, and that of course makes your database starving for CPU resources.  
you can start with --parallel=1 and gradually increase until it does affect your website performance.  
In general the good idea is to take backups from replicas to avoid the overload of the primary server.

---

<div class="post-metadata">

**Author:** ![tiench](https://avatars.discourse-cdn.com/v4/letter/t/4491bb/32.png) [@tiench](https://forums.percona.com/u/tiench)\
**Post date:** [August 7, 2020, 12:43am UTC](https://forums.percona.com/t/xtrabackup-affect-to-the-performance-of-the-server/7855/3 "2020-08-07T00:43:16Z")

</div>

> vadimtk said: if you use&nbsp; ``` --parallel=${processors} ```  
> then you allocate all your CPUs to the XtraBackup, and that of course makes your database starving for CPU resources.  
> you can start with --parallel=1 and gradually increase until it does affect your website performance.  
> In general the good idea is to take backups from replicas to avoid the overload of the primary server.

Thanks for your support in this case, now I've edited with&nbsp;--parallel=1 and will monitor again.