在percona-xtrabackup2.1.9下备份:

session one:
root(yoon)> show tables;
+----------------+
| Tables_in_yoon |
+----------------+
| yoon           |
+----------------+
1 row in set (0.01 sec)

root(yoon)> select count(*) from yoon;
+----------+
| count(*) |
+----------+
|  6553600 |
+----------+
1 row in set (1.10 sec)

root(yoon)> lock tables yoon read;
Query OK, 0 rows affected (0.11 sec)

root(yoon)> select * from yoon;

session two:
[root@hank-yoon backup]# innobackupex --compress --parallel=4 --defaults-file=/export/servers/mysql/etc/my.cnf  --user=root --password=yoon /export/backup/

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

160125 15:38:16  innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_file=/export/servers/mysql/etc/my.cnf;mysql_read_default_group=xtrabackup' as 'root'  (using password: YES).
160125 15:38:16  innobackupex: Connected to MySQL server
160125 15:38:16  innobackupex: Executing a version check against the server...
160125 15:38:16  innobackupex: Done.
IMPORTANT: Please check that the backup run completes successfully.
           At the end of a successful backup run innobackupex
           prints "completed OK!".

innobackupex: Using mysql server version 5.6.26-log

innobackupex: Created backup directory /export/backup/2016-01-25_15-38-16

160125 15:38:16  innobackupex: Starting ibbackup with command: xtrabackup_56  --defaults-file="/export/servers/mysql/etc/my.cnf"  --defaults-group="mysqld" --backup --suspend-at-end --target-dir=/export/backup/2016-01-25_15-38-16 --tmpdir=/export/data/mysql/tmp --compress --compress-threads=1 --parallel=4
innobackupex: Waiting for ibbackup (pid=8711) to suspend
innobackupex: Suspend file '/export/backup/2016-01-25_15-38-16/xtrabackup_suspended_2'

xtrabackup_56 version 2.1.9 for MySQL server 5.6.17 Linux (x86_64) (revision id: 744)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /export/data/mysql/data/
xtrabackup: open files limit requested 65535, set to 65535
xtrabackup: using the following InnoDB configuration:
xtrabackup:   innodb_data_home_dir = /export/data/mysql/data
xtrabackup:   innodb_data_file_path = ibdata1:2G;ibdata2:2G:autoextend
xtrabackup:   innodb_log_group_home_dir = /export/data/mysql/data
xtrabackup:   innodb_log_files_in_group = 3
xtrabackup:   innodb_log_file_size = 536870912
2016-01-25 15:38:16 7f3f18929720 InnoDB: Using Linux native AIO
xtrabackup: using O_DIRECT
>> log scanned up to (11131323714)
InnoDB: Opened 4 undo tablespaces
xtrabackup: Starting 4 threads for parallel data files transfer
[02] Compressing /export/data/mysql/data/ibdata1 to /export/backup/2016-01-25_15-38-16/ibdata1.qp
[03] Compressing /export/data/mysql/data/ibdata2 to /export/backup/2016-01-25_15-38-16/ibdata2.qp
[04] Compressing /export/data/mysql/undo/undo001 to /export/backup/2016-01-25_15-38-16/undo001.qp
[01] Compressing /export/data/mysql/undo/undo002 to /export/backup/2016-01-25_15-38-16/undo002.qp
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
[01]        ...done
>> log scanned up to (11131323714)
[01] Compressing /export/data/mysql/undo/undo003 to /export/backup/2016-01-25_15-38-16/undo003.qp
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
[02]        ...done
[02] Compressing /export/data/mysql/undo/undo004 to /export/backup/2016-01-25_15-38-16/undo004.qp
[03]        ...done
[03] Compressing ./sakila/inventory.ibd to /export/backup/2016-01-25_15-38-16/sakila/inventory.ibd.qp
[03]        ...done
>> log scanned up to (11131323714)
[03] Compressing ./sakila/actor.ibd to /export/backup/2016-01-25_15-38-16/sakila/actor.ibd.qp
[03]        ...done
[02]        ...done
>> log scanned up to (11131323714)
[03] Compressing ./sakila/country.ibd to /export/backup/2016-01-25_15-38-16/sakila/country.ibd.qp
[03]        ...done
[02] Compressing ./sakila/film_actor.ibd to /export/backup/2016-01-25_15-38-16/sakila/film_actor.ibd.qp
[02]        ...done
>> log scanned up to (11131323714)
[02] Compressing ./sakila/city.ibd to /export/backup/2016-01-25_15-38-16/sakila/city.ibd.qp
[03] Compressing ./sakila/film.ibd to /export/backup/2016-01-25_15-38-16/sakila/film.ibd.qp
[02]        ...done
[03]        ...done
[03] Compressing ./sakila/language.ibd to /export/backup/2016-01-25_15-38-16/sakila/language.ibd.qp
[03]        ...done
[02] Compressing ./sakila/customer.ibd to /export/backup/2016-01-25_15-38-16/sakila/customer.ibd.qp
[02]        ...done
>> log scanned up to (11131323714)
[02] Compressing ./sakila/film_category.ibd to /export/backup/2016-01-25_15-38-16/sakila/film_category.ibd.qp
[03] Compressing ./sakila/store.ibd to /export/backup/2016-01-25_15-38-16/sakila/store.ibd.qp
[02]        ...done
[03]        ...done
[03] Compressing ./sakila/staff.ibd to /export/backup/2016-01-25_15-38-16/sakila/staff.ibd.qp
[03]        ...done
[02] Compressing ./sakila/category.ibd to /export/backup/2016-01-25_15-38-16/sakila/category.ibd.qp
[02]        ...done
[02] Compressing ./sakila/payment.ibd to /export/backup/2016-01-25_15-38-16/sakila/payment.ibd.qp
[03] Compressing ./sakila/rental.ibd to /export/backup/2016-01-25_15-38-16/sakila/rental.ibd.qp
>> log scanned up to (11131323714)
[03]        ...done
[02]        ...done
[02] Compressing ./sakila/address.ibd to /export/backup/2016-01-25_15-38-16/sakila/address.ibd.qp
[03] Compressing ./mysql/innodb_table_stats.ibd to /export/backup/2016-01-25_15-38-16/mysql/innodb_table_stats.ibd.qp
[02]        ...done
[03]        ...done
>> log scanned up to (11131323714)
[01]        ...done
[03] Compressing ./mysql/slave_worker_info.ibd to /export/backup/2016-01-25_15-38-16/mysql/slave_worker_info.ibd.qp
[03]        ...done
[02] Compressing ./mysql/slave_master_info.ibd to /export/backup/2016-01-25_15-38-16/mysql/slave_master_info.ibd.qp
[02]        ...done
[01] Compressing ./mysql/innodb_index_stats.ibd to /export/backup/2016-01-25_15-38-16/mysql/innodb_index_stats.ibd.qp
[01]        ...done
[02] Compressing ./mysql/slave_relay_log_info.ibd to /export/backup/2016-01-25_15-38-16/mysql/slave_relay_log_info.ibd.qp
[02]        ...done
[03] Compressing ./test/innodb_lock_monitor.ibd to /export/backup/2016-01-25_15-38-16/test/innodb_lock_monitor.ibd.qp
[03]        ...done
[01] Compressing ./yoon/yoon.ibd to /export/backup/2016-01-25_15-38-16/yoon/yoon.ibd.qp
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
[04]        ...done
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
[01]        ...done
>> log scanned up to (11131323714)
xtrabackup: Creating suspend file '/export/backup/2016-01-25_15-38-16/xtrabackup_suspended_2' with pid '8711'

