# innobackupex increase database size

**URL:** <https://forums.percona.com/t/innobackupex-increase-database-size/2878>\
**Category:** Percona XtraBackup\
**Created:** [August 13, 2013, 8:25am UTC](https://forums.percona.com/t/innobackupex-increase-database-size/2878 "2013-08-13T08:25:28Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![tdelnatte](https://avatars.discourse-cdn.com/v4/letter/t/edb3f5/32.png) [@tdelnatte](https://forums.percona.com/u/tdelnatte)\
**Post date:** [August 13, 2013, 8:25am UTC](https://forums.percona.com/t/innobackupex-increase-database-size/2878/1 "2013-08-13T08:25:28Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![tdelnatte](https://avatars.discourse-cdn.com/v4/letter/t/edb3f5/32.png) [@tdelnatte](https://forums.percona.com/u/tdelnatte)\
**Post date:** [August 13, 2013, 8:34am UTC](https://forums.percona.com/t/innobackupex-increase-database-size/2878/2 "2013-08-13T08:34:08Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![dim0](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/dim0/32/950_2.png) [@dim0](https://forums.percona.com/u/dim0)\
**Post date:** [August 14, 2013, 3:26am UTC](https://forums.percona.com/t/innobackupex-increase-database-size/2878/3 "2013-08-14T03:26:44Z")

</div>

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?
