GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

backup size

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

  • backup size

    When I run "innobackupex --slave-info --safe-slave-backup --user=user --password=password /backupdir/", the backup is ~140gb which is about the size of my dataset. When I prep the backup with "innobackupex --apply-log /backupdir/timestamp", the backup grows to 250gb.

    I thought this was due to new data being written to the slave, so I even tried to stop the slave replication to make sure no new data is submitted before running innobackupex, and the size still grows.

    Here's my version:
    innobackupex -version
    InnoDB Backup Utility v1.5.1-xtrabackup;

    My mysql version is 5.5.27

    As a test, I've restored the backup to a test server, and my dataset is now 250gb. Running mysqlcheck optimize brings it back down to 140gb.

  • #2
    Not sure if it helps, but I'm running percona-xtrabackup-2.0.0.

    Comment


    • #3
      I've installed the latest xtrabackup 2.0.3, and it's the same result. Any help will be appreciated.

      Comment


      • #4
        Nothing is been in this latest xtrabackup 2.0.3...any other can anyone suggest!!

        Comment

        Working...
        X