Comment 2 for bug 1645774

I use this option --use-memory=50G, I can understand 5.7 recovery is slow
but if it is slow like this: only apply 10% of log record for one day, then
the xtrabackup tools is useless. It need more than 10 days to apply the log
file, then the slave will never catch up after that.

Thanks,

On Tue, Nov 29, 2016 at 6:47 PM, Sergei Glushchenko <
<email address hidden>> wrote:

> Note, there is a known issue with crash recovery being slow in 5.7:
> https://bugs.mysql.com/bug.php?id=80788
> https://bugs.mysql.com/bug.php?id=81648
>
> What options are you using? Have you try to change --use-memory
> parameter?
>
> ** Bug watch added: MySQL Bug System #80788
> http://bugs.mysql.com/bug.php?id=80788
>
> ** Bug watch added: MySQL Bug System #81648
> http://bugs.mysql.com/bug.php?id=81648
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/1645774
>
> Title:
> Xtrabackup 2.4 very slow when prepare the backup
>
> Status in Percona XtraBackup:
> New
>
> Bug description:
> We upgrade Percona server 5.6 to 5.7, when try to set up new slave use
> Xtrabackup, we find have to upgrade it from 2.3 to 2.4 in order to
> backup the 5.7 database.
>
> The problem is after the data copy finished when start to parepare the
> backup, the apply log records process is very slow. The
> xtrabackup_logfile file is about 500G, after one day it only apply
> around 10%.
>
> When we tried Xtrabackup 2.3 on the same data with Percona 5.6 (we
> still keep one slave as 5.6 just in case), the prepare process only
> take about 5 hours, the xtrabackup_logfile is about 600G
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/percona-xtrabackup/+bug/1645774/+subscriptions
>