MySQL Compressed Backup(四)
nnodb
mysqlbackup: INFO: Unique generated backup id for this is 13834930694674075
mysqlbackup: INFO: Uses posix_fadvise() for performance optimization.
mysqlbackup: INFO: Creating 18 buffers each of size 16794070.
131103 23:37:51 mysqlbackup: INFO: Compress Backup operation starts with following threads
1 read-threads 6 process-threads 1 write-threads
131103 23:37:51 mysqlbackup: INFO: System tablespace file format is Antelope.
131103 23:37:51 mysqlbackup: INFO: Starting to copy all innodb files...
131103 23:37:51 mysqlbackup: INFO: Copying /data/mysql5.5/ibdata1 (Antelope file format).
131103 23:37:51 mysqlbackup: INFO: Found checkpoint at lsn 3406075519.
131103 23:37:51 mysqlbackup: INFO: Starting log scan from lsn 3406075392.
131103 23:37:51 mysqlbackup: INFO: Copying log...
131103 23:37:51 mysqlbackup: INFO: Log copied, lsn 3406075519.
131103 23:37:51 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/_global_qs_variables.ibd (Antelope file format).
131103 23:37:51 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/_global_script_report_data.ibd (Antelope file format).
131103 23:37:51 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/_global_split_column_names_table.ibd (Antelope file format).
131103 23:37:51 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/_global_sql_tokens.ibd (Antelope file format).
131103 23:37:51 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/_known_thread_states.ibd (Antelope file format).
131103 23:37:51 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/_named_scripts.ibd (Antelope file format).
131103 23:37:51 mysqlbackup: INFO: Copyin
g /data/mysql5.5/common_schema/_script_statements.ibd (Antelope file format).
131103 23:37:51 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/_waits.ibd (Antelope file format).
131103 23:37:51 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/help_content.ibd (Antelope file format).
131103 23:37:51 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/metadata.ibd (Antelope file format).
131103 23:37:51 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/numbers.ibd (Antelope file format).
131103 23:37:51 mysqlbackup: INFO: Copying /data/mysql5.5/zwc/t2.ibd (Antelope file format).
mysqlbackup: Progress in MB: 200 400
131103 23:37:59 mysqlbackup: INFO: Completing the copy of innodb files.
131103 23:38:02 mysqlbackup: INFO: Preparing to lock tables: Connected to mysqld server.
131103 23:38:02 mysqlbackup: INFO: Starting to lock all the tables...
131103 23:38:02 mysqlbackup: INFO: All tables are locked and flushed to disk
131103 23:38:02 mysqlbackup: INFO: Opening backup source directory '/data/mysql5.5/'
131103 23:38:02 mysqlbackup: INFO: Starting to backup all non-innodb files in
subdirectories of '/data/mysql5.5/'
131103 23:38:02 mysqlbackup: INFO: Copying the database directory 'common_schema'
131103 23:38:02 mysqlbackup: INFO: Copying the database directory 'mysql'
131103 23:38:03 mysqlbackup: INFO: Copying the database directory 'performance_schema'
131103 23:38:03 mysqlbackup: INFO: Copying the database directory 'test'
131103 23:38:03 mysqlbackup: INFO: Copying the database directory 'zwc'
mysqlbackup: Progress in MB: 600 800
131103 23:38:14 mysqlbackup: INFO: Completing the copy of all n