Percona-Xtrabackup 2.3.3 慢查詢不再堵塞備份（二）
在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:
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!
備份成功，不會堵塞！ 還原也會成功，還原部分就不寫了！
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:
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!
備份成功，不會堵塞！ 還原也會成功，還原部分就不寫了！
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/28939273/viewspace-1982019/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- Percona-Xtrabackup 2.3.3 慢查詢依舊堵塞MariaDB備份（三）
- RMAN備份進度查詢
- RMAN備份進度查詢：
- 查詢堵塞程式的幾種SQL--SQL
- MySQL 慢查詢MySql
- MySQL慢查詢MySql
- Redis 慢查詢Redis
- 使用閃回查詢備份資料
- mongodb慢查詢分析MongoDB
- mysqldumpslow慢查詢MySql
- MSSQL查詢收縮和備份進度SQL
- MySQL 慢查詢優化MySql優化
- SQL慢查詢排查思路SQL
- 詭異的”慢查詢“
- MongoDB慢查詢與索引MongoDB索引
- MySQL：慢查詢日誌MySql
- Mysql慢查詢操作梳理MySql
- MySQL開啟慢查詢MySql
- 使用慢查詢日誌
- mysql慢查詢日誌MySql
- 開啟查詢慢查詢日誌引數
- ElasticSearch 2.3.3 java API操作二ElasticsearchJavaAPI
- 斐波那契查詢不再迷惑
- MySQL 慢查詢那點事MySql
- 瑞士軍刀redis - 慢查詢Redis
- 詳解MySQL--慢查詢MySql
- 檢視慢查詢進度
- 慢查詢日誌的管理
- MySQL 清空慢查詢檔案MySql
- oracle 跨庫查詢greenplum慢Oracle
- MySQLslowquery[慢查詢]資料整理MySql
- RMAN備份恢復典型案例——RMAN備份&系統變慢
- 查詢——二分查詢
- MySQL 慢查詢日誌——讓“慢”無所遁形MySql
- 冷備份之一查詢引數檔案及備份引數檔案
- 使用 NineData 實現備份集的實時查詢
- RMAN筆記之查詢rman備份資訊狀態筆記
- Linux下mysql配置慢日誌查詢，把查詢慢的sql記錄下來LinuxMySql