[pdutta] ac4-devmysqldb-001 /home/y/var/mysql/backups $ sudo -u mysql /home/y/bin64/xtrabackup --backup --target-dir=/home/y
/var/mysql/backups
Password:
/home/y/bin64/xtrabackup version 1.6.5 for Percona Server 5.1.58 unknown-linux-gnu (x86_64) (revision id: undefined)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /home/y/var/mysql/data
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 = 5242880
120329 14:13:44 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
120329 14:13:44 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
xtrabackup: Something wrong with source files...
If I remove all of the --lose-options:
sed 's/^loose-//' /etc/my.cnf > /home/y/tmp/my.cnf
[pdutta] ac4-devmysqldb-001 /home/y/var/mysql/backups $ sudo -u mysql /home/y/bin64/xtrabackup --defaults-file=/home/y/tmp/m
y.cnf --backup --target-dir=/home/y/var/mysql/backups
Warning: /home/y/bin64/xtrabackup: ignoring option '--innodb_adaptive_hash_index' due to invalid value 'on'
/home/y/bin64/xtrabackup version 1.6.5 for Percona Server 5.1.58 unknown-linux-gnu (x86_64) (revision id: undefined)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /home/y/var/mysql/data
xtrabackup: Target instance is assumed as followings.
xtrabackup: innodb_data_home_dir = /home/y/var/mysql/ibdata
xtrabackup: innodb_data_file_path = ibdata1:256M:autoextend
xtrabackup: innodb_log_group_home_dir = /home/y/var/mysql/iblog
xtrabackup: innodb_log_files_in_group = 2
xtrabackup: innodb_log_file_size = 134217728
xtrabackup: use O_DIRECT
120329 14:21:00 InnoDB: Warning: allocated tablespace 10, old maximum was 9
[01] Copying /home/y/var/mysql/ibdata/ibdata1
to /home/y/var/mysql/backups/ibdata1
[01] ...done
[01] Copying ./foobar/foo1.ibd
to /home/y/var/mysql/backups/foobar/foo1.ibd
[01] ...done
xtrabackup: The latest check point (for incremental): '51979'
xtrabackup: Stopping log copying thread.
xtrabackup: Transaction log of lsn (51979) to (51979) was copied.
Sorry for delay, here is some evidence:
[pdutta] ac4-devmysqldb-001 /home/y/ var/mysql/ backups $ sudo -u mysql /home/y/ bin64/xtrabacku p --backup --target- dir=/home/ y bin64/xtrabacku p version 1.6.5 for Percona Server 5.1.58 unknown-linux-gnu (x86_64) (revision id: undefined) var/mysql/ data data_home_ dir = ./ data_file_ path = ibdata1: 10M:autoextend log_group_ home_dir = ./ log_files_ in_group = 2 log_file_ size = 5242880
/var/mysql/backups
Password:
/home/y/
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /home/y/
xtrabackup: Target instance is assumed as followings.
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
120329 14:13:44 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
120329 14:13:44 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
xtrabackup: Something wrong with source files...
and a grep of the /etc/my.cnf:
[pdutta] ac4-devmysqldb-001 /home/y/ var/mysql/ backups $ grep loose /etc/my.cnf use_sys_ malloc log_buffer_ size = 8M old_blocks_ pct = 37 mirrored_ log_groups = 1 max_dirty_ pages_pct = 90 rollback_ on_timeout = off read_ahead_ threshold = 56 locks_unsafe_ for_binlog file_per_ table additional_ mem_pool_ size = 8M stats_on_ metadata = on log_group_ home_dir = /home/y/ var/mysql/ iblog flush_log_ at_trx_ commit = 1 doublewrite thread_ concurrency = 0 stats_sample_ pages = 8 io_capacity = 200 table_locks = on thread_ sleep_delay = 10000 open_files = 300 autoinc_ lock_mode = 1 concurrency_ tickets = 500 file_format = Barracuda flush_method = O_DIRECT read_io_ threads = 4 old_blocks_ time = 0 data_file_ path = ibdata1: 256M:autoextend force_recovery = 0 sync_spin_ loops = 20 checksums stats_method = nulls_equal change_ buffering = inserts max_purge_ lag = 0 log_files_ in_group = 2 buffer_ pool_size = 128M lock_wait_ timeout = 50 commit_ concurrency = 0 data_home_ dir = /home/y/ var/mysql/ ibdata replication_ delay = 0 adaptive_ hash_index = on file_format_ check = on strict_ mode = off adaptive_ flushing support_ xa = on spin_wait_ delay = 6 write_io_ threads = 4 autoextend_ increment = 8 fast_shutdown = 1 log_file_ size = 128M flush_neighbor_ pages = 1 log_block_ size = 512 doublewrite_ file adaptive_ checkpoint = estimate extra_rsegments = 0 checkpoint_ age_target = 0 ibuf_active_ contract = 1 dict_size_ limit = 0 page_size read_ahead = linear stats_update_ need_lock = 1 ibuf_max_ size use_purge_ thread = 1 fast_checksum = 0 use_sys_ stats_table = 0 ibuf_accel_ rate = 100 extra_undoslots = 0 thread_ concurrency_ timer_based = 0
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
# loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
# loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
# loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
# loose-innodb_
loose-innodb_
loose-innodb_
# loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
loose-innodb_
If I remove all of the --lose-options: var/mysql/ backups $ sudo -u mysql /home/y/ bin64/xtrabacku p --defaults- file=/home/ y/tmp/m dir=/home/ y/var/mysql/ backups bin64/xtrabacku p: ignoring option '--innodb_ adaptive_ hash_index' due to invalid value 'on' bin64/xtrabacku p version 1.6.5 for Percona Server 5.1.58 unknown-linux-gnu (x86_64) (revision id: undefined) var/mysql/ data data_home_ dir = /home/y/ var/mysql/ ibdata data_file_ path = ibdata1: 256M:autoextend log_group_ home_dir = /home/y/ var/mysql/ iblog log_files_ in_group = 2 log_file_ size = 134217728 var/mysql/ ibdata/ ibdata1 var/mysql/ backups/ ibdata1 var/mysql/ backups/ foobar/ foo1.ibd
sed 's/^loose-//' /etc/my.cnf > /home/y/tmp/my.cnf
[pdutta] ac4-devmysqldb-001 /home/y/
y.cnf --backup --target-
Warning: /home/y/
/home/y/
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /home/y/
xtrabackup: Target instance is assumed as followings.
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: use O_DIRECT
120329 14:21:00 InnoDB: Warning: allocated tablespace 10, old maximum was 9
[01] Copying /home/y/
to /home/y/
[01] ...done
[01] Copying ./foobar/foo1.ibd
to /home/y/
[01] ...done
xtrabackup: The latest check point (for incremental): '51979'
xtrabackup: Stopping log copying thread.
xtrabackup: Transaction log of lsn (51979) to (51979) was copied.