Not the answer you need?
Register and ask your own question!

innobackupex doesnt remove *qp files after decompress

Hello everybody,

I cant get why PerconaXtraBackup doesnt delete qp-files after decompress option. Backup was made using older version of innobackupex but there is no error or warning during decompress procedure.


Backup was made on:

[[email protected] vlad_main_xbackup_full_last]# innobackupex --version
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved.
This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.
Get the latest version of Percona XtraBackup, documentation, and help resources:
http://www.percona.com/xb/p
[[email protected] vlad_main_xbackup_full_last]# mysqld --version
mysqld Ver 5.6.25 for Linux on x86_64 (MySQL Community Server (GPL))
[[email protected] vlad_main_xbackup_full_last]# cat /etc/redhat-release
CentOS release 6.6 (Final)

Backup is being used on:

[[email protected] /]# innobackupex --version
innobackupex version 2.4.4 Linux (x86_64) (revision id: df58cf2)
[[email protected] /]# mysqld --version
mysqld Ver 5.6.32 for Linux on x86_64 (MySQL Community Server (GPL))
[[email protected] /]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.2 (Maipo)


Before decompress:
[[email protected] /]# du -sh /mysql/vlad_main_xbackup_full_last/billing/*.ibd --total
du: cannot access «/mysql/vlad_main_xbackup_full_last/billing/*.ibd»: No such file or directory
0 total
[[email protected] /]# du -sh /mysql/vlad_main_xbackup_full_last/billing/*.qp --total
3.8G total
[[email protected] /]# ls -l /mysql/vlad_main_xbackup_full_last/billing/accounts*ibd*
.
-rw-r
1 root root 2345 Авг 3 13:04 /mysql/vlad_main_xbackup_full_last/billing/accounts_addons_staff.ibd.qp
-rw-r
1 root root 5400996 Авг 3 13:04 /mysql/vlad_main_xbackup_full_last/billing/accounts_addons_vals.ibd.qp
-rw-r
1 root root 5626664 Авг 3 13:04 /mysql/vlad_main_xbackup_full_last/billing/accounts_addr.ibd.qp
-rw-r
1 root root 17667926 Авг 3 13:04 /mysql/vlad_main_xbackup_full_last/billing/accounts_backup.ibd.qp
-rw-r
1 root root 4335460 Авг 3 13:04 /mysql/vlad_main_xbackup_full_last/billing/accounts.ibd.qp
.

During decompression:
[[email protected] /]# innobackupex --decompress $PERBAK
160803 12:41:00 innobackupex: Starting the decrypt and decompress operation
IMPORTANT: Please check that the decrypt and decompress run completes successfully.
At the end of a successful decrypt and decompress run innobackupex
prints "completed OK!".
innobackupex version 2.4.4 based on MySQL server 5.7.13 Linux (x86_64) (revision id: df58cf2)
.
160803 12:41:59 [01] decompressing ./billing/accounts_backup.ibd.qp
160803 12:42:00 [01] decompressing ./billing/accounts.ibd.qp
.
160803 12:43:52 completed OK!


After decompress:
[[email protected] /]# du -sh /mysql/vlad_main_xbackup_full_last/billing/*.ibd --total
13G total
[[email protected] /]# du -sh /mysql/vlad_main_xbackup_full_last/billing/*.qp --total
3.8G total
[[email protected] /]# ls -l /mysql/vlad_main_xbackup_full_last/billing/accounts*ibd*
.
-rw-r--r-- 1 root root 114688 Aug 3 12:41 /mysql/vlad_main_xbackup_full_last/billing/accounts_addons_staff.ibd
-rw-r--r-- 1 mygolenk reguser 2345 Aug 3 10:21 /mysql/vlad_main_xbackup_full_last/billing/accounts_addons_staff.ibd.qp
-rw-r--r-- 1 root root 37748736 Aug 3 12:42 /mysql/vlad_main_xbackup_full_last/billing/accounts_addons_vals.ibd
-rw-r--r-- 1 mygolenk reguser 5400996 Aug 3 10:20 /mysql/vlad_main_xbackup_full_last/billing/accounts_addons_vals.ibd.qp
-rw-r--r-- 1 root root 37748736 Aug 3 12:41 /mysql/vlad_main_xbackup_full_last/billing/accounts_addr.ibd
-rw-r--r-- 1 mygolenk reguser 5626664 Aug 3 10:22 /mysql/vlad_main_xbackup_full_last/billing/accounts_addr.ibd.qp
-rw-r--r-- 1 root root 100663296 Aug 3 12:42 /mysql/vlad_main_xbackup_full_last/billing/accounts_backup.ibd
-rw-r--r-- 1 mygolenk reguser 17667926 Aug 3 10:21 /mysql/vlad_main_xbackup_full_last/billing/accounts_backup.ibd.qp
-rw-r--r-- 1 root root 25165824 Aug 3 12:42 /mysql/vlad_main_xbackup_full_last/billing/accounts.ibd
-rw-r--r-- 1 mygolenk reguser 4335460 Aug 3 10:21 /mysql/vlad_main_xbackup_full_last/billing/accounts.ibd.qp
.

Best regards,
Mikhail

Comments

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.