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

innobackupex increase database size

tdelnattetdelnatte EntrantCurrent User Role Beginner
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

Comments

  • tdelnattetdelnatte Entrant Current User Role Beginner
    I just find out ibdata1 cannot be fragmented. So I have absolutely no idea why my database keep growing after each backup.
  • dim0dim0 Percona Percona Staff Role
    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?
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.