innobackupex full compact log

gistfile1.txt

mysql@zin:/home/mysql/restore-test$ innobackupex --defaults-extra-file=../backup-scripts/my-backup.cnf --compact . 
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.

Get the latest version of Percona XtraBackup, documentation, and help resources:
http://www.percona.com/xb/p

150414 21:29:37  innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_file=../backup-scripts/my-backup.cnf;mysql_read_default_group=xtrabackup' (using password: NO).
150414 21:29:37  innobackupex: Connected to MySQL server
150414 21:29:37  innobackupex: Executing a version check against the server...
150414 21:29:37  innobackupex: Done.
150414 21:29:37  innobackupex: Starting the backup operation

IMPORTANT: Please check that the backup run completes successfully.
           At the end of a successful backup run innobackupex
           prints "completed OK!".

innobackupex:  Using server version 5.6.23-72.1-log

innobackupex: Created backup directory /home/mysql/restore-test/2015-04-14_21-29-37

150414 21:29:37  innobackupex: Starting ibbackup with command: xtrabackup  --defaults-extra-file="../backup-scripts/my-backup.cnf"  --defaults-group="mysqld" --backup --suspend-at-end --target-dir=/home/mysql/restore-test/2015-04-14_21-29-37 --innodb_data_file_path="ibdata1:12M:autoextend" --tmpdir=/tmp --extra-lsndir='/tmp' --compact
innobackupex: Waiting for ibbackup (pid=28852) to suspend
innobackupex: Suspend file '/home/mysql/restore-test/2015-04-14_21-29-37/xtrabackup_suspended_2'