160125 15:38:49  innobackupex: Continuing after ibbackup has suspended
160125 15:38:49  innobackupex: Starting to lock all tables...
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
>> log scanned up to (11131323714)
在给所有表加锁的时候,会一直堵塞等待!

在percona-xtrabackup2.3.3下备份:

session one:
mysql> show tables;
+----------------+
| Tables_in_yoon |
+----------------+
| yoon           |
+----------------+
1 row in set (0.00 sec)

mysql> select count(*) from yoon;
+----------+
| count(*) |
+----------+
|  6553600 |
+----------+
1 row in set (1.08 sec)

mysql> lock tables yoon read;
Query OK, 0 rows affected (0.00 sec)

mysql> select * from yoon;

session two:
[root@b28-19-27 bak]# innobackupex --compress --parallel=4 --user=root --password=yoon /my/bak/
160125 15:41:28 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!".

160125 15:41:28  version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;port=3306;mysql_socket=/my/log/mysql.sock' as 'root'  (using password: YES).
160125 15:41:28  version_check Connected to MySQL server
160125 15:41:28  version_check Executing a version check against the server...
160125 15:41:28  version_check Done.
160125 15:41:28 Connecting to MySQL server host: localhost, user: root, password: set, port: 3306, socket: /my/log/mysql.sock
Using server version 5.6.16-64.0-56-log
innobackupex version 2.3.3 based on MySQL server 5.6.24 Linux (x86_64) (revision id: 525ca7d)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /my/data
xtrabackup: open files limit requested 0, set to 65535
xtrabackup: using the following InnoDB configuration:
xtrabackup:   innodb_data_home_dir = /my/log
xtrabackup:   innodb_data_file_path = ibdata1:256M:autoextend
xtrabackup:   innodb_log_group_home_dir = /my/log
xtrabackup:   innodb_log_files_in_group = 2
xtrabackup:   innodb_log_file_size = 536870912
2016-01-25 15:41:28 7f7078c3b720 InnoDB: Using Linux native AIO
xtrabackup: using O_DIRECT
160125 15:41:28 >> log scanned up to (681360803)
xtrabackup: Generating a list of tablespaces
xtrabackup: Starting 4 threads for parallel data files transfer
160125 15:41:28 [02] Compressing ./yoon/yoon.ibd to /my/bak//2016-01-25_15-41-28/yoon/yoon.ibd.qp
160125 15:41:28 [01] Compressing /my/log/ibdata1 to /my/bak//2016-01-25_15-41-28/ibdata1.qp
160125 15:41:28 [04] Compressing ./mysql/slave_worker_info.ibd to /my/bak//2016-01-25_15-41-28/mysql/slave_worker_info.ibd.qp
160125 15:41:28 [03] Compressing ./mysql/innodb_index_stats.ibd to /my/bak//2016-01-25_15-41-28/mysql/innodb_index_stats.ibd.qp
160125 15:41:28 [04]        ...done
160125 15:41:28 [03]        ...done
160125 15:41:28 [04] Compressing ./mysql/innodb_table_stats.ibd to /my/bak//2016-01-25_15-41-28/mysql/innodb_table_stats.ibd.qp
160125 15:41:28 [04]        ...done
160125 15:41:28 [03] Compressing ./mysql/slave_relay_log_info.ibd to /my/bak//2016-01-25_15-41-28/mysql/slave_relay_log_info.ibd.qp
160125 15:41:28 [03]        ...done
160125 15:41:28 [04] Compressing ./mysql/slave_master_info.ibd to /my/bak//2016-01-25_15-41-28/mysql/slave_master_info.ibd.qp
160125 15:41:28 [04]        ...done
160125 15:41:28 [03] Compressing ./sakila/rental.ibd to /my/bak//2016-01-25_15-41-28/sakila/rental.ibd.qp
160125 15:41:28 [04] Compressing ./sakila/actor.ibd to /my/bak//2016-01-25_15-41-28/sakila/actor.ibd.qp
160125 15:41:28 [04]        ...done
160125 15:41:28 [04] Compressing ./sakila/payment.ibd to /my/bak//2016-01-25_15-41-28/sakila/payment.ibd.qp
160125 15:41:28 [03]        ...done
160125 15:41:28 [03] Compressing ./sakila/country.ibd to /my/bak//2016-01-25_15-41-28/sakila/country.ibd.qp
160125 15:41:28 [03]        ...done
160125 15:41:28 [03] Compressing ./sakila/film_actor.ibd to /my/bak//2016-01-25_15-41-28/sakila/film_actor.ibd.qp
160125 15:41:28 [04]        ...done
160125 15:41:28 [04] Compressing ./sakila/language.ibd to /my/bak//2016-01-25_15-41-28/sakila/language.ibd.qp
160125 15:41:28 [03]        ...done
160125 15:41:28 [03] Compressing ./sakila/category.ibd to /my/bak//2016-01-25_15-41-28/sakila/category.ibd.qp
160125 15:41:28 [03]        ...done
160125 15:41:28 [03] Compressing ./sakila/city.ibd to /my/bak//2016-01-25_15-41-28/sakila/city.ibd.qp
160125 15:41:28 [04]        ...done
160125 15:41:28 [04] Compressing ./sakila/store.ibd to /my/bak//2016-01-25_15-41-28/sakila/store.ibd.qp
160125 15:41:29 [04]        ...done
160125 15:41:29 [03]        ...done
160125 15:41:29 [03] Compressing ./sakila/film.ibd to /my/bak//2016-01-25_15-41-28/sakila/film.ibd.qp
160125 15:41:29 [04] Compressing ./sakila/staff.ibd to /my/bak//2016-01-25_15-41-28/sakila/staff.ibd.qp
160125 15:41:29 [03]        ...done
160125 15:41:29 [04]        ...done
160125 15:41:29 [04] Compressing ./sakila/address.ibd to /my/bak//2016-01-25_15-41-28/sakila/address.ibd.qp
160125 15:41:29 [03] Compressing ./sakila/film_category.ibd to /my/bak//2016-01-25_15-41-28/sakila/film_category.ibd.qp
160125 15:41:29 [04]        ...done
160125 15:41:29 [03]        ...done
160125 15:41:29 [03] Compressing ./sakila/inventory.ibd to /my/bak//2016-01-25_15-41-28/sakila/inventory.ibd.qp
160125 15:41:29 [04] Compressing ./sakila/customer.ibd to /my/bak//2016-01-25_15-41-28/sakila/customer.ibd.qp
160125 15:41:29 [03]        ...done
160125 15:41:29 [04]        ...done
160125 15:41:29 >> log scanned up to (681360803)
160125 15:41:30 [01]        ...done
160125 15:41:30 >> log scanned up to (681360803)
160125 15:41:31 >> log scanned up to (681360803)
160125 15:41:31 [02]        ...done
160125 15:41:32 >> log scanned up to (681360803)
160125 15:41:32 Executing LOCK TABLES FOR BACKUP...
160125 15:41:32 Starting to backup non-InnoDB tables and files
160125 15:41:32 [01] Compressing ./yoon/db.opt to /my/bak//2016-01-25_15-41-28/yoon/db.opt.qp
160125 15:41:32 [01]        ...done
160125 15:41:32 [01] Compressing ./yoon/yoon.frm to /my/bak//2016-01-25_15-41-28/yoon/yoon.frm.qp
160125 15:41:32 [01]        ...done
160125 15:41:32 [01] Compressing ./test/db.opt to /my/bak//2016-01-25_15-41-28/test/db.opt.qp
160125 15:41:32 [01]        ...done
160125 15:41:32 [01] Compressing ./mysql/servers.MYI to /my/bak//2016-01-25_15-41-28/mysql/servers.MYI.qp
160125 15:41:32 [01]        ...done
160125 15:41:32 [01] Compressing ./mysql/user.frm to /my/bak//2016-01-25_15-41-28/mysql/user.frm.qp
160125 15:41:32 [01]        ...done
160125 15:41:32 [01] Compressing ./mysql/time_zone_transition_type.MYI to /my/bak//2016-01-25_15-41-28/mysql/time_zone_transition_type.MYI.qp
160125 15:41:32 [01]        ...done
160125 15:41:32 [01] Compressing ./mysql/time_zone_name.MYI to /my/bak//2016-01-25_15-41-28/mysql/time_zone_name.MYI.qp
160125 15:41:32 [01]        ...done
160125 15:41:32 [01] Compressing ./mysql/proxies_priv.frm to /my/bak//2016-01-25_15-41-28/mysql/proxies_priv.frm.qp
160125 15:41:32 [01]        ...done
160125 15:41:32 [01] Compressing ./mysql/plugin.frm to /my/bak//2016-01-25_15-41-28/mysql/plugin.frm.qp
160125 15:41:32 [01]        ...done
160125 15:41:32 [01] Compressing ./mysql/help_relation.MYD to /my/bak//2016-01-25_15-41-28/mysql/help_relation.MYD.qp
160125 15:41:32 [01]        ...done
160125 15:41:32 [01] Compressing ./mysql/event.frm to /my/bak//2016-01-25_15-41-28/mysql/event.frm.qp
160125 15:41:32 [01]        ...done
160125 15:41:32 [01] Compressing ./mysql/procs_priv.MYI to /my/bak//2016-01-25_15-41-28/mysql/procs_priv.MYI.qp
160125 15:41:32 [01]        ...done
160125 15:41:32 [01] Compressing ./mysql/time_zone.MYI to /my/bak//2016-01-25_15-41-28/mysql/time_zone.MYI.qp
160125 15:41:32 [01]        ...done
160125 15:41:32 [01] Compressing ./mysql/slave_worker_info.frm to /my/bak//2016-01-25_15-41-28/mysql/slave_worker_info.frm.qp
160125 15:41:32 [01]        ...done
160125 15:41:32 [01] Compressing ./mysql/tables_priv.MYD to /my/bak//2016-01-25_15-41-28/mysql/tables_priv.MYD.qp
160125 15:41:32 [01]        ...done
160125 15:41:32 [01] Compressing ./mysql/general_log.CSV to /my/bak//2016-01-25_15-41-28/mysql/general_log.CSV.qp
160125 15:41:32 [01]        ...done
160125 15:41:32 [01] Compressing ./mysql/time_zone_transition.MYD to /my/bak//2016-01-25_15-41-28/mysql/time_zone_transition.MYD.qp
160125 15:41:32 [01]        ...done
160125 15:41:32 [01] Compressing ./mysql/plugin.MYD to /my/bak//2016-01-25_15-41-28/mysql/plugin.MYD.qp
160125 15:41:32 [01]        ...done
160125 15:41:32 [01] Compressing ./mysql/user.MYD to /my/bak//2016-01-25_15-41-28/mysql/user.MYD.qp
160125 15:41:32 [01]        ...done
160125 15:41:32 [01] Compressing ./mysql/db.frm to /my/bak//2016-01-25_15-41-28/mysql/db.frm.qp
160125 15:41:32 [01]        ...done
160125 15:41:32 [01] Compressing ./mysql/proc.MYD to /my/bak//2016-01-25_15-41-28/mysql/proc.MYD.qp
160125 15:41:32 [01]        ...done
160125 15:41:32 [01] Compressing ./mysql/slow_log.frm to /my/bak//2016-01-25_15-41-28/mysql/slow_log.frm.qp
160125 15:41:32 [01]        ...done
160125 15:41:32 [01] Compressing ./mysql/innodb_index_stats.frm to /my/bak//2016-01-25_15-41-28/mysql/innodb_index_stats.frm.qp
160125 15:41:32 [01]        ...done
160125 15:41:32 [01] Compressing ./mysql/help_keyword.frm to /my/bak//2016-01-25_15-41-28/mysql/help_keyword.frm.qp
160125 15:41:32 [01]        ...done
160125 15:41:32 [01] Compressing ./mysql/ndb_binlog_index.MYI to /my/bak//2016-01-25_15-41-28/mysql/ndb_binlog_index.MYI.qp
160125 15:41:32 [01]        ...done
160125 15:41:32 [01] Compressing ./mysql/user.MYI to /my/bak//2016-01-25_15-41-28/mysql/user.MYI.qp
160125 15:41:32 [01]        ...done
160125 15:41:32 [01] Compressing ./mysql/slow_log.CSV to /my/bak//2016-01-25_15-41-28/mysql/slow_log.CSV.qp
160125 15:41:32 [01]        ...done
160125 15:41:32 [01] Compressing ./mysql/proxies_priv.MYI to /my/bak//2016-01-25_15-41-28/mysql/proxies_priv.MYI.qp
160125 15:41:32 [01]        ...done
160125 15:41:32 [01] Compressing ./mysql/proc.frm to /my/bak//2016-01-25_15-41-28/mysql/proc.frm.qp
160125 15:41:32 [01]        ...done
160125 15:41:32 [01] Compressing ./mysql/db.MYI to /my/bak//2016-01-25_15-41-28/mysql/db.MYI.qp
160125 15:41:32 [01]        ...done
160125 15:41:32 [01] Compressing ./mysql/procs_priv.MYD to /my/bak//2016-01-25_15-41-28/mysql/procs_priv.MYD.qp
160125 15:41:32 [01]        ...done
160125 15:41:32 [01] Compressing ./mysql/procs_priv.frm to /my/bak//2016-01-25_15-41-28/mysql/procs_priv.frm.qp
160125 15:41:32 [01]        ...done
160125 15:41:32 [01] Compressing ./mysql/ndb_binlog_index.frm to /my/bak//2016-01-25_15-41-28/mysql/ndb_binlog_index.frm.qp
160125 15:41:32 [01]        ...done
160125 15:41:32 [01] Compressing ./mysql/help_keyword.MYI to /my/bak//2016-01-25_15-41-28/mysql/help_keyword.MYI.qp
160125 15:41:32 [01]        ...done
160125 15:41:32 [01] Compressing ./mysql/servers.MYD to /my/bak//2016-01-25_15-41-28/mysql/servers.MYD.qp
160125 15:41:32 [01]        ...done
160125 15:41:32 [01] Compressing ./mysql/general_log.frm to /my/bak//2016-01-25_15-41-28/mysql/general_log.frm.qp
160125 15:41:32 [01]        ...done
160125 15:41:32 [01] Compressing ./mysql/time_zone_leap_second.MYI to /my/bak//2016-01-25_15-41-28/mysql/time_zone_leap_second.MYI.qp
160125 15:41:32 [01]        ...done
160125 15:41:32 [01] Compressing ./mysql/columns_priv.frm to /my/bak//2016-01-25_15-41-28/mysql/columns_priv.frm.qp
160125 15:41:32 [01]        ...done
160125 15:41:32 [01] Compressing ./mysql/event.MYI to /my/bak//2016-01-25_15-41-28/mysql/event.MYI.qp
160125 15:41:32 [01]        ...done
160125 15:41:32 [01] Compressing ./mysql/plugin.MYI to /my/bak//2016-01-25_15-41-28/mysql/plugin.MYI.qp
160125 15:41:32 [01]        ...done
160125 15:41:33 [01] Compressing ./mysql/columns_priv.MYD to /my/bak//2016-01-25_15-41-28/mysql/columns_priv.MYD.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./mysql/db.MYD to /my/bak//2016-01-25_15-41-28/mysql/db.MYD.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./mysql/help_relation.MYI to /my/bak//2016-01-25_15-41-28/mysql/help_relation.MYI.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./mysql/general_log.CSM to /my/bak//2016-01-25_15-41-28/mysql/general_log.CSM.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./mysql/help_topic.MYI to /my/bak//2016-01-25_15-41-28/mysql/help_topic.MYI.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./mysql/ndb_binlog_index.MYD to /my/bak//2016-01-25_15-41-28/mysql/ndb_binlog_index.MYD.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./mysql/time_zone_transition.MYI to /my/bak//2016-01-25_15-41-28/mysql/time_zone_transition.MYI.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./mysql/help_keyword.MYD to /my/bak//2016-01-25_15-41-28/mysql/help_keyword.MYD.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./mysql/help_relation.frm to /my/bak//2016-01-25_15-41-28/mysql/help_relation.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./mysql/func.frm to /my/bak//2016-01-25_15-41-28/mysql/func.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./mysql/time_zone_transition_type.frm to /my/bak//2016-01-25_15-41-28/mysql/time_zone_transition_type.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./mysql/columns_priv.MYI to /my/bak//2016-01-25_15-41-28/mysql/columns_priv.MYI.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./mysql/time_zone_transition.frm to /my/bak//2016-01-25_15-41-28/mysql/time_zone_transition.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./mysql/slow_log.CSM to /my/bak//2016-01-25_15-41-28/mysql/slow_log.CSM.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./mysql/help_topic.frm to /my/bak//2016-01-25_15-41-28/mysql/help_topic.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./mysql/help_category.MYD to /my/bak//2016-01-25_15-41-28/mysql/help_category.MYD.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./mysql/time_zone_name.MYD to /my/bak//2016-01-25_15-41-28/mysql/time_zone_name.MYD.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./mysql/time_zone.MYD to /my/bak//2016-01-25_15-41-28/mysql/time_zone.MYD.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./mysql/event.MYD to /my/bak//2016-01-25_15-41-28/mysql/event.MYD.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./mysql/func.MYI to /my/bak//2016-01-25_15-41-28/mysql/func.MYI.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./mysql/proxies_priv.MYD to /my/bak//2016-01-25_15-41-28/mysql/proxies_priv.MYD.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./mysql/slave_master_info.frm to /my/bak//2016-01-25_15-41-28/mysql/slave_master_info.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./mysql/time_zone_transition_type.MYD to /my/bak//2016-01-25_15-41-28/mysql/time_zone_transition_type.MYD.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./mysql/innodb_table_stats.frm to /my/bak//2016-01-25_15-41-28/mysql/innodb_table_stats.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./mysql/slave_relay_log_info.frm to /my/bak//2016-01-25_15-41-28/mysql/slave_relay_log_info.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./mysql/tables_priv.MYI to /my/bak//2016-01-25_15-41-28/mysql/tables_priv.MYI.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./mysql/func.MYD to /my/bak//2016-01-25_15-41-28/mysql/func.MYD.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./mysql/proc.MYI to /my/bak//2016-01-25_15-41-28/mysql/proc.MYI.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./mysql/help_category.frm to /my/bak//2016-01-25_15-41-28/mysql/help_category.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./mysql/time_zone_name.frm to /my/bak//2016-01-25_15-41-28/mysql/time_zone_name.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./mysql/help_topic.MYD to /my/bak//2016-01-25_15-41-28/mysql/help_topic.MYD.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./mysql/time_zone_leap_second.frm to /my/bak//2016-01-25_15-41-28/mysql/time_zone_leap_second.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./mysql/servers.frm to /my/bak//2016-01-25_15-41-28/mysql/servers.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./mysql/time_zone_leap_second.MYD to /my/bak//2016-01-25_15-41-28/mysql/time_zone_leap_second.MYD.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./mysql/time_zone.frm to /my/bak//2016-01-25_15-41-28/mysql/time_zone.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./mysql/tables_priv.frm to /my/bak//2016-01-25_15-41-28/mysql/tables_priv.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./mysql/help_category.MYI to /my/bak//2016-01-25_15-41-28/mysql/help_category.MYI.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/events_statements_summary_by_digest.frm to /my/bak//2016-01-25_15-41-28/performance_schema/events_statements_summary_by_digest.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/session_account_connect_attrs.frm to /my/bak//2016-01-25_15-41-28/performance_schema/session_account_connect_attrs.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/db.opt to /my/bak//2016-01-25_15-41-28/performance_schema/db.opt.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/users.frm to /my/bak//2016-01-25_15-41-28/performance_schema/users.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/events_waits_summary_by_instance.frm to /my/bak//2016-01-25_15-41-28/performance_schema/events_waits_summary_by_instance.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/setup_instruments.frm to /my/bak//2016-01-25_15-41-28/performance_schema/setup_instruments.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/events_waits_history_long.frm to /my/bak//2016-01-25_15-41-28/performance_schema/events_waits_history_long.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/events_stages_history.frm to /my/bak//2016-01-25_15-41-28/performance_schema/events_stages_history.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/session_connect_attrs.frm to /my/bak//2016-01-25_15-41-28/performance_schema/session_connect_attrs.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/file_instances.frm to /my/bak//2016-01-25_15-41-28/performance_schema/file_instances.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/events_statements_summary_by_account_by_event_name.frm to /my/bak//2016-01-25_15-41-28/performance_schema/events_statements_summary_by_account_by_event_name.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/rwlock_instances.frm to /my/bak//2016-01-25_15-41-28/performance_schema/rwlock_instances.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/events_stages_summary_global_by_event_name.frm to /my/bak//2016-01-25_15-41-28/performance_schema/events_stages_summary_global_by_event_name.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/events_stages_summary_by_thread_by_event_name.frm to /my/bak//2016-01-25_15-41-28/performance_schema/events_stages_summary_by_thread_by_event_name.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/socket_instances.frm to /my/bak//2016-01-25_15-41-28/performance_schema/socket_instances.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/events_statements_history_long.frm to /my/bak//2016-01-25_15-41-28/performance_schema/events_statements_history_long.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 >> log scanned up to (681360803)
160125 15:41:33 [01] Compressing ./performance_schema/events_waits_current.frm to /my/bak//2016-01-25_15-41-28/performance_schema/events_waits_current.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/setup_actors.frm to /my/bak//2016-01-25_15-41-28/performance_schema/setup_actors.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/events_waits_summary_by_thread_by_event_name.frm to /my/bak//2016-01-25_15-41-28/performance_schema/events_waits_summary_by_thread_by_event_name.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/file_summary_by_instance.frm to /my/bak//2016-01-25_15-41-28/performance_schema/file_summary_by_instance.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/events_statements_history.frm to /my/bak//2016-01-25_15-41-28/performance_schema/events_statements_history.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/events_statements_summary_global_by_event_name.frm to /my/bak//2016-01-25_15-41-28/performance_schema/events_statements_summary_global_by_event_name.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/events_waits_summary_by_account_by_event_name.frm to /my/bak//2016-01-25_15-41-28/performance_schema/events_waits_summary_by_account_by_event_name.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/accounts.frm to /my/bak//2016-01-25_15-41-28/performance_schema/accounts.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/table_io_waits_summary_by_index_usage.frm to /my/bak//2016-01-25_15-41-28/performance_schema/table_io_waits_summary_by_index_usage.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/threads.frm to /my/bak//2016-01-25_15-41-28/performance_schema/threads.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/socket_summary_by_event_name.frm to /my/bak//2016-01-25_15-41-28/performance_schema/socket_summary_by_event_name.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/table_io_waits_summary_by_table.frm to /my/bak//2016-01-25_15-41-28/performance_schema/table_io_waits_summary_by_table.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/setup_timers.frm to /my/bak//2016-01-25_15-41-28/performance_schema/setup_timers.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/events_stages_history_long.frm to /my/bak//2016-01-25_15-41-28/performance_schema/events_stages_history_long.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/socket_summary_by_instance.frm to /my/bak//2016-01-25_15-41-28/performance_schema/socket_summary_by_instance.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/host_cache.frm to /my/bak//2016-01-25_15-41-28/performance_schema/host_cache.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/events_statements_current.frm to /my/bak//2016-01-25_15-41-28/performance_schema/events_statements_current.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/mutex_instances.frm to /my/bak//2016-01-25_15-41-28/performance_schema/mutex_instances.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/file_summary_by_event_name.frm to /my/bak//2016-01-25_15-41-28/performance_schema/file_summary_by_event_name.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/events_waits_summary_by_user_by_event_name.frm to /my/bak//2016-01-25_15-41-28/performance_schema/events_waits_summary_by_user_by_event_name.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/events_waits_history.frm to /my/bak//2016-01-25_15-41-28/performance_schema/events_waits_history.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/setup_consumers.frm to /my/bak//2016-01-25_15-41-28/performance_schema/setup_consumers.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/events_waits_summary_global_by_event_name.frm to /my/bak//2016-01-25_15-41-28/performance_schema/events_waits_summary_global_by_event_name.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/events_statements_summary_by_thread_by_event_name.frm to /my/bak//2016-01-25_15-41-28/performance_schema/events_statements_summary_by_thread_by_event_name.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/table_lock_waits_summary_by_table.frm to /my/bak//2016-01-25_15-41-28/performance_schema/table_lock_waits_summary_by_table.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/events_stages_summary_by_account_by_event_name.frm to /my/bak//2016-01-25_15-41-28/performance_schema/events_stages_summary_by_account_by_event_name.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/events_waits_summary_by_host_by_event_name.frm to /my/bak//2016-01-25_15-41-28/performance_schema/events_waits_summary_by_host_by_event_name.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/events_stages_summary_by_host_by_event_name.frm to /my/bak//2016-01-25_15-41-28/performance_schema/events_stages_summary_by_host_by_event_name.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/events_statements_summary_by_host_by_event_name.frm to /my/bak//2016-01-25_15-41-28/performance_schema/events_statements_summary_by_host_by_event_name.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/events_stages_current.frm to /my/bak//2016-01-25_15-41-28/performance_schema/events_stages_current.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/events_stages_summary_by_user_by_event_name.frm to /my/bak//2016-01-25_15-41-28/performance_schema/events_stages_summary_by_user_by_event_name.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/events_statements_summary_by_user_by_event_name.frm to /my/bak//2016-01-25_15-41-28/performance_schema/events_statements_summary_by_user_by_event_name.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/performance_timers.frm to /my/bak//2016-01-25_15-41-28/performance_schema/performance_timers.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/hosts.frm to /my/bak//2016-01-25_15-41-28/performance_schema/hosts.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/cond_instances.frm to /my/bak//2016-01-25_15-41-28/performance_schema/cond_instances.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/setup_objects.frm to /my/bak//2016-01-25_15-41-28/performance_schema/setup_objects.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./performance_schema/objects_summary_global_by_type.frm to /my/bak//2016-01-25_15-41-28/performance_schema/objects_summary_global_by_type.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./sakila/payment_date.TRN to /my/bak//2016-01-25_15-41-28/sakila/payment_date.TRN.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./sakila/film_list.frm to /my/bak//2016-01-25_15-41-28/sakila/film_list.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./sakila/rental.TRG to /my/bak//2016-01-25_15-41-28/sakila/rental.TRG.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./sakila/db.opt to /my/bak//2016-01-25_15-41-28/sakila/db.opt.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./sakila/language.frm to /my/bak//2016-01-25_15-41-28/sakila/language.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./sakila/film.frm to /my/bak//2016-01-25_15-41-28/sakila/film.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./sakila/actor_info.frm to /my/bak//2016-01-25_15-41-28/sakila/actor_info.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./sakila/address.frm to /my/bak//2016-01-25_15-41-28/sakila/address.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./sakila/film_text.frm to /my/bak//2016-01-25_15-41-28/sakila/film_text.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./sakila/film.TRG to /my/bak//2016-01-25_15-41-28/sakila/film.TRG.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./sakila/actor.frm to /my/bak//2016-01-25_15-41-28/sakila/actor.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./sakila/sales_by_film_category.frm to /my/bak//2016-01-25_15-41-28/sakila/sales_by_film_category.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./sakila/category.frm to /my/bak//2016-01-25_15-41-28/sakila/category.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./sakila/rental.frm to /my/bak//2016-01-25_15-41-28/sakila/rental.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./sakila/country.frm to /my/bak//2016-01-25_15-41-28/sakila/country.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./sakila/customer_create_date.TRN to /my/bak//2016-01-25_15-41-28/sakila/customer_create_date.TRN.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./sakila/payment.TRG to /my/bak//2016-01-25_15-41-28/sakila/payment.TRG.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./sakila/ins_film.TRN to /my/bak//2016-01-25_15-41-28/sakila/ins_film.TRN.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./sakila/film_text.MYD to /my/bak//2016-01-25_15-41-28/sakila/film_text.MYD.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./sakila/city.frm to /my/bak//2016-01-25_15-41-28/sakila/city.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./sakila/payment.frm to /my/bak//2016-01-25_15-41-28/sakila/payment.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./sakila/film_category.frm to /my/bak//2016-01-25_15-41-28/sakila/film_category.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./sakila/upd_film.TRN to /my/bak//2016-01-25_15-41-28/sakila/upd_film.TRN.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./sakila/customer.TRG to /my/bak//2016-01-25_15-41-28/sakila/customer.TRG.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./sakila/film_text.MYI to /my/bak//2016-01-25_15-41-28/sakila/film_text.MYI.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./sakila/store.frm to /my/bak//2016-01-25_15-41-28/sakila/store.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./sakila/staff.frm to /my/bak//2016-01-25_15-41-28/sakila/staff.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./sakila/customer.frm to /my/bak//2016-01-25_15-41-28/sakila/customer.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./sakila/customer_list.frm to /my/bak//2016-01-25_15-41-28/sakila/customer_list.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./sakila/rental_date.TRN to /my/bak//2016-01-25_15-41-28/sakila/rental_date.TRN.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./sakila/film_actor.frm to /my/bak//2016-01-25_15-41-28/sakila/film_actor.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:33 [01] Compressing ./sakila/staff_list.frm to /my/bak//2016-01-25_15-41-28/sakila/staff_list.frm.qp
160125 15:41:33 [01]        ...done
160125 15:41:34 [01] Compressing ./sakila/nicer_but_slower_film_list.frm to /my/bak//2016-01-25_15-41-28/sakila/nicer_but_slower_film_list.frm.qp
160125 15:41:34 [01]        ...done
160125 15:41:34 [01] Compressing ./sakila/inventory.frm to /my/bak//2016-01-25_15-41-28/sakila/inventory.frm.qp
160125 15:41:34 [01]        ...done
160125 15:41:34 [01] Compressing ./sakila/del_film.TRN to /my/bak//2016-01-25_15-41-28/sakila/del_film.TRN.qp
160125 15:41:34 [01]        ...done
160125 15:41:34 [01] Compressing ./sakila/sales_by_store.frm to /my/bak//2016-01-25_15-41-28/sakila/sales_by_store.frm.qp
160125 15:41:34 [01]        ...done
160125 15:41:34 Finished backing up non-InnoDB tables and files
160125 15:41:34 Executing LOCK BINLOG FOR BACKUP...
160125 15:41:34 [00] Compressing xtrabackup_binlog_info
160125 15:41:34 [00]        ...done
160125 15:41:34 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
xtrabackup: The latest check point (for incremental): '681360803'
xtrabackup: Stopping log copying thread.
.160125 15:41:34 >> log scanned up to (681360803)

