Xtrabackup 2.4 very slow when prepare the backup
Bug #1645774 reported by
James chen
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB |
Incomplete
|
Undecided
|
Unassigned |
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 post a comment you must log in.
Note, there is a known issue with crash recovery being slow in 5.7: /bugs.mysql. com/bug. php?id= 80788 /bugs.mysql. com/bug. php?id= 81648
https:/
https:/
What options are you using? Have you try to change --use-memory parameter?