In some cases xtrabackup generates some huge backups (huge ibdata1)
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB |
Expired
|
Undecided
|
Unassigned | ||
2.2 |
Expired
|
Undecided
|
Unassigned | ||
2.3 |
Expired
|
Undecided
|
Unassigned |
Bug Description
Original file is 76M, backup is 93G
[roel@qaserver master-data]$ pwd
/ssd/952373/
[roel@qaserver master-data]$ du -sh
394M .
[roel@qaserver master-data]$ cd ../master-
[roel@qaserver master-
93G .
[roel@qaserver master-
total 96517488
-rw-rw-r-- 1 roel roel 98828369920 Dec 28 15:05 ibdata1
-rw-rw---- 1 roel roel 2729778 Dec 28 14:53 ibdata1.qp
-rw-rw---- 1 roel roel 2768896 Dec 28 14:53 ib_logfile0
-rw-rw-r-- 1 roel roel 0 Dec 28 15:05 ib_logfile101
drwx------ 2 roel roel 4096 Dec 28 14:53 mysql
drwx------ 2 roel roel 4096 Dec 28 14:53 test
-rw-rw---- 1 roel roel 93 Dec 28 14:53 xtrabackup_
[roel@qaserver master-
total 176144
-rw-rw---- 1 roel roel 56 Dec 28 14:53 auto.cnf
-rw-rw---- 1 roel roel 79691776 Dec 28 14:53 ibdata1
-rw-rw---- 1 roel roel 50331648 Dec 28 14:52 ib_logfile0
-rw-rw---- 1 roel roel 50331648 Dec 28 14:52 ib_logfile1
drwxr-xr-x 2 roel roel 4096 Dec 28 14:52 mysql
drwxrwx--- 2 roel roel 4096 Dec 28 14:53 performance_schema
drwxr-xr-x 2 roel roel 4096 Dec 28 14:53 test
[roel@qaserver master-
-rw-rw-r-- 1 roel roel 93G Dec 28 15:05 ibdata1
[roel@qaserver master-
-rw-rw---- 1 roel roel 76M Dec 28 14:53 ../master-
Options used for xtrabackup:
# 2013-12-28T14:45:35 Executing backup: /ssd/xtrabackup -dbg-281213- 1101/bin/ xtrabackup --compress --backup --datadir= /ssd//952373/ current1_ 2/master- data --target- dir=/ssd/ /952373/ current1_ 2/master- data_xtrabackup _3358 -dbg-281213- 1101/bin/ xtrabackup --compress --prepare --target- dir=/ssd/ /952373/ current1_ 2/master- data_xtrabackup _3358 -dbg-281213- 1101/bin/ xtrabackup --compress --prepare --target- dir=/ssd/ /952373/ current1_ 2/master- data_xtrabackup _3358
# 2013-12-28T14:45:40 Preparing backup: /ssd/xtrabackup
# 2013-12-28T14:45:40 Running second prepare: /ssd/xtrabackup