160125 15:41:34 Executing UNLOCK BINLOG
160125 15:41:34 Executing UNLOCK TABLES
160125 15:41:34 All tables unlocked
160125 15:41:34 Backup created in directory '/my/bak//2016-01-25_15-41-28'
MySQL binlog position: filename 'mysql-bin.000001', position '148214741'
160125 15:41:34 [00] Compressing backup-my.cnf
160125 15:41:34 [00]        ...done
160125 15:41:34 [00] Compressing xtrabackup_info
160125 15:41:34 [00]        ...done
xtrabackup: Transaction log of lsn (681360803) to (681360803) was copied.
160125 15:41:34 completed OK!

备份成功,不会堵塞!     还原也会成功,还原部分就不写了!

最新文章

  1. 【js】初入AJAX
  2. Dynamics AX 2012 R2 AIF 内部异常
  3. 删除Android包
  4. socket.io简单说明及在线抽奖demo
  5. 学习一下《JavaEE开发的颠覆者 Spring Boot实战 》
  6. Python一行代码
  7. js作用域学习
  8. 在Linux上安装Oracle RAC 12 c(12.1) 虚拟机,一步一步向导
  9. HDU 1069&&HDU 1087 (DP 最长序列之和)
  10. < IOS > 论苹果数据持久化。
  11. zend framework virtualhost设置方法
  12. mysql 锁表查询及其处理
  13. UVA10341-Solve It-二分查找
  14. WOJ 124. Football Coach 网络流
  15. mac配置go使用gopm下载第三方包
  16. powerdesigner 16.5 不允许有扩展属性,或对象不存在
  17. Django Http请求生命周期
  18. java日期格式转换工具类
  19. [WEB地图] 2017高德地图API WEB开发(key申请,地图搭建)简约教程
  20. Django admin 忘记密码

热门文章

  1. 集合函数AVG,SUM,MAX,MIN
  2. ctags 文章
  3. javascript各种兼容性问题,不断更新
  4. 学习总结 java 创建及其练习
  5. typedef 与define 的区别
  6. SQL server 时间处理自连接
  7. XSS测试语句大全
  8. Android 中断线程的处理
  9. nginx负载均衡配置一(反向代理)
  10. 将Application按钮从任务栏中去掉