innobackupex increase database size

MySQL & MariaDB Percona XtraBackup
1

Hello,

Can you help me with my problem.

I use this command line to backup my 500Gb database (INNODB).
innobackupex --user=$BDD_LOGIN --password=$BDD_PASSWORD --compress $LATEST_DIR --compress-threads=4 --parallel=2 --no-lock

My problem is everyday after each backup I noticed an increase of 5Gb on my databasesize. Can you explain why?
I did not have this problem with regular mysqldump.

I assumed it may have something to do with fragmentation because I did not start my database with innodb_file_per_table options but I am not sure.

Regards,

Geoffrey

2

I just find out ibdata1 cannot be fragmented. So I have absolutely no idea why my database keep growing after each backup.

3

Hi tdelnatte, could you give me the version of xtrabackup you are using and your MySQL version? Is the increase noticable only on ibdata1 and if so, you are talking about a sudden increase (autoextend) of the ibdata file?