GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

innobackupex increase database size

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • innobackupex increase database size

    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.

    Comment


    • #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?

      Comment

      Working...
      X