xtrabackup version 2.2.10 based on MySQL server 5.6.22 Linux (x86_64) (revision id: )
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /var/lib/mysql/
xtrabackup: open files limit requested 65535, set to 1024
xtrabackup: using the following InnoDB configuration:
xtrabackup:   innodb_data_home_dir = ./
xtrabackup:   innodb_data_file_path = ibdata1:12M:autoextend
xtrabackup:   innodb_log_group_home_dir = ./
xtrabackup:   innodb_log_files_in_group = 2
xtrabackup:   innodb_log_file_size = 268435456
xtrabackup: using O_DIRECT
>> log scanned up to (38585877488)
xtrabackup: Generating a list of tablespaces
[01] Copying ./ibdata1 to /home/mysql/restore-test/2015-04-14_21-29-37/ibdata1
[01] xtrabackup: Page 64 is a doublewrite buffer page, skipping.
[01] xtrabackup: Page 70 is a doublewrite buffer page, skipping.
[01] xtrabackup: Page 73 is a doublewrite buffer page, skipping.
[01] xtrabackup: Page 74 is a doublewrite buffer page, skipping.
[01] xtrabackup: Page 76 is a doublewrite buffer page, skipping.
[01] xtrabackup: Page 77 is a doublewrite buffer page, skipping.
[01] xtrabackup: Page 81 is a doublewrite buffer page, skipping.
[01] xtrabackup: Page 89 is a doublewrite buffer page, skipping.
[01] xtrabackup: Page 93 is a doublewrite buffer page, skipping.
[01] xtrabackup: Page 103 is a doublewrite buffer page, skipping.
[01] xtrabackup: Page 104 is a doublewrite buffer page, skipping.
[01] xtrabackup: Page 107 is a doublewrite buffer page, skipping.
[01] xtrabackup: Page 108 is a doublewrite buffer page, skipping.
[01] xtrabackup: Page 129 is a doublewrite buffer page, skipping.
[01] xtrabackup: Page 132 is a doublewrite buffer page, skipping.
[01] xtrabackup: Page 135 is a doublewrite buffer page, skipping.
[01] xtrabackup: Page 155 is a doublewrite buffer page, skipping.
[01] xtrabackup: Page 156 is a doublewrite buffer page, skipping.
[01] xtrabackup: Page 168 is a doublewrite buffer page, skipping.
[01] xtrabackup: Page 181 is a doublewrite buffer page, skipping.
>> log scanned up to (38585878771)
[01]        ...done
[01] Copying ./gimlet_production/facets_sites.ibd to /home/mysql/restore-test/2015-04-14_21-29-37/gimlet_production/facets_sites.ibd
[01]        ...done
[01] Copying ./gimlet_production/roles.ibd to /home/mysql/restore-test/2015-04-14_21-29-37/gimlet_production/roles.ibd
[01]        ...done
[01] Copying ./gimlet_production/billing_types.ibd to /home/mysql/restore-test/2015-04-14_21-29-37/gimlet_production/billing_types.ibd
[01]        ...done
[01] Copying ./gimlet_production/accounts.ibd to /home/mysql/restore-test/2015-04-14_21-29-37/gimlet_production/accounts.ibd
[01]        ...done
[01] Copying ./gimlet_production/sites.ibd to /home/mysql/restore-test/2015-04-14_21-29-37/gimlet_production/sites.ibd
[01]        ...done
[01] Copying ./gimlet_production/payment_transactions.ibd to /home/mysql/restore-test/2015-04-14_21-29-37/gimlet_production/payment_transactions.ibd
[01]        ...done
[01] ./gimlet_production/questions.ibd is compressed with page size = 8192 bytes
[01] Copying ./gimlet_production/questions.ibd to /home/mysql/restore-test/2015-04-14_21-29-37/gimlet_production/questions.ibd
>> log scanned up to (38585878781)
>> log scanned up to (38585878781)
>> log scanned up to (38585878781)
>> log scanned up to (38585881444)
>> log scanned up to (38585881615)
>> log scanned up to (38585881715)
>> log scanned up to (38585881715)
>> log scanned up to (38585881715)
>> log scanned up to (38585881715)
[01]        ...done
[01] Copying ./gimlet_production/roles_users.ibd to /home/mysql/restore-test/2015-04-14_21-29-37/gimlet_production/roles_users.ibd
[01]        ...done
[01] Copying ./gimlet_production/taggings.ibd to /home/mysql/restore-test/2015-04-14_21-29-37/gimlet_production/taggings.ibd
>> log scanned up to (38585881715)
>> log scanned up to (38585881715)
>> log scanned up to (38585881715)
>> log scanned up to (38585881715)
[01]        ...done
[01] Copying ./gimlet_production/carnegie_sizes.ibd to /home/mysql/restore-test/2015-04-14_21-29-37/gimlet_production/carnegie_sizes.ibd
[01]        ...done
[01] Copying ./gimlet_production/invoices.ibd to /home/mysql/restore-test/2015-04-14_21-29-37/gimlet_production/invoices.ibd
[01]        ...done
[01] Copying ./gimlet_production/memberships.ibd to /home/mysql/restore-test/2015-04-14_21-29-37/gimlet_production/memberships.ibd
[01]        ...done
[01] Copying ./gimlet_production/users.ibd to /home/mysql/restore-test/2015-04-14_21-29-37/gimlet_production/users.ibd
[01]        ...done
[01] Copying ./gimlet_production/admin_notes.ibd to /home/mysql/restore-test/2015-04-14_21-29-37/gimlet_production/admin_notes.ibd
[01]        ...done
[01] Copying ./gimlet_production/carnegie_classes.ibd to /home/mysql/restore-test/2015-04-14_21-29-37/gimlet_production/carnegie_classes.ibd
[01]        ...done
[01] Copying ./gimlet_production/tags.ibd to /home/mysql/restore-test/2015-04-14_21-29-37/gimlet_production/tags.ibd
[01]        ...done
[01] Copying ./gimlet_production/remember_tokens.ibd to /home/mysql/restore-test/2015-04-14_21-29-37/gimlet_production/remember_tokens.ibd
>> log scanned up to (38585884810)
[01]        ...done
[01] Copying ./gimlet_production/payment_methods.ibd to /home/mysql/restore-test/2015-04-14_21-29-37/gimlet_production/payment_methods.ibd
[01]        ...done
[01] Copying ./gimlet_production/punchcard_facts.ibd to /home/mysql/restore-test/2015-04-14_21-29-37/gimlet_production/punchcard_facts.ibd
>> log scanned up to (38585885018)
>> log scanned up to (38585890094)
>> log scanned up to (38585890299)
>> log scanned up to (38585892366)
>> log scanned up to (38585892551)
>> log scanned up to (38585894336)
>> log scanned up to (38585894353)
>> log scanned up to (38585894353)
>> log scanned up to (38585896341)
>> log scanned up to (38585897718)
>> log scanned up to (38585897775)
>> log scanned up to (38585897775)
>> log scanned up to (38585897775)
>> log scanned up to (38585897775)
>> log scanned up to (38585897775)
>> log scanned up to (38585897775)
>> log scanned up to (38585897775)
>> log scanned up to (38585899810)
>> log scanned up to (38585899975)
>> log scanned up to (38585900081)
>> log scanned up to (38585900081)
>> log scanned up to (38585900081)
>> log scanned up to (38585900081)
>> log scanned up to (38585900081)
>> log scanned up to (38585900081)
>> log scanned up to (38585900081)
>> log scanned up to (38585900081)
>> log scanned up to (38585900081)
>> log scanned up to (38585900081)
>> log scanned up to (38585900081)
>> log scanned up to (38585901705)
>> log scanned up to (38585901815)
>> log scanned up to (38585901845)
>> log scanned up to (38585901845)
>> log scanned up to (38585901845)
>> log scanned up to (38585901845)
>> log scanned up to (38585901845)
>> log scanned up to (38585901845)
>> log scanned up to (38585901845)
>> log scanned up to (38585901845)
>> log scanned up to (38585901845)
>> log scanned up to (38585902304)
>> log scanned up to (38585902331)
[01]        ...done
[01] Copying ./gimlet_production/schema_migrations.ibd to /home/mysql/restore-test/2015-04-14_21-29-37/gimlet_production/schema_migrations.ibd
[01]        ...done
[01] Copying ./gimlet_production/facets.ibd to /home/mysql/restore-test/2015-04-14_21-29-37/gimlet_production/facets.ibd
[01]        ...done
[01] Copying ./gimlet_production/library_types.ibd to /home/mysql/restore-test/2015-04-14_21-29-37/gimlet_production/library_types.ibd
[01]        ...done
[01] Copying ./mysql/slave_worker_info.ibd to /home/mysql/restore-test/2015-04-14_21-29-37/mysql/slave_worker_info.ibd
[01]        ...done
[01] Copying ./mysql/innodb_table_stats.ibd to /home/mysql/restore-test/2015-04-14_21-29-37/mysql/innodb_table_stats.ibd
[01]        ...done
[01] Copying ./mysql/slave_master_info.ibd to /home/mysql/restore-test/2015-04-14_21-29-37/mysql/slave_master_info.ibd
[01]        ...done
[01] Copying ./mysql/innodb_index_stats.ibd to /home/mysql/restore-test/2015-04-14_21-29-37/mysql/innodb_index_stats.ibd
[01]        ...done
[01] Copying ./mysql/slave_relay_log_info.ibd to /home/mysql/restore-test/2015-04-14_21-29-37/mysql/slave_relay_log_info.ibd
[01]        ...done
>> log scanned up to (38585902331)
xtrabackup: Creating suspend file '/home/mysql/restore-test/2015-04-14_21-29-37/xtrabackup_suspended_2' with pid '28853'

