# Xbstream extremely slow

**URL:** <https://forums.percona.com/t/xbstream-extremely-slow/11549>\
**Category:** General Questions\
**Created:** [July 27, 2021, 1:31pm UTC](https://forums.percona.com/t/xbstream-extremely-slow/11549 "2021-07-27T13:31:45Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rudrojit](https://avatars.discourse-cdn.com/v4/letter/r/e47c2d/32.png) [@Rudrojit](https://forums.percona.com/u/Rudrojit)\
**Post date:** [July 27, 2021, 1:31pm UTC](https://forums.percona.com/t/xbstream-extremely-slow/11549/1 "2021-07-27T13:31:45Z")

</div>

I tried --stream=xbstream | gzip - \> /backup.xbstream.gz  
after unzipping when I tried to extract the files using using xbstream -x backup.xbstream it is taking way longer than usual. Is this a default behavior? are there ways to resolve this?

Xtrabackup 8.0.23-16  
Centos server 7  
percona mysql 8.0.22

---

<div class="post-metadata">

**Author:** ![Marcelo\_Altmann](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/marcelo_altmann/32/11299_2.png) [@Marcelo\_Altmann](https://forums.percona.com/u/Marcelo_Altmann)\
**Post date:** [July 27, 2021, 2:01pm UTC](https://forums.percona.com/t/xbstream-extremely-slow/11549/2 "2021-07-27T14:01:27Z")

</div>

Hi there,

You can speed up extraction by parallelizing the work using `--parallel` option.

---

<div class="post-metadata">

**Author:** ![Rudrojit](https://avatars.discourse-cdn.com/v4/letter/r/e47c2d/32.png) [@Rudrojit](https://forums.percona.com/u/Rudrojit)\
**Post date:** [July 27, 2021, 5:31pm UTC](https://forums.percona.com/t/xbstream-extremely-slow/11549/3 "2021-07-27T17:31:31Z")

</div>

are there any dependencies based on which I should set the value? I tried with --parallel=4 and the response was same no change.

---

<div class="post-metadata">

**Author:** ![CTutte](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ctutte/32/1341_2.png) [@CTutte](https://forums.percona.com/u/CTutte)\
**Post date:** [July 28, 2021, 12:48pm UTC](https://forums.percona.com/t/xbstream-extremely-slow/11549/4 "2021-07-28T12:48:52Z")

</div>

Hi!

Did you check disk/CPU usage? Maybe there is hardware saturation.

---

<div class="post-metadata">

**Author:** ![Rudrojit](https://avatars.discourse-cdn.com/v4/letter/r/e47c2d/32.png) [@Rudrojit](https://forums.percona.com/u/Rudrojit)\
**Post date:** [July 28, 2021, 2:14pm UTC](https://forums.percona.com/t/xbstream-extremely-slow/11549/6 "2021-07-28T14:14:42Z")

</div>

I got this one thanks guys.

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [July 28, 2021, 9:12pm UTC](https://forums.percona.com/t/xbstream-extremely-slow/11549/7 "2021-07-28T21:12:25Z")

</div>

@Rudrojit Can you please share your fix so that others can benefit as well? Thanks.

---

<div class="post-metadata">

**Author:** ![Rudrojit](https://avatars.discourse-cdn.com/v4/letter/r/e47c2d/32.png) [@Rudrojit](https://forums.percona.com/u/Rudrojit)\
**Post date:** [July 29, 2021, 12:13pm UTC](https://forums.percona.com/t/xbstream-extremely-slow/11549/8 "2021-07-29T12:13:47Z")

</div>

I was doing it wrong all this time  
I was doing xbstream -x bkpfile.xbstream --parallel=100 where as it should be  
xbstream -x --parallel=10 \< bkpfile.xbstream -C /path-to-decompressed-files/

this pattern is not mentioned in percona site.