Xbstream extremely slow

General Questions
1

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

1 Like
2

Hi there,

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

1 Like
3

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

1 Like
4

Hi!

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

1 Like
6

I got this one thanks guys.

1 Like
7

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

1 Like
8

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.

1 Like