# Innobackupex incremental backup size **URL:** https://forums.percona.com/t/innobackupex-incremental-backup-size/3425 **Category:** Percona XtraBackup **Created:** [April 25, 2014, 3:20am UTC](https://forums.percona.com/t/innobackupex-incremental-backup-size/3425 "2014-04-25T03:20:53Z") **Posts on this page:** 1 **Showing post:** 3
### Author: ![leserek](https://avatars.discourse-cdn.com/v4/letter/l/8491ac/32.png) [@leserek](https://forums.percona.com/u/leserek) #### Post date: [April 28, 2014, 4:27am UTC](https://forums.percona.com/t/innobackupex-incremental-backup-size/3425/3 "2014-04-28T04:27:18Z")
Hello, I’ve done the whole backup from the beginning according to your link. The effect is the same, xtrabackup\_checkpoints files are identical. Write data to the database all the time because, one of database it is a network monitor logs. Below the result of full and incremental backup: innobackupex --user=root /backup\_mysql/ InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved. This software is published under the GNU GENERAL PUBLIC LICENSE Version 2, June 1991. 140428 10:08:56 innobackupex: Starting mysql with options: --user=‘root’ --unbuffered – 140428 10:08:56 innobackupex: Connected to database with mysql child process (pid=9152) 140428 10:09:02 innobackupex: Connection to database server closed IMPORTANT: Please check that the backup run completes successfully. At the end of a successful backup run innobackupex prints “completed OK!”. innobackupex: Using mysql Ver 14.14 Distrib 5.1.69, for redhat-linux-gnu (x86\_64) using readline 5.1 innobackupex: Using mysql server version Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. innobackupex: Created backup directory /backup\_mysql/2014-04-28\_10-09-02 140428 10:09:02 innobackupex: Starting mysql with options: --user=‘root’ --unbuffered – 140428 10:09:02 innobackupex: Connected to database with mysql child process (pid=9175) 140428 10:09:04 innobackupex: Connection to database server closed 140428 10:09:04 innobackupex: Starting ibbackup with command: xtrabackup --defaults-group=“mysqld” --backup --suspend-at-end --target-dir=/backup\_mysql/2014-04-28\_10-09-02 --tmpdir=/cache innobackupex: Waiting for ibbackup (pid=9181) to suspend innobackupex: Suspend file ‘/backup\_mysql/2014-04-28\_10-09-02/xtrabackup\_suspended’ xtrabackup version 2.0.8 for Percona Server 5.1.59 unknown-linux-gnu (x86\_64) (revision id: 587) xtrabackup: uses posix\_fadvise(). xtrabackup: cd to /var/lib/mysql xtrabackup: Target instance is assumed as followings. xtrabackup: innodb\_data\_home\_dir = ./ xtrabackup: innodb\_data\_file\_path = ibdata1:10M:autoextend xtrabackup: innodb\_log\_group\_home\_dir = ./ xtrabackup: innodb\_log\_files\_in\_group = 2 xtrabackup: innodb\_log\_file\_size = 536870912 > > log scanned up to (44556) > > [01] Copying ./ibdata1 to /backup\_mysql/2014-04-28\_10-09-02/ibdata1 > > [01] …done > > log scanned up to (44556) > > xtrabackup: Creating suspend file ‘/backup\_mysql/2014-04-28\_10-09-02/xtrabackup\_suspended’ with pid ‘9181’ 140428 10:09:06 innobackupex: Continuing after ibbackup has suspended 140428 10:09:06 innobackupex: Starting mysql with options: --user=‘root’ --unbuffered – 140428 10:09:06 innobackupex: Connected to database with mysql child process (pid=9195) > > log scanned up to (44556) > > log scanned up to (44556) > > 140428 10:09:08 innobackupex: Starting to lock all tables… > > log scanned up to (44556) > > log scanned up to (44556) > > log scanned up to (44556) > > log scanned up to (44556) > > log scanned up to (44556) > > log scanned up to (44556) > > log scanned up to (44556) > > log scanned up to (44556) > > log scanned up to (44556) > > log scanned up to (44556) > > 140428 10:09:18 innobackupex: All tables locked and flushed to disk 140428 10:09:18 innobackupex: Starting to backup non-InnoDB tables and files innobackupex: in subdirectories of ‘/var/lib/mysql’ innobackupex: Backing up file ‘/var/lib/mysql/rsyslogdb/SystemEvents.frm’ innobackupex: Backing up file ‘/var/lib/mysql/rsyslogdb/SystemEvents.MYI’ > > log scanned up to (44556) > > log scanned up to (44556) > > log scanned up to (44556) > > innobackupex: Backing up file ‘/var/lib/mysql/rsyslogdb/SystemEventsProperties.MYD’ > > innobackupex: Backing up file ‘/var/lib/mysql/rsyslogdb/SystemEventsProperties.frm’ > > innobackupex: Backing up file ‘/var/lib/mysql/rsyslogdb/db.opt’ > > innobackupex: Backing up file ‘/var/lib/mysql/rsyslogdb/SystemEventsProperties.MYI’ > > innobackupex: Backing up file ‘/var/lib/mysql/rsyslogdb/SystemEvents.MYD’ > > log scanned up to (44556) > > log scanned up to (44556) > > log scanned up to (44556) > > log scanned up to (44556) > > log scanned up to (44556) > > log scanned up to (44556) > > log scanned up to (44556) > > log scanned up to (44556) > > log scanned up to (44556) > > log scanned up to (44556) > > log scanned up to (44556) > > log scanned up to (44556) > > log scanned up to (44556) > > log scanned up to (44556) > > log scanned up to (44556) > > log scanned up to (44556) > > log scanned up to (44556) > > log scanned up to (44556) > > log scanned up to (44556) > > innobackupex: Backing up files ‘/var/lib/mysql/postfix/_.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (40 files) > > innobackupex: Backing up files '/var/lib/mysql/radiusdb/_.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (28 files) > > innobackupex: Backing up files ‘/var/lib/mysql/phpbb\_optimist/_.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (193 files) > > log scanned up to (44556) > > innobackupex: Backing up files '/var/lib/mysql/mysql/_.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (69 files) > > innobackupex: Backing up files ‘/var/lib/mysql/wordpress/_.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (118 files) > > log scanned up to (44556) > > innobackupex: Backing up files '/var/lib/mysql/meganet\_new/_.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (82 files) > > innobackupex: Backing up files ‘/var/lib/mysql/meganet/_.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (82 files) > > log scanned up to (44556) > > innobackupex: Backing up files '/var/lib/mysql/bacula/_.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (76 files) > > log scanned up to (44556) > > innobackupex: Backing up file ‘/var/lib/mysql/bweb/db.opt’ > > innobackupex: Backing up files ‘/var/lib/mysql/redmine/_.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (145 files) > > innobackupex: Backing up files '/var/lib/mysql/loganalyzer/_.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (34 files) > > innobackupex: Backing up file ‘/var/lib/mysql/lego/db.opt’ > > innobackupex: Backing up files ‘/var/lib/mysql/zabbix/_.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (325 files) > > log scanned up to (44556) > > log scanned up to (44556) > > log scanned up to (44556) > > log scanned up to (44556) > > log scanned up to (44556) > > log scanned up to (44556) > > innobackupex: Backing up files '/var/lib/mysql/roundcube\_flux/_.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (49 files) > > innobackupex: Backing up files ‘/var/lib/mysql/mailscanner/_.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (43 files) > > log scanned up to (44556) > > log scanned up to (44556) > > log scanned up to (44556) > > log scanned up to (44556) > > log scanned up to (44556) > > log scanned up to (44556) > > log scanned up to (44556) > > log scanned up to (44556) > > innobackupex: Backing up files '/var/lib/mysql/ipplan/_.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (76 files) > > log scanned up to (44556) > > 140428 10:11:28 innobackupex: Finished backing up non-InnoDB tables and files 140428 10:11:28 innobackupex: Waiting for log copying to finish xtrabackup: The latest check point (for incremental): ‘44556’ xtrabackup: Stopping log copying thread. …\>\> log scanned up to (44556) xtrabackup: Creating suspend file ‘/backup\_mysql/2014-04-28\_10-09-02/xtrabackup\_suspended’ with pid ‘9181’ xtrabackup: Transaction log of lsn (44556) to (44556) was copied. 140428 10:11:32 innobackupex: All tables unlocked 140428 10:11:32 innobackupex: Waiting for ibbackup (pid=9181) to finish 140428 10:11:32 innobackupex: Connection to database server closed innobackupex: Backup created in directory ‘/backup\_mysql/2014-04-28\_10-09-02’ innobackupex: MySQL binlog position: filename ‘’, position 140428 10:11:32 innobackupex: completed OK! --- _[View the full topic](https://forums.percona.com/t/innobackupex-incremental-backup-size/3425)._