150414 21:30:37  innobackupex: Continuing after ibbackup has suspended
150414 21:30:37  innobackupex: Executing LOCK TABLES FOR BACKUP...
150414 21:30:37  innobackupex: Backup tables lock acquired

150414 21:30:37  innobackupex: Starting to backup non-InnoDB tables and files
innobackupex: in subdirectories of '/var/lib/mysql/'
innobackupex: Backing up files '/var/lib/mysql//performance_schema/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (53 files)
>> log scanned up to (38585902331)
innobackupex: Backing up files '/var/lib/mysql//gimlet_production/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (25 files)
innobackupex: Backing up files '/var/lib/mysql//mysql/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (74 files)
150414 21:30:38  innobackupex: Finished backing up non-InnoDB tables and files

150414 21:30:38  innobackupex: Executing LOCK BINLOG FOR BACKUP...
150414 21:30:38  innobackupex: Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
150414 21:30:38  innobackupex: Waiting for log copying to finish

xtrabackup: The latest check point (for incremental): '38585902331'
xtrabackup: Stopping log copying thread.
.>> log scanned up to (38585902331)

xtrabackup: Creating suspend file '/home/mysql/restore-test/2015-04-14_21-29-37/xtrabackup_log_copied' with pid '28853'
xtrabackup: Transaction log of lsn (38585875238) to (38585902331) was copied.
150414 21:30:39  innobackupex: Executing UNLOCK BINLOG
150414 21:30:39  innobackupex: Executing UNLOCK TABLES
150414 21:30:39  innobackupex: All tables unlocked

innobackupex: Backup created in directory '/home/mysql/restore-test/2015-04-14_21-29-37'
innobackupex: MySQL binlog position: filename 'mysql-bin.000066', position 227829205
150414 21:30:39  innobackupex: Connection to database server closed
150414 21:30:39  innobackupex: completed OK!