MySQL Compressed Backup(三)
reads
1 read-threads 1 process-threads
131103 23:34:46 mysqlbackup: INFO: ibbackup_logfile's creation parameters:
start lsn 3406070784, end lsn 3406074168,
start checkpoint 3406071002.
mysqlbackup: INFO: InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 Setting log file size to 536870912
InnoDB: Progress in MB: 100 200 300 400 500
Setting log file size to 536870912
InnoDB: Progress in MB: 100 200 300 400 500
Setting log file size to 536870912
InnoDB: Progress in MB: 100 200 300 400 500
131103 23:35:08 mysqlbackup: INFO: We were able to parse ibbackup_logfile up to
lsn 3406074168.
mysqlbackup: INFO: Last MySQL binlog file position 0 11153, file name ./ZWC-TEST.000015
131103 23:35:08 mysqlbackup: INFO: The first data file is '/backup/meb_normal/datadir/ibdata1'
and the new created log files are at '/backup/meb_normal/datadir'
131103 23:35:08 mysqlbackup: INFO: Apply-log operation completed successfully.
131103 23:35:08 mysqlbackup: INFO: Full backup prepared for recovery successfully.
mysqlbackup completed OK!
real 0m54.611s
user 0m1.119s
sys 0m3.415s
[root@test backup]#
[root@test backup]#
[root@test backup]# du -sh /backup/meb_normal
2.5G /backup/meb_normal
compressed backup
[root@test backup]# time /service/mysql5.5/bin/mysqlbackup --user=root --backup-dir=/backup/meb_compressed --compress --socket=/data/mysql5.5/mysql.sock --password backup
MySQL Enterprise Backup version 3.8.2 [2013/06/18]
Copyright (c) 2003, 2012, Oracle and/or its affiliates. All Rights Reserved.
mysqlbackup: INFO: Starting with following command line ...
/service/mysql5.5/bin/mysqlbackup --user=root
--backup-dir=/backup/meb_compressed --compress
--socket=/data/mysql5.5/mysql.sock --password backup
Enter password:
mysqlbackup: INFO: MySQL server version is '5.5.25-log'.
mysqlbackup: INFO: Got some server configuration information from running server.
mysqlbackup: INFO: MySQL server version is '5.5.25-log'.
mysqlbackup: INFO: Got some server configuration information from running server.
IMPORTANT: Please check that mysqlbackup run completes successfully.
At the end of a successful 'backup' run mysqlbackup
prints "mysqlbackup completed OK!".
prints "mysqlbackup completed OK!".
--------------------------------------------------------------------
Server Repository Options:
--------------------------------------------------------------------
datadir = /data/mysql5.5/
innodb_data_home_dir =
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /data/mysql5.5/
innodb_log_files_in_group = 3
innodb_log_file_size = 536870912
innodb_page_size = Null
innodb_checksum_algorithm = innodb
--------------------------------------------------------------------
Backup Config Options:
--------------------------------------------------------------------
datadir = /backup/meb_compressed/datadir
innodb_data_home_dir = /backup/meb_compressed/datadir
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /backup/meb_compressed/datadir
innodb_log_files_in_group = 3
innodb_log_file_size = 536870912
innodb_page_size = 16384
innodb_checksum_algorithm = i