pcrcona-xtrbackup备份,附带备份脚本最佳实践-亲试ok-20210114

 
replication  client   用以获取binlog file 和 position 
replication  slave   用以获取当前的 slave host
 
#创建备份用户
mysql> create user xtrabackup@'127.0.0.1' identified by '123456';
Query OK, 0 rows affected (0.01 sec)
mysql> grant reload,lock tables,replication client,create tablespace,process,super on *.* to xtrabackup@'127.0.0.1' ;
Query OK, 0 rows affected (0.00 sec)
mysql> grant create,insert,select on percona_schema.* to xtrabackup@'127.0.0.1' ;
Query OK, 0 rows affected (0.00 sec)
 
#执行备份操作,常规方式
[root@MHA-Master-201 bin]# innobackupex --defaults-file=/etc/my.cnf --host=127.0.0.1 --port=3306 --user=xtrabackup --password=123456 --no-lock --use-memory=1G /mysql-backup/full
210113 20:57:06 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!".
210113 20:57:06  version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;host=127.0.0.1;port=3306' as 'xtrabackup'  (using password: YES).
210113 20:57:06  version_check Connected to MySQL server
210113 20:57:06  version_check Executing a version check against the server...
210113 20:57:06  version_check Done.
210113 20:57:06 Connecting to MySQL server host: 127.0.0.1, user: xtrabackup, password: set, port: 3306, socket: not set
Using server version 5.7.26-log
innobackupex version 2.4.7 based on MySQL server 5.7.13 Linux (x86_64) (revision id: 05f1fcf)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /data/my3306/data/
xtrabackup: open files limit requested 65535, set to 65535
xtrabackup: using the following InnoDB configuration:
xtrabackup:   innodb_data_home_dir = /data/my3306/log/iblog
xtrabackup:   innodb_data_file_path = ibdata1:12M:autoextend
xtrabackup:   innodb_log_group_home_dir = /data/my3306/log/iblog
xtrabackup:   innodb_log_files_in_group = 2
xtrabackup:   innodb_log_file_size = 268435456
xtrabackup: using O_DIRECT
InnoDB: Number of pools: 1
210113 20:57:06 >> log scanned up to (2377883047)
xtrabackup: Generating a list of tablespaces
InnoDB: Allocated tablespace ID 2 for mysql/plugin, old maximum was 0
210113 20:57:07 >> log scanned up to (2377883047)
210113 20:57:08 [01] Copying /data/my3306/log/iblog/ibdata1 to /mysql-backup/3306/2021-01-13_20-57-06/ibdata1
210113 20:57:08 >> log scanned up to (2377883047)
210113 20:57:09 >> log scanned up to (2377883047)
210113 20:57:10 [01]        ...done
210113 20:57:10 [01] Copying ./mysql/plugin.ibd to /mysql-backup/3306/2021-01-13_20-57-06/mysql/plugin.ibd
210113 20:57:10 >> log scanned up to (2377883047)
210113 20:57:10 [01]        ...done
210113 20:57:10 [01] Copying ./mysql/servers.ibd to /mysql-backup/3306/2021-01-13_20-57-06/mysql/servers.ibd
210113 20:57:10 [01]        ...done
210113 20:57:10 [01] Copying ./mysql/help_topic.ibd to /mysql-backup/3306/2021-01-13_20-57-06/mysql/help_topic.ibd
210113 20:57:10 [01]        ...done
210113 20:57:10 [01] Copying ./mysql/help_category.ibd to /mysql-backup/3306/2021-01-13_20-57-06/mysql/help_category.ibd
210113 20:57:10 [01]        ...done
210113 20:57:10 [01] Copying ./mysql/help_relation.ibd to /mysql-backup/3306/2021-01-13_20-57-06/mysql/help_relation.ibd
210113 20:57:10 [01]        ...done
210113 20:57:10 [01] Copying ./mysql/help_keyword.ibd to /mysql-backup/3306/2021-01-13_20-57-06/mysql/help_keyword.ibd
210113 20:57:10 [01]        ...done
210113 20:57:10 [01] Copying ./mysql/time_zone_name.ibd to /mysql-backup/3306/2021-01-13_20-57-06/mysql/time_zone_name.ibd
210113 20:57:10 [01]        ...done
210113 20:57:10 [01] Copying ./mysql/time_zone.ibd to /mysql-backup/3306/2021-01-13_20-57-06/mysql/time_zone.ibd
210113 20:57:11 [01]        ...done
210113 20:57:11 [01] Copying ./mysql/time_zone_transition.ibd to /mysql-backup/3306/2021-01-13_20-57-06/mysql/time_zone_transition.ibd
210113 20:57:11 [01]        ...done
210113 20:57:11 [01] Copying ./mysql/time_zone_transition_type.ibd to /mysql-backup/3306/2021-01-13_20-57-06/mysql/time_zone_transition_type.ibd
210113 20:57:11 [01]        ...done
210113 20:57:11 [01] Copying ./mysql/time_zone_leap_second.ibd to /mysql-backup/3306/2021-01-13_20-57-06/mysql/time_zone_leap_second.ibd
210113 20:57:11 [01]        ...done
210113 20:57:11 [01] Copying ./mysql/innodb_table_stats.ibd to /mysql-backup/3306/2021-01-13_20-57-06/mysql/innodb_table_stats.ibd
210113 20:57:11 [01]        ...done
210113 20:57:11 [01] Copying ./mysql/innodb_index_stats.ibd to /mysql-backup/3306/2021-01-13_20-57-06/mysql/innodb_index_stats.ibd
210113 20:57:11 [01]        ...done
210113 20:57:11 [01] Copying ./mysql/slave_relay_log_info.ibd to /mysql-backup/3306/2021-01-13_20-57-06/mysql/slave_relay_log_info.ibd
210113 20:57:11 [01]        ...done
210113 20:57:11 [01] Copying ./mysql/slave_master_info.ibd to /mysql-backup/3306/2021-01-13_20-57-06/mysql/slave_master_info.ibd
210113 20:57:11 [01]        ...done
210113 20:57:11 [01] Copying ./mysql/slave_worker_info.ibd to /mysql-backup/3306/2021-01-13_20-57-06/mysql/slave_worker_info.ibd
210113 20:57:11 [01]        ...done
210113 20:57:11 [01] Copying ./mysql/gtid_executed.ibd to /mysql-backup/3306/2021-01-13_20-57-06/mysql/gtid_executed.ibd
210113 20:57:11 [01]        ...done
210113 20:57:11 [01] Copying ./mysql/server_cost.ibd to /mysql-backup/3306/2021-01-13_20-57-06/mysql/server_cost.ibd
210113 20:57:11 [01]        ...done
210113 20:57:11 [01] Copying ./mysql/engine_cost.ibd to /mysql-backup/3306/2021-01-13_20-57-06/mysql/engine_cost.ibd
210113 20:57:11 [01]        ...done
210113 20:57:11 [01] Copying ./sys/sys_config.ibd to /mysql-backup/3306/2021-01-13_20-57-06/sys/sys_config.ibd
210113 20:57:11 [01]        ...done
210113 20:57:11 [01] Copying ./customer_db/product_brand_info.ibd to /mysql-backup/3306/2021-01-13_20-57-06/customer_db/product_brand_info.ibd
210113 20:57:11 [01]        ...done
210113 20:57:11 [01] Copying ./customer_db/product_category.ibd to /mysql-backup/3306/2021-01-13_20-57-06/customer_db/product_category.ibd
210113 20:57:11 [01]        ...done
210113 20:57:11 [01] Copying ./customer_db/product_comment.ibd to /mysql-backup/3306/2021-01-13_20-57-06/customer_db/product_comment.ibd
210113 20:57:11 [01]        ...done
210113 20:57:11 [01] Copying ./customer_db/product_info.ibd to /mysql-backup/3306/2021-01-13_20-57-06/customer_db/product_info.ibd
210113 20:57:11 >> log scanned up to (2377883047)
210113 20:57:12 [01]        ...done
210113 20:57:12 [01] Copying ./customer_db/product_pic_info.ibd to /mysql-backup/3306/2021-01-13_20-57-06/customer_db/product_pic_info.ibd
210113 20:57:12 [01]        ...done
210113 20:57:12 [01] Copying ./customer_db/product_supplier_info.ibd to /mysql-backup/3306/2021-01-13_20-57-06/customer_db/product_supplier_info.ibd
210113 20:57:12 [01]        ...done
210113 20:57:12 [01] Copying ./customer_db/serial.ibd to /mysql-backup/3306/2021-01-13_20-57-06/customer_db/serial.ibd
210113 20:57:12 [01]        ...done
210113 20:57:12 [01] Copying ./customer_db/customer_balance_log.ibd to /mysql-backup/3306/2021-01-13_20-57-06/customer_db/customer_balance_log.ibd
210113 20:57:12 [01]        ...done
210113 20:57:12 [01] Copying ./customer_db/customer_inf.ibd to /mysql-backup/3306/2021-01-13_20-57-06/customer_db/customer_inf.ibd
210113 20:57:12 [01]        ...done
210113 20:57:12 [01] Copying ./customer_db/customer_login.ibd to /mysql-backup/3306/2021-01-13_20-57-06/customer_db/customer_login.ibd
210113 20:57:12 [01]        ...done
210113 20:57:12 >> log scanned up to (2377883047)
210113 20:57:12 [01] Copying ./customer_db/customer_login_log.ibd to /mysql-backup/3306/2021-01-13_20-57-06/customer_db/customer_login_log.ibd
210113 20:57:12 [01]        ...done
210113 20:57:12 [01] Copying ./customer_db/customer_point_log.ibd to /mysql-backup/3306/2021-01-13_20-57-06/customer_db/customer_point_log.ibd
210113 20:57:12 [01]        ...done
210113 20:57:12 [01] Copying ./customer_db/order_cart.ibd to /mysql-backup/3306/2021-01-13_20-57-06/customer_db/order_cart.ibd
210113 20:57:12 [01]        ...done
210113 20:57:12 [01] Copying ./customer_db/order_customer_addr.ibd to /mysql-backup/3306/2021-01-13_20-57-06/customer_db/order_customer_addr.ibd
210113 20:57:12 [01]        ...done
210113 20:57:12 [01] Copying ./customer_db/order_detail.ibd to /mysql-backup/3306/2021-01-13_20-57-06/customer_db/order_detail.ibd
210113 20:57:12 [01]        ...done
210113 20:57:12 [01] Copying ./customer_db/order_master.ibd to /mysql-backup/3306/2021-01-13_20-57-06/customer_db/order_master.ibd
210113 20:57:13 [01]        ...done
210113 20:57:13 [01] Copying ./customer_db/region_info.ibd to /mysql-backup/3306/2021-01-13_20-57-06/customer_db/region_info.ibd
210113 20:57:13 [01]        ...done
210113 20:57:13 [01] Copying ./customer_db/shipping_info.ibd to /mysql-backup/3306/2021-01-13_20-57-06/customer_db/shipping_info.ibd
210113 20:57:13 [01]        ...done
210113 20:57:13 [01] Copying ./customer_db/warehouse_info.ibd to /mysql-backup/3306/2021-01-13_20-57-06/customer_db/warehouse_info.ibd
210113 20:57:13 [01]        ...done
210113 20:57:13 [01] Copying ./customer_db/warehouse_proudct.ibd to /mysql-backup/3306/2021-01-13_20-57-06/customer_db/warehouse_proudct.ibd
210113 20:57:13 [01]        ...done
210113 20:57:13 [01] Copying ./test/test_order.ibd to /mysql-backup/3306/2021-01-13_20-57-06/test/test_order.ibd
210113 20:57:13 [01]        ...done
210113 20:57:13 [01] Copying ./test/test_orderdetail.ibd to /mysql-backup/3306/2021-01-13_20-57-06/test/test_orderdetail.ibd
210113 20:57:13 [01]        ...done
210113 20:57:13 [01] Copying ./test/checksums.ibd to /mysql-backup/3306/2021-01-13_20-57-06/test/checksums.ibd
210113 20:57:13 [01]        ...done
210113 20:57:13 >> log scanned up to (2377883047)
210113 20:57:13 [01] Copying ./sakila/actor.ibd to /mysql-backup/3306/2021-01-13_20-57-06/sakila/actor.ibd
210113 20:57:13 [01]        ...done
210113 20:57:13 [01] Copying ./sakila/address.ibd to /mysql-backup/3306/2021-01-13_20-57-06/sakila/address.ibd
210113 20:57:13 [01]        ...done
210113 20:57:13 [01] Copying ./sakila/category.ibd to /mysql-backup/3306/2021-01-13_20-57-06/sakila/category.ibd
210113 20:57:13 [01]        ...done
210113 20:57:13 [01] Copying ./sakila/city.ibd to /mysql-backup/3306/2021-01-13_20-57-06/sakila/city.ibd
210113 20:57:13 [01]        ...done
210113 20:57:13 [01] Copying ./sakila/country.ibd to /mysql-backup/3306/2021-01-13_20-57-06/sakila/country.ibd
210113 20:57:13 [01]        ...done
210113 20:57:13 [01] Copying ./sakila/customer.ibd to /mysql-backup/3306/2021-01-13_20-57-06/sakila/customer.ibd
210113 20:57:13 [01]        ...done
210113 20:57:13 [01] Copying ./sakila/film.ibd to /mysql-backup/3306/2021-01-13_20-57-06/sakila/film.ibd
210113 20:57:13 [01]        ...done
210113 20:57:13 [01] Copying ./sakila/film_actor.ibd to /mysql-backup/3306/2021-01-13_20-57-06/sakila/film_actor.ibd
210113 20:57:13 [01]        ...done
210113 20:57:13 [01] Copying ./sakila/film_category.ibd to /mysql-backup/3306/2021-01-13_20-57-06/sakila/film_category.ibd
210113 20:57:13 [01]        ...done
210113 20:57:13 [01] Copying ./sakila/film_text.ibd to /mysql-backup/3306/2021-01-13_20-57-06/sakila/film_text.ibd
210113 20:57:13 [01]        ...done
210113 20:57:13 [01] Copying ./sakila/FTS_000000000000006e_BEING_DELETED.ibd to /mysql-backup/3306/2021-01-13_20-57-06/sakila/FTS_000000000000006e_BEING_DELETED.ibd
210113 20:57:13 [01]        ...done
210113 20:57:13 [01] Copying ./sakila/FTS_000000000000006e_BEING_DELETED_CACHE.ibd to /mysql-backup/3306/2021-01-13_20-57-06/sakila/FTS_000000000000006e_BEING_DELETED_CACHE.ibd
210113 20:57:13 [01]        ...done
210113 20:57:13 [01] Copying ./sakila/FTS_000000000000006e_CONFIG.ibd to /mysql-backup/3306/2021-01-13_20-57-06/sakila/FTS_000000000000006e_CONFIG.ibd
210113 20:57:13 [01]        ...done
210113 20:57:13 [01] Copying ./sakila/FTS_000000000000006e_DELETED.ibd to /mysql-backup/3306/2021-01-13_20-57-06/sakila/FTS_000000000000006e_DELETED.ibd
210113 20:57:13 [01]        ...done
210113 20:57:13 [01] Copying ./sakila/FTS_000000000000006e_DELETED_CACHE.ibd to /mysql-backup/3306/2021-01-13_20-57-06/sakila/FTS_000000000000006e_DELETED_CACHE.ibd
210113 20:57:13 [01]        ...done
210113 20:57:13 [01] Copying ./sakila/FTS_000000000000006e_0000000000000084_INDEX_1.ibd to /mysql-backup/3306/2021-01-13_20-57-06/sakila/FTS_000000000000006e_0000000000000084_INDEX_1.ibd
210113 20:57:13 [01]        ...done
210113 20:57:13 [01] Copying ./sakila/FTS_000000000000006e_0000000000000084_INDEX_2.ibd to /mysql-backup/3306/2021-01-13_20-57-06/sakila/FTS_000000000000006e_0000000000000084_INDEX_2.ibd
210113 20:57:13 [01]        ...done
210113 20:57:13 [01] Copying ./sakila/FTS_000000000000006e_0000000000000084_INDEX_3.ibd to /mysql-backup/3306/2021-01-13_20-57-06/sakila/FTS_000000000000006e_0000000000000084_INDEX_3.ibd
210113 20:57:13 [01]        ...done
210113 20:57:13 [01] Copying ./sakila/FTS_000000000000006e_0000000000000084_INDEX_4.ibd to /mysql-backup/3306/2021-01-13_20-57-06/sakila/FTS_000000000000006e_0000000000000084_INDEX_4.ibd
210113 20:57:13 [01]        ...done
210113 20:57:13 [01] Copying ./sakila/FTS_000000000000006e_0000000000000084_INDEX_5.ibd to /mysql-backup/3306/2021-01-13_20-57-06/sakila/FTS_000000000000006e_0000000000000084_INDEX_5.ibd
210113 20:57:13 [01]        ...done
210113 20:57:13 [01] Copying ./sakila/FTS_000000000000006e_0000000000000084_INDEX_6.ibd to /mysql-backup/3306/2021-01-13_20-57-06/sakila/FTS_000000000000006e_0000000000000084_INDEX_6.ibd
210113 20:57:13 [01]        ...done
210113 20:57:13 [01] Copying ./sakila/inventory.ibd to /mysql-backup/3306/2021-01-13_20-57-06/sakila/inventory.ibd
210113 20:57:13 [01]        ...done
210113 20:57:13 [01] Copying ./sakila/language.ibd to /mysql-backup/3306/2021-01-13_20-57-06/sakila/language.ibd
210113 20:57:13 [01]        ...done
210113 20:57:13 [01] Copying ./sakila/payment.ibd to /mysql-backup/3306/2021-01-13_20-57-06/sakila/payment.ibd
210113 20:57:14 [01]        ...done
210113 20:57:14 [01] Copying ./sakila/rental.ibd to /mysql-backup/3306/2021-01-13_20-57-06/sakila/rental.ibd
210113 20:57:14 >> log scanned up to (2377883047)
210113 20:57:14 [01]        ...done
210113 20:57:14 [01] Copying ./sakila/staff.ibd to /mysql-backup/3306/2021-01-13_20-57-06/sakila/staff.ibd
210113 20:57:14 [01]        ...done
210113 20:57:14 [01] Copying ./sakila/store.ibd to /mysql-backup/3306/2021-01-13_20-57-06/sakila/store.ibd
210113 20:57:14 [01]        ...done
210113 20:57:14 [01] Copying ./check_sum/test1.ibd to /mysql-backup/3306/2021-01-13_20-57-06/check_sum/test1.ibd
210113 20:57:14 [01]        ...done
210113 20:57:15 Starting to backup non-InnoDB tables and files
210113 20:57:15 [01] Copying ./mysql/db.opt to /mysql-backup/3306/2021-01-13_20-57-06/mysql/db.opt
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/db.frm to /mysql-backup/3306/2021-01-13_20-57-06/mysql/db.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/db.MYI to /mysql-backup/3306/2021-01-13_20-57-06/mysql/db.MYI
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/db.MYD to /mysql-backup/3306/2021-01-13_20-57-06/mysql/db.MYD
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/user.frm to /mysql-backup/3306/2021-01-13_20-57-06/mysql/user.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/user.MYI to /mysql-backup/3306/2021-01-13_20-57-06/mysql/user.MYI
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/user.MYD to /mysql-backup/3306/2021-01-13_20-57-06/mysql/user.MYD
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/func.frm to /mysql-backup/3306/2021-01-13_20-57-06/mysql/func.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/func.MYI to /mysql-backup/3306/2021-01-13_20-57-06/mysql/func.MYI
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/func.MYD to /mysql-backup/3306/2021-01-13_20-57-06/mysql/func.MYD
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/plugin.frm to /mysql-backup/3306/2021-01-13_20-57-06/mysql/plugin.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/servers.frm to /mysql-backup/3306/2021-01-13_20-57-06/mysql/servers.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/tables_priv.frm to /mysql-backup/3306/2021-01-13_20-57-06/mysql/tables_priv.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/tables_priv.MYI to /mysql-backup/3306/2021-01-13_20-57-06/mysql/tables_priv.MYI
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/tables_priv.MYD to /mysql-backup/3306/2021-01-13_20-57-06/mysql/tables_priv.MYD
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/columns_priv.frm to /mysql-backup/3306/2021-01-13_20-57-06/mysql/columns_priv.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/columns_priv.MYI to /mysql-backup/3306/2021-01-13_20-57-06/mysql/columns_priv.MYI
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/columns_priv.MYD to /mysql-backup/3306/2021-01-13_20-57-06/mysql/columns_priv.MYD
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/help_topic.frm to /mysql-backup/3306/2021-01-13_20-57-06/mysql/help_topic.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/help_category.frm to /mysql-backup/3306/2021-01-13_20-57-06/mysql/help_category.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/help_relation.frm to /mysql-backup/3306/2021-01-13_20-57-06/mysql/help_relation.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/help_keyword.frm to /mysql-backup/3306/2021-01-13_20-57-06/mysql/help_keyword.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/time_zone_name.frm to /mysql-backup/3306/2021-01-13_20-57-06/mysql/time_zone_name.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/time_zone.frm to /mysql-backup/3306/2021-01-13_20-57-06/mysql/time_zone.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/time_zone_transition.frm to /mysql-backup/3306/2021-01-13_20-57-06/mysql/time_zone_transition.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/time_zone_transition_type.frm to /mysql-backup/3306/2021-01-13_20-57-06/mysql/time_zone_transition_type.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/time_zone_leap_second.frm to /mysql-backup/3306/2021-01-13_20-57-06/mysql/time_zone_leap_second.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/proc.frm to /mysql-backup/3306/2021-01-13_20-57-06/mysql/proc.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/proc.MYI to /mysql-backup/3306/2021-01-13_20-57-06/mysql/proc.MYI
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/proc.MYD to /mysql-backup/3306/2021-01-13_20-57-06/mysql/proc.MYD
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/procs_priv.frm to /mysql-backup/3306/2021-01-13_20-57-06/mysql/procs_priv.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/procs_priv.MYI to /mysql-backup/3306/2021-01-13_20-57-06/mysql/procs_priv.MYI
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/procs_priv.MYD to /mysql-backup/3306/2021-01-13_20-57-06/mysql/procs_priv.MYD
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/general_log.frm to /mysql-backup/3306/2021-01-13_20-57-06/mysql/general_log.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/general_log.CSM to /mysql-backup/3306/2021-01-13_20-57-06/mysql/general_log.CSM
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/general_log.CSV to /mysql-backup/3306/2021-01-13_20-57-06/mysql/general_log.CSV
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/slow_log.frm to /mysql-backup/3306/2021-01-13_20-57-06/mysql/slow_log.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/slow_log.CSM to /mysql-backup/3306/2021-01-13_20-57-06/mysql/slow_log.CSM
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/slow_log.CSV to /mysql-backup/3306/2021-01-13_20-57-06/mysql/slow_log.CSV
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/event.frm to /mysql-backup/3306/2021-01-13_20-57-06/mysql/event.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/event.MYI to /mysql-backup/3306/2021-01-13_20-57-06/mysql/event.MYI
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/event.MYD to /mysql-backup/3306/2021-01-13_20-57-06/mysql/event.MYD
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/ndb_binlog_index.frm to /mysql-backup/3306/2021-01-13_20-57-06/mysql/ndb_binlog_index.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/ndb_binlog_index.MYI to /mysql-backup/3306/2021-01-13_20-57-06/mysql/ndb_binlog_index.MYI
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/ndb_binlog_index.MYD to /mysql-backup/3306/2021-01-13_20-57-06/mysql/ndb_binlog_index.MYD
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/innodb_table_stats.frm to /mysql-backup/3306/2021-01-13_20-57-06/mysql/innodb_table_stats.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/innodb_index_stats.frm to /mysql-backup/3306/2021-01-13_20-57-06/mysql/innodb_index_stats.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/slave_relay_log_info.frm to /mysql-backup/3306/2021-01-13_20-57-06/mysql/slave_relay_log_info.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/slave_master_info.frm to /mysql-backup/3306/2021-01-13_20-57-06/mysql/slave_master_info.frm
210113 20:57:15 >> log scanned up to (2377883047)
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/slave_worker_info.frm to /mysql-backup/3306/2021-01-13_20-57-06/mysql/slave_worker_info.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/gtid_executed.frm to /mysql-backup/3306/2021-01-13_20-57-06/mysql/gtid_executed.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/server_cost.frm to /mysql-backup/3306/2021-01-13_20-57-06/mysql/server_cost.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/engine_cost.frm to /mysql-backup/3306/2021-01-13_20-57-06/mysql/engine_cost.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/proxies_priv.frm to /mysql-backup/3306/2021-01-13_20-57-06/mysql/proxies_priv.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/proxies_priv.MYI to /mysql-backup/3306/2021-01-13_20-57-06/mysql/proxies_priv.MYI
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./mysql/proxies_priv.MYD to /mysql-backup/3306/2021-01-13_20-57-06/mysql/proxies_priv.MYD
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/db.opt to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/db.opt
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/cond_instances.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/cond_instances.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/events_waits_current.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/events_waits_current.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/events_waits_history.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/events_waits_history.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/events_waits_history_long.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/events_waits_history_long.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/events_waits_summary_by_instance.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/events_waits_summary_by_instance.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/events_waits_summary_by_host_by_event_name.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/events_waits_summary_by_host_by_event_name.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/events_waits_summary_by_user_by_event_name.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/events_waits_summary_by_user_by_event_name.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/events_waits_summary_by_account_by_event_name.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/events_waits_summary_by_account_by_event_name.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/events_waits_summary_by_thread_by_event_name.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/events_waits_summary_by_thread_by_event_name.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/events_waits_summary_global_by_event_name.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/events_waits_summary_global_by_event_name.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/file_instances.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/file_instances.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/file_summary_by_event_name.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/file_summary_by_event_name.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/file_summary_by_instance.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/file_summary_by_instance.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/socket_instances.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/socket_instances.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/socket_summary_by_instance.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/socket_summary_by_instance.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/socket_summary_by_event_name.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/socket_summary_by_event_name.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/host_cache.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/host_cache.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/mutex_instances.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/mutex_instances.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/objects_summary_global_by_type.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/objects_summary_global_by_type.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/performance_timers.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/performance_timers.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/rwlock_instances.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/rwlock_instances.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/setup_actors.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/setup_actors.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/setup_consumers.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/setup_consumers.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/setup_instruments.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/setup_instruments.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/setup_objects.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/setup_objects.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/setup_timers.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/setup_timers.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/table_io_waits_summary_by_index_usage.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/table_io_waits_summary_by_index_usage.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/table_io_waits_summary_by_table.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/table_io_waits_summary_by_table.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/table_lock_waits_summary_by_table.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/table_lock_waits_summary_by_table.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/threads.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/threads.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/events_stages_current.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/events_stages_current.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/events_stages_history.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/events_stages_history.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/events_stages_history_long.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/events_stages_history_long.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/events_stages_summary_by_thread_by_event_name.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/events_stages_summary_by_thread_by_event_name.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/events_stages_summary_by_host_by_event_name.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/events_stages_summary_by_host_by_event_name.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/events_stages_summary_by_user_by_event_name.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/events_stages_summary_by_user_by_event_name.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/events_stages_summary_by_account_by_event_name.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/events_stages_summary_by_account_by_event_name.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/events_stages_summary_global_by_event_name.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/events_stages_summary_global_by_event_name.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/events_statements_current.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/events_statements_current.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/events_statements_history.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/events_statements_history.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/events_statements_history_long.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/events_statements_history_long.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/events_statements_summary_by_thread_by_event_name.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/events_statements_summary_by_thread_by_event_name.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/events_statements_summary_by_host_by_event_name.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/events_statements_summary_by_host_by_event_name.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/events_statements_summary_by_user_by_event_name.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/events_statements_summary_by_user_by_event_name.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/events_statements_summary_by_account_by_event_name.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/events_statements_summary_by_account_by_event_name.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/events_statements_summary_global_by_event_name.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/events_statements_summary_global_by_event_name.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/events_transactions_current.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/events_transactions_current.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/events_transactions_history.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/events_transactions_history.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/events_transactions_history_long.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/events_transactions_history_long.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/events_transactions_summary_by_thread_by_event_name.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/events_transactions_summary_by_thread_by_event_name.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/events_transactions_summary_by_host_by_event_name.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/events_transactions_summary_by_host_by_event_name.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/events_transactions_summary_by_user_by_event_name.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/events_transactions_summary_by_user_by_event_name.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/events_transactions_summary_by_account_by_event_name.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/events_transactions_summary_by_account_by_event_name.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/events_transactions_summary_global_by_event_name.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/events_transactions_summary_global_by_event_name.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/hosts.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/hosts.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/users.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/users.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/accounts.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/accounts.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/memory_summary_global_by_event_name.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/memory_summary_global_by_event_name.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/memory_summary_by_thread_by_event_name.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/memory_summary_by_thread_by_event_name.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/memory_summary_by_account_by_event_name.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/memory_summary_by_account_by_event_name.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/memory_summary_by_host_by_event_name.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/memory_summary_by_host_by_event_name.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/memory_summary_by_user_by_event_name.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/memory_summary_by_user_by_event_name.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/events_statements_summary_by_digest.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/events_statements_summary_by_digest.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/events_statements_summary_by_program.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/events_statements_summary_by_program.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/prepared_statements_instances.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/prepared_statements_instances.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/replication_connection_configuration.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/replication_connection_configuration.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/replication_group_member_stats.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/replication_group_member_stats.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/replication_group_members.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/replication_group_members.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/replication_connection_status.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/replication_connection_status.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/replication_applier_configuration.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/replication_applier_configuration.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/replication_applier_status.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/replication_applier_status.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/replication_applier_status_by_coordinator.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/replication_applier_status_by_coordinator.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/replication_applier_status_by_worker.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/replication_applier_status_by_worker.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/session_connect_attrs.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/session_connect_attrs.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/session_account_connect_attrs.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/session_account_connect_attrs.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/table_handles.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/table_handles.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/metadata_locks.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/metadata_locks.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/user_variables_by_thread.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/user_variables_by_thread.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/variables_by_thread.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/variables_by_thread.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/global_variables.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/global_variables.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/session_variables.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/session_variables.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/status_by_thread.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/status_by_thread.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/status_by_user.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/status_by_user.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/status_by_host.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/status_by_host.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/status_by_account.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/status_by_account.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/global_status.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/global_status.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./performance_schema/session_status.frm to /mysql-backup/3306/2021-01-13_20-57-06/performance_schema/session_status.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/db.opt to /mysql-backup/3306/2021-01-13_20-57-06/sys/db.opt
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/version.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/version.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/sys_config.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/sys_config.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/statements_with_full_table_scans.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/statements_with_full_table_scans.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/sys_config_insert_set_user.TRN to /mysql-backup/3306/2021-01-13_20-57-06/sys/sys_config_insert_set_user.TRN
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/processlist.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/processlist.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/sys_config.TRG to /mysql-backup/3306/2021-01-13_20-57-06/sys/sys_config.TRG
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/statements_with_sorting.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/statements_with_sorting.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/sys_config_update_set_user.TRN to /mysql-backup/3306/2021-01-13_20-57-06/sys/sys_config_update_set_user.TRN
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/x@0024statements_with_sorting.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024statements_with_sorting.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/innodb_buffer_stats_by_schema.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/innodb_buffer_stats_by_schema.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/schema_index_statistics.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/schema_index_statistics.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/x@0024innodb_buffer_stats_by_schema.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024innodb_buffer_stats_by_schema.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/statements_with_temp_tables.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/statements_with_temp_tables.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/innodb_buffer_stats_by_table.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/innodb_buffer_stats_by_table.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/x@0024ps_schema_table_statistics_io.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024ps_schema_table_statistics_io.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/x@0024innodb_buffer_stats_by_table.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024innodb_buffer_stats_by_table.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/host_summary.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/host_summary.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/innodb_lock_waits.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/innodb_lock_waits.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/x@0024host_summary.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024host_summary.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/x@0024innodb_lock_waits.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024innodb_lock_waits.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/waits_by_user_by_latency.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/waits_by_user_by_latency.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/schema_object_overview.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/schema_object_overview.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/user_summary_by_file_io_type.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/user_summary_by_file_io_type.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/schema_auto_increment_columns.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/schema_auto_increment_columns.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/user_summary_by_file_io.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/user_summary_by_file_io.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/x@0024schema_flattened_keys.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024schema_flattened_keys.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/x@0024user_summary_by_file_io.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024user_summary_by_file_io.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/schema_redundant_indexes.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/schema_redundant_indexes.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/user_summary_by_statement_type.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/user_summary_by_statement_type.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/ps_check_lost_instrumentation.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/ps_check_lost_instrumentation.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/latest_file_io.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/latest_file_io.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/waits_by_host_by_latency.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/waits_by_host_by_latency.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/x@0024latest_file_io.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024latest_file_io.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/waits_global_by_latency.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/waits_global_by_latency.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/io_by_thread_by_latency.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/io_by_thread_by_latency.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/user_summary_by_stages.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/user_summary_by_stages.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/x@0024io_by_thread_by_latency.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024io_by_thread_by_latency.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/x@0024user_summary_by_stages.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024user_summary_by_stages.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/io_global_by_file_by_bytes.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/io_global_by_file_by_bytes.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/x@0024schema_index_statistics.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024schema_index_statistics.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/x@0024io_global_by_file_by_bytes.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024io_global_by_file_by_bytes.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/user_summary.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/user_summary.frm
210113 20:57:15 [01]        ...done
210113 20:57:15 [01] Copying ./sys/io_global_by_file_by_latency.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/io_global_by_file_by_latency.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/schema_table_statistics.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/schema_table_statistics.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/x@0024io_global_by_file_by_latency.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024io_global_by_file_by_latency.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/x@0024user_summary.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024user_summary.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/io_global_by_wait_by_bytes.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/io_global_by_wait_by_bytes.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/x@0024schema_table_statistics.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024schema_table_statistics.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/x@0024io_global_by_wait_by_bytes.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024io_global_by_wait_by_bytes.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/host_summary_by_file_io_type.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/host_summary_by_file_io_type.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/io_global_by_wait_by_latency.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/io_global_by_wait_by_latency.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/schema_table_statistics_with_buffer.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/schema_table_statistics_with_buffer.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/x@0024io_global_by_wait_by_latency.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024io_global_by_wait_by_latency.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/host_summary_by_file_io.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/host_summary_by_file_io.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/memory_by_user_by_current_bytes.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/memory_by_user_by_current_bytes.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/schema_table_lock_waits.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/schema_table_lock_waits.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/x@0024memory_by_user_by_current_bytes.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024memory_by_user_by_current_bytes.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/x@0024host_summary_by_file_io.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024host_summary_by_file_io.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/memory_by_host_by_current_bytes.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/memory_by_host_by_current_bytes.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/x@0024schema_table_lock_waits.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024schema_table_lock_waits.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/x@0024memory_by_host_by_current_bytes.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024memory_by_host_by_current_bytes.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/statement_analysis.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/statement_analysis.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/memory_by_thread_by_current_bytes.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/memory_by_thread_by_current_bytes.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/x@0024statement_analysis.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024statement_analysis.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/x@0024memory_by_thread_by_current_bytes.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024memory_by_thread_by_current_bytes.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/host_summary_by_statement_type.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/host_summary_by_statement_type.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/memory_global_by_current_bytes.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/memory_global_by_current_bytes.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/statements_with_errors_or_warnings.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/statements_with_errors_or_warnings.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/x@0024memory_global_by_current_bytes.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024memory_global_by_current_bytes.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/metrics.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/metrics.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/memory_global_total.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/memory_global_total.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/host_summary_by_stages.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/host_summary_by_stages.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/x@0024memory_global_total.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024memory_global_total.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/session.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/session.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/x@0024schema_table_statistics_with_buffer.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024schema_table_statistics_with_buffer.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/x@0024statements_with_errors_or_warnings.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024statements_with_errors_or_warnings.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/schema_tables_with_full_table_scans.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/schema_tables_with_full_table_scans.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/schema_unused_indexes.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/schema_unused_indexes.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/x@0024schema_tables_with_full_table_scans.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024schema_tables_with_full_table_scans.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/x@0024host_summary_by_stages.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024host_summary_by_stages.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/x@0024statements_with_full_table_scans.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024statements_with_full_table_scans.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/x@0024ps_digest_avg_latency_distribution.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024ps_digest_avg_latency_distribution.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/x@0024ps_digest_95th_percentile_by_avg_us.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024ps_digest_95th_percentile_by_avg_us.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/statements_with_runtimes_in_95th_percentile.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/statements_with_runtimes_in_95th_percentile.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/x@0024statements_with_runtimes_in_95th_percentile.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024statements_with_runtimes_in_95th_percentile.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/x@0024statements_with_temp_tables.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024statements_with_temp_tables.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/x@0024user_summary_by_file_io_type.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024user_summary_by_file_io_type.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/x@0024user_summary_by_statement_type.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024user_summary_by_statement_type.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/user_summary_by_statement_latency.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/user_summary_by_statement_latency.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/x@0024user_summary_by_statement_latency.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024user_summary_by_statement_latency.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/x@0024host_summary_by_file_io_type.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024host_summary_by_file_io_type.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/x@0024host_summary_by_statement_type.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024host_summary_by_statement_type.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/host_summary_by_statement_latency.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/host_summary_by_statement_latency.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/x@0024host_summary_by_statement_latency.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024host_summary_by_statement_latency.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/wait_classes_global_by_avg_latency.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/wait_classes_global_by_avg_latency.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/x@0024wait_classes_global_by_avg_latency.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024wait_classes_global_by_avg_latency.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/wait_classes_global_by_latency.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/wait_classes_global_by_latency.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/x@0024wait_classes_global_by_latency.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024wait_classes_global_by_latency.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/x@0024waits_by_user_by_latency.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024waits_by_user_by_latency.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/x@0024waits_by_host_by_latency.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024waits_by_host_by_latency.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/x@0024waits_global_by_latency.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024waits_global_by_latency.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/x@0024processlist.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024processlist.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/x@0024session.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/x@0024session.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sys/session_ssl_status.frm to /mysql-backup/3306/2021-01-13_20-57-06/sys/session_ssl_status.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./customer_db/db.opt to /mysql-backup/3306/2021-01-13_20-57-06/customer_db/db.opt
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./customer_db/product_brand_info.frm to /mysql-backup/3306/2021-01-13_20-57-06/customer_db/product_brand_info.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./customer_db/product_category.frm to /mysql-backup/3306/2021-01-13_20-57-06/customer_db/product_category.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./customer_db/product_comment.frm to /mysql-backup/3306/2021-01-13_20-57-06/customer_db/product_comment.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./customer_db/product_info.frm to /mysql-backup/3306/2021-01-13_20-57-06/customer_db/product_info.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./customer_db/product_pic_info.frm to /mysql-backup/3306/2021-01-13_20-57-06/customer_db/product_pic_info.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./customer_db/product_supplier_info.frm to /mysql-backup/3306/2021-01-13_20-57-06/customer_db/product_supplier_info.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./customer_db/serial.frm to /mysql-backup/3306/2021-01-13_20-57-06/customer_db/serial.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./customer_db/customer_balance_log.frm to /mysql-backup/3306/2021-01-13_20-57-06/customer_db/customer_balance_log.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./customer_db/customer_inf.frm to /mysql-backup/3306/2021-01-13_20-57-06/customer_db/customer_inf.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./customer_db/customer_login.frm to /mysql-backup/3306/2021-01-13_20-57-06/customer_db/customer_login.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./customer_db/customer_login_log.frm to /mysql-backup/3306/2021-01-13_20-57-06/customer_db/customer_login_log.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./customer_db/customer_point_log.frm to /mysql-backup/3306/2021-01-13_20-57-06/customer_db/customer_point_log.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./customer_db/order_cart.frm to /mysql-backup/3306/2021-01-13_20-57-06/customer_db/order_cart.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./customer_db/order_customer_addr.frm to /mysql-backup/3306/2021-01-13_20-57-06/customer_db/order_customer_addr.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./customer_db/order_detail.frm to /mysql-backup/3306/2021-01-13_20-57-06/customer_db/order_detail.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./customer_db/order_master.frm to /mysql-backup/3306/2021-01-13_20-57-06/customer_db/order_master.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./customer_db/region_info.frm to /mysql-backup/3306/2021-01-13_20-57-06/customer_db/region_info.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./customer_db/shipping_info.frm to /mysql-backup/3306/2021-01-13_20-57-06/customer_db/shipping_info.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./customer_db/warehouse_info.frm to /mysql-backup/3306/2021-01-13_20-57-06/customer_db/warehouse_info.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./customer_db/warehouse_proudct.frm to /mysql-backup/3306/2021-01-13_20-57-06/customer_db/warehouse_proudct.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./test/db.opt to /mysql-backup/3306/2021-01-13_20-57-06/test/db.opt
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./test/test_order.frm to /mysql-backup/3306/2021-01-13_20-57-06/test/test_order.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./test/test_orderdetail.frm to /mysql-backup/3306/2021-01-13_20-57-06/test/test_orderdetail.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./test/checksums.frm to /mysql-backup/3306/2021-01-13_20-57-06/test/checksums.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sakila/db.opt to /mysql-backup/3306/2021-01-13_20-57-06/sakila/db.opt
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sakila/actor.frm to /mysql-backup/3306/2021-01-13_20-57-06/sakila/actor.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sakila/address.frm to /mysql-backup/3306/2021-01-13_20-57-06/sakila/address.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sakila/category.frm to /mysql-backup/3306/2021-01-13_20-57-06/sakila/category.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sakila/city.frm to /mysql-backup/3306/2021-01-13_20-57-06/sakila/city.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sakila/country.frm to /mysql-backup/3306/2021-01-13_20-57-06/sakila/country.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sakila/customer.frm to /mysql-backup/3306/2021-01-13_20-57-06/sakila/customer.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sakila/film.frm to /mysql-backup/3306/2021-01-13_20-57-06/sakila/film.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sakila/film_actor.frm to /mysql-backup/3306/2021-01-13_20-57-06/sakila/film_actor.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sakila/film_category.frm to /mysql-backup/3306/2021-01-13_20-57-06/sakila/film_category.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sakila/film_text.frm to /mysql-backup/3306/2021-01-13_20-57-06/sakila/film_text.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sakila/ins_film.TRN to /mysql-backup/3306/2021-01-13_20-57-06/sakila/ins_film.TRN
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sakila/film.TRG to /mysql-backup/3306/2021-01-13_20-57-06/sakila/film.TRG
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sakila/upd_film.TRN to /mysql-backup/3306/2021-01-13_20-57-06/sakila/upd_film.TRN
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sakila/del_film.TRN to /mysql-backup/3306/2021-01-13_20-57-06/sakila/del_film.TRN
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sakila/inventory.frm to /mysql-backup/3306/2021-01-13_20-57-06/sakila/inventory.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sakila/language.frm to /mysql-backup/3306/2021-01-13_20-57-06/sakila/language.frm
210113 20:57:16 >> log scanned up to (2377883047)
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sakila/payment.frm to /mysql-backup/3306/2021-01-13_20-57-06/sakila/payment.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sakila/rental.frm to /mysql-backup/3306/2021-01-13_20-57-06/sakila/rental.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sakila/staff.frm to /mysql-backup/3306/2021-01-13_20-57-06/sakila/staff.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sakila/store.frm to /mysql-backup/3306/2021-01-13_20-57-06/sakila/store.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sakila/customer_list.frm to /mysql-backup/3306/2021-01-13_20-57-06/sakila/customer_list.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sakila/film_list.frm to /mysql-backup/3306/2021-01-13_20-57-06/sakila/film_list.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sakila/nicer_but_slower_film_list.frm to /mysql-backup/3306/2021-01-13_20-57-06/sakila/nicer_but_slower_film_list.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sakila/staff_list.frm to /mysql-backup/3306/2021-01-13_20-57-06/sakila/staff_list.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sakila/sales_by_store.frm to /mysql-backup/3306/2021-01-13_20-57-06/sakila/sales_by_store.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sakila/sales_by_film_category.frm to /mysql-backup/3306/2021-01-13_20-57-06/sakila/sales_by_film_category.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sakila/actor_info.frm to /mysql-backup/3306/2021-01-13_20-57-06/sakila/actor_info.frm
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sakila/customer_create_date.TRN to /mysql-backup/3306/2021-01-13_20-57-06/sakila/customer_create_date.TRN
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sakila/customer.TRG to /mysql-backup/3306/2021-01-13_20-57-06/sakila/customer.TRG
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sakila/payment_date.TRN to /mysql-backup/3306/2021-01-13_20-57-06/sakila/payment_date.TRN
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sakila/payment.TRG to /mysql-backup/3306/2021-01-13_20-57-06/sakila/payment.TRG
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sakila/rental_date.TRN to /mysql-backup/3306/2021-01-13_20-57-06/sakila/rental_date.TRN
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sakila/rental.TRG to /mysql-backup/3306/2021-01-13_20-57-06/sakila/rental.TRG
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sbtest/db.opt to /mysql-backup/3306/2021-01-13_20-57-06/sbtest/db.opt
210113 20:57:16 [01]        ...done
210113 20:57:16 [01] Copying ./sbtest/sbtest1.MYI to /mysql-backup/3306/2021-01-13_20-57-06/sbtest/sbtest1.MYI
210113 20:57:17 [01]        ...done
210113 20:57:17 [01] Copying ./sbtest/sbtest1.MYD to /mysql-backup/3306/2021-01-13_20-57-06/sbtest/sbtest1.MYD
210113 20:57:17 >> log scanned up to (2377883047)
210113 20:57:18 >> log scanned up to (2377883047)
210113 20:57:20 >> log scanned up to (2377883047)
210113 20:57:21 >> log scanned up to (2377883047)
210113 20:57:22 >> log scanned up to (2377883047)
210113 20:57:23 >> log scanned up to (2377883047)
210113 20:57:25 >> log scanned up to (2377883047)
210113 20:57:26 >> log scanned up to (2377883047)
210113 20:57:27 >> log scanned up to (2377883047)
210113 20:57:28 >> log scanned up to (2377883047)
210113 20:57:29 >> log scanned up to (2377883047)
210113 20:57:30 >> log scanned up to (2377883047)
210113 20:57:31 >> log scanned up to (2377883047)
210113 20:57:32 >> log scanned up to (2377883047)
210113 20:57:33 >> log scanned up to (2377883047)
210113 20:57:34 >> log scanned up to (2377883047)
210113 20:57:35 >> log scanned up to (2377883047)
210113 20:57:36 >> log scanned up to (2377883047)
210113 20:57:36 [01]        ...done
210113 20:57:37 [01] Copying ./sbtest/sbtest1.frm to /mysql-backup/3306/2021-01-13_20-57-06/sbtest/sbtest1.frm
210113 20:57:37 [01]        ...done
210113 20:57:37 [01] Copying ./check_sum/db.opt to /mysql-backup/3306/2021-01-13_20-57-06/check_sum/db.opt
210113 20:57:37 [01]        ...done
210113 20:57:37 [01] Copying ./check_sum/test1.frm to /mysql-backup/3306/2021-01-13_20-57-06/check_sum/test1.frm
210113 20:57:37 [01]        ...done
210113 20:57:37 Finished backing up non-InnoDB tables and files
210113 20:57:37 [00] Writing xtrabackup_binlog_info
210113 20:57:37 [00]        ...done
210113 20:57:37 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
xtrabackup: The latest check point (for incremental): '2377883038'
xtrabackup: Stopping log copying thread.
.210113 20:57:37 >> log scanned up to (2377883047)
210113 20:57:37 Backup created in directory '/mysql-backup/3306/2021-01-13_20-57-06/'
MySQL binlog position: filename 'log-bin.000018', position '152767204', GTID of the last change '6c26c068-a952-11ea-ac80-000c29407201:1-669,
6c26c068-a952-11ea-ac80-000c29407202:1-611,
6c26c068-a952-11ea-ac80-000c29407203:1-2110'
210113 20:57:37 [00] Writing backup-my.cnf
210113 20:57:37 [00]        ...done
210113 20:57:37 [00] Writing xtrabackup_info
210113 20:57:37 [00]        ...done
xtrabackup: Transaction log of lsn (2377883038) to (2377883047) was copied.
210113 20:57:38 completed OK!
 
#执行备份操作,压缩打包 
[root@MHA-Master-201 bin]# innobackupex --defaults-file=/etc/my.cnf --host=127.0.0.1 --port=3306 --user=xtrabackup --password=123456  --use-memory=1G    /mysql-backup/3306
210113 21:46:41 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!".
 
210113 21:46:42  version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;host=127.0.0.1;port=3306' as 'xtrabackup'  (using password: YES).
210113 21:46:42  version_check Connected to MySQL server
210113 21:46:42  version_check Executing a version check against the server...
210113 21:46:42  version_check Done.
210113 21:46:42 Connecting to MySQL server host: 127.0.0.1, user: xtrabackup, password: set, port: 3306, socket: not set
Using server version 5.7.26-log
innobackupex version 2.4.7 based on MySQL server 5.7.13 Linux (x86_64) (revision id: 05f1fcf)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /data/my3306/data/
xtrabackup: open files limit requested 65535, set to 65535
xtrabackup: using the following InnoDB configuration:
xtrabackup:   innodb_data_home_dir = /data/my3306/log/iblog
xtrabackup:   innodb_data_file_path = ibdata1:12M:autoextend
xtrabackup:   innodb_log_group_home_dir = /data/my3306/log/iblog
xtrabackup:   innodb_log_files_in_group = 2
xtrabackup:   innodb_log_file_size = 268435456
xtrabackup: using O_DIRECT
InnoDB: Number of pools: 1
210113 21:46:43 >> log scanned up to (2377883047)
xtrabackup: Generating a list of tablespaces
InnoDB: Allocated tablespace ID 2 for mysql/plugin, old maximum was 0
210113 21:46:44 >> log scanned up to (2377883047)
210113 21:46:44 [01] Compressing /data/my3306/log/iblog/ibdata1 to /mysql-backup/3306/2021-01-13_21-46-41/ibdata1.qp
210113 21:46:45 >> log scanned up to (2377883047)
210113 21:46:45 [01]        ...done
210113 21:46:45 [01] Compressing ./mysql/plugin.ibd to /mysql-backup/3306/2021-01-13_21-46-41/mysql/plugin.ibd.qp
210113 21:46:45 [01]        ...done
210113 21:46:45 [01] Compressing ./mysql/servers.ibd to /mysql-backup/3306/2021-01-13_21-46-41/mysql/servers.ibd.qp
210113 21:46:45 [01]        ...done
210113 21:46:45 [01] Compressing ./mysql/help_topic.ibd to /mysql-backup/3306/2021-01-13_21-46-41/mysql/help_topic.ibd.qp
210113 21:46:45 [01]        ...done
210113 21:46:45 [01] Compressing ./mysql/help_category.ibd to /mysql-backup/3306/2021-01-13_21-46-41/mysql/help_category.ibd.qp
210113 21:46:45 [01]        ...done
210113 21:46:45 [01] Compressing ./mysql/help_relation.ibd to /mysql-backup/3306/2021-01-13_21-46-41/mysql/help_relation.ibd.qp
210113 21:46:45 [01]        ...done
210113 21:46:45 [01] Compressing ./mysql/help_keyword.ibd to /mysql-backup/3306/2021-01-13_21-46-41/mysql/help_keyword.ibd.qp
210113 21:46:45 [01]        ...done
210113 21:46:45 [01] Compressing ./mysql/time_zone_name.ibd to /mysql-backup/3306/2021-01-13_21-46-41/mysql/time_zone_name.ibd.qp
210113 21:46:45 [01]        ...done
210113 21:46:45 [01] Compressing ./mysql/time_zone.ibd to /mysql-backup/3306/2021-01-13_21-46-41/mysql/time_zone.ibd.qp
210113 21:46:45 [01]        ...done
210113 21:46:45 [01] Compressing ./mysql/time_zone_transition.ibd to /mysql-backup/3306/2021-01-13_21-46-41/mysql/time_zone_transition.ibd.qp
210113 21:46:45 [01]        ...done
210113 21:46:45 [01] Compressing ./mysql/time_zone_transition_type.ibd to /mysql-backup/3306/2021-01-13_21-46-41/mysql/time_zone_transition_type.ibd.qp
210113 21:46:45 [01]        ...done
210113 21:46:45 [01] Compressing ./mysql/time_zone_leap_second.ibd to /mysql-backup/3306/2021-01-13_21-46-41/mysql/time_zone_leap_second.ibd.qp
210113 21:46:45 [01]        ...done
210113 21:46:45 [01] Compressing ./mysql/innodb_table_stats.ibd to /mysql-backup/3306/2021-01-13_21-46-41/mysql/innodb_table_stats.ibd.qp
210113 21:46:45 [01]        ...done
210113 21:46:45 [01] Compressing ./mysql/innodb_index_stats.ibd to /mysql-backup/3306/2021-01-13_21-46-41/mysql/innodb_index_stats.ibd.qp
210113 21:46:46 [01]        ...done
210113 21:46:46 [01] Compressing ./mysql/slave_relay_log_info.ibd to /mysql-backup/3306/2021-01-13_21-46-41/mysql/slave_relay_log_info.ibd.qp
210113 21:46:46 [01]        ...done
210113 21:46:46 >> log scanned up to (2377883047)
210113 21:46:46 [01] Compressing ./mysql/slave_master_info.ibd to /mysql-backup/3306/2021-01-13_21-46-41/mysql/slave_master_info.ibd.qp
210113 21:46:46 [01]        ...done
210113 21:46:46 [01] Compressing ./mysql/slave_worker_info.ibd to /mysql-backup/3306/2021-01-13_21-46-41/mysql/slave_worker_info.ibd.qp
210113 21:46:46 [01]        ...done
210113 21:46:46 [01] Compressing ./mysql/gtid_executed.ibd to /mysql-backup/3306/2021-01-13_21-46-41/mysql/gtid_executed.ibd.qp
210113 21:46:46 [01]        ...done
210113 21:46:46 [01] Compressing ./mysql/server_cost.ibd to /mysql-backup/3306/2021-01-13_21-46-41/mysql/server_cost.ibd.qp
210113 21:46:46 [01]        ...done
210113 21:46:46 [01] Compressing ./mysql/engine_cost.ibd to /mysql-backup/3306/2021-01-13_21-46-41/mysql/engine_cost.ibd.qp
210113 21:46:46 [01]        ...done
210113 21:46:46 [01] Compressing ./sys/sys_config.ibd to /mysql-backup/3306/2021-01-13_21-46-41/sys/sys_config.ibd.qp
210113 21:46:46 [01]        ...done
210113 21:46:46 [01] Compressing ./customer_db/product_brand_info.ibd to /mysql-backup/3306/2021-01-13_21-46-41/customer_db/product_brand_info.ibd.qp
210113 21:46:46 [01]        ...done
210113 21:46:46 [01] Compressing ./customer_db/product_category.ibd to /mysql-backup/3306/2021-01-13_21-46-41/customer_db/product_category.ibd.qp
210113 21:46:46 [01]        ...done
210113 21:46:46 [01] Compressing ./customer_db/product_comment.ibd to /mysql-backup/3306/2021-01-13_21-46-41/customer_db/product_comment.ibd.qp
210113 21:46:46 [01]        ...done
210113 21:46:46 [01] Compressing ./customer_db/product_info.ibd to /mysql-backup/3306/2021-01-13_21-46-41/customer_db/product_info.ibd.qp
210113 21:46:46 [01]        ...done
210113 21:46:46 [01] Compressing ./customer_db/product_pic_info.ibd to /mysql-backup/3306/2021-01-13_21-46-41/customer_db/product_pic_info.ibd.qp
210113 21:46:47 [01]        ...done
210113 21:46:47 [01] Compressing ./customer_db/product_supplier_info.ibd to /mysql-backup/3306/2021-01-13_21-46-41/customer_db/product_supplier_info.ibd.qp
210113 21:46:47 [01]        ...done
210113 21:46:47 [01] Compressing ./customer_db/serial.ibd to /mysql-backup/3306/2021-01-13_21-46-41/customer_db/serial.ibd.qp
210113 21:46:47 >> log scanned up to (2377883047)
210113 21:46:47 [01]        ...done
210113 21:46:47 [01] Compressing ./customer_db/customer_balance_log.ibd to /mysql-backup/3306/2021-01-13_21-46-41/customer_db/customer_balance_log.ibd.qp
210113 21:46:47 [01]        ...done
210113 21:46:47 [01] Compressing ./customer_db/customer_inf.ibd to /mysql-backup/3306/2021-01-13_21-46-41/customer_db/customer_inf.ibd.qp
210113 21:46:47 [01]        ...done
210113 21:46:47 [01] Compressing ./customer_db/customer_login.ibd to /mysql-backup/3306/2021-01-13_21-46-41/customer_db/customer_login.ibd.qp
210113 21:46:47 [01]        ...done
210113 21:46:47 [01] Compressing ./customer_db/customer_login_log.ibd to /mysql-backup/3306/2021-01-13_21-46-41/customer_db/customer_login_log.ibd.qp
210113 21:46:47 [01]        ...done
210113 21:46:47 [01] Compressing ./customer_db/customer_point_log.ibd to /mysql-backup/3306/2021-01-13_21-46-41/customer_db/customer_point_log.ibd.qp
210113 21:46:47 [01]        ...done
210113 21:46:47 [01] Compressing ./customer_db/order_cart.ibd to /mysql-backup/3306/2021-01-13_21-46-41/customer_db/order_cart.ibd.qp
210113 21:46:47 [01]        ...done
210113 21:46:47 [01] Compressing ./customer_db/order_customer_addr.ibd to /mysql-backup/3306/2021-01-13_21-46-41/customer_db/order_customer_addr.ibd.qp
210113 21:46:47 [01]        ...done
210113 21:46:47 [01] Compressing ./customer_db/order_detail.ibd to /mysql-backup/3306/2021-01-13_21-46-41/customer_db/order_detail.ibd.qp
210113 21:46:47 [01]        ...done
210113 21:46:47 [01] Compressing ./customer_db/order_master.ibd to /mysql-backup/3306/2021-01-13_21-46-41/customer_db/order_master.ibd.qp
210113 21:46:47 [01]        ...done
210113 21:46:47 [01] Compressing ./customer_db/region_info.ibd to /mysql-backup/3306/2021-01-13_21-46-41/customer_db/region_info.ibd.qp
210113 21:46:47 [01]        ...done
210113 21:46:47 [01] Compressing ./customer_db/shipping_info.ibd to /mysql-backup/3306/2021-01-13_21-46-41/customer_db/shipping_info.ibd.qp
210113 21:46:47 [01]        ...done
210113 21:46:47 [01] Compressing ./customer_db/warehouse_info.ibd to /mysql-backup/3306/2021-01-13_21-46-41/customer_db/warehouse_info.ibd.qp
210113 21:46:47 [01]        ...done
210113 21:46:47 [01] Compressing ./customer_db/warehouse_proudct.ibd to /mysql-backup/3306/2021-01-13_21-46-41/customer_db/warehouse_proudct.ibd.qp
210113 21:46:47 [01]        ...done
210113 21:46:47 [01] Compressing ./test/test_order.ibd to /mysql-backup/3306/2021-01-13_21-46-41/test/test_order.ibd.qp
210113 21:46:47 [01]        ...done
210113 21:46:47 [01] Compressing ./test/test_orderdetail.ibd to /mysql-backup/3306/2021-01-13_21-46-41/test/test_orderdetail.ibd.qp
210113 21:46:47 [01]        ...done
210113 21:46:47 [01] Compressing ./test/checksums.ibd to /mysql-backup/3306/2021-01-13_21-46-41/test/checksums.ibd.qp
210113 21:46:47 [01]        ...done
210113 21:46:47 [01] Compressing ./sakila/actor.ibd to /mysql-backup/3306/2021-01-13_21-46-41/sakila/actor.ibd.qp
210113 21:46:47 [01]        ...done
210113 21:46:47 [01] Compressing ./sakila/address.ibd to /mysql-backup/3306/2021-01-13_21-46-41/sakila/address.ibd.qp
210113 21:46:47 [01]        ...done
210113 21:46:47 [01] Compressing ./sakila/category.ibd to /mysql-backup/3306/2021-01-13_21-46-41/sakila/category.ibd.qp
210113 21:46:47 [01]        ...done
210113 21:46:47 [01] Compressing ./sakila/city.ibd to /mysql-backup/3306/2021-01-13_21-46-41/sakila/city.ibd.qp
210113 21:46:47 [01]        ...done
210113 21:46:47 [01] Compressing ./sakila/country.ibd to /mysql-backup/3306/2021-01-13_21-46-41/sakila/country.ibd.qp
210113 21:46:47 [01]        ...done
210113 21:46:47 [01] Compressing ./sakila/customer.ibd to /mysql-backup/3306/2021-01-13_21-46-41/sakila/customer.ibd.qp
210113 21:46:47 [01]        ...done
210113 21:46:47 [01] Compressing ./sakila/film.ibd to /mysql-backup/3306/2021-01-13_21-46-41/sakila/film.ibd.qp
210113 21:46:47 [01]        ...done
210113 21:46:47 [01] Compressing ./sakila/film_actor.ibd to /mysql-backup/3306/2021-01-13_21-46-41/sakila/film_actor.ibd.qp
210113 21:46:47 [01]        ...done
210113 21:46:47 [01] Compressing ./sakila/film_category.ibd to /mysql-backup/3306/2021-01-13_21-46-41/sakila/film_category.ibd.qp
210113 21:46:47 [01]        ...done
210113 21:46:47 [01] Compressing ./sakila/film_text.ibd to /mysql-backup/3306/2021-01-13_21-46-41/sakila/film_text.ibd.qp
210113 21:46:47 [01]        ...done
210113 21:46:47 [01] Compressing ./sakila/FTS_000000000000006e_BEING_DELETED.ibd to /mysql-backup/3306/2021-01-13_21-46-41/sakila/FTS_000000000000006e_BEING_DELETED.ibd.qp
210113 21:46:47 [01]        ...done
210113 21:46:47 [01] Compressing ./sakila/FTS_000000000000006e_BEING_DELETED_CACHE.ibd to /mysql-backup/3306/2021-01-13_21-46-41/sakila/FTS_000000000000006e_BEING_DELETED_CACHE.ibd.qp
210113 21:46:47 [01]        ...done
210113 21:46:47 [01] Compressing ./sakila/FTS_000000000000006e_CONFIG.ibd to /mysql-backup/3306/2021-01-13_21-46-41/sakila/FTS_000000000000006e_CONFIG.ibd.qp
210113 21:46:47 [01]        ...done
210113 21:46:47 [01] Compressing ./sakila/FTS_000000000000006e_DELETED.ibd to /mysql-backup/3306/2021-01-13_21-46-41/sakila/FTS_000000000000006e_DELETED.ibd.qp
210113 21:46:47 [01]        ...done
210113 21:46:47 [01] Compressing ./sakila/FTS_000000000000006e_DELETED_CACHE.ibd to /mysql-backup/3306/2021-01-13_21-46-41/sakila/FTS_000000000000006e_DELETED_CACHE.ibd.qp
210113 21:46:47 [01]        ...done
210113 21:46:47 [01] Compressing ./sakila/FTS_000000000000006e_0000000000000084_INDEX_1.ibd to /mysql-backup/3306/2021-01-13_21-46-41/sakila/FTS_000000000000006e_0000000000000084_INDEX_1.ibd.qp
210113 21:46:47 [01]        ...done
210113 21:46:47 [01] Compressing ./sakila/FTS_000000000000006e_0000000000000084_INDEX_2.ibd to /mysql-backup/3306/2021-01-13_21-46-41/sakila/FTS_000000000000006e_0000000000000084_INDEX_2.ibd.qp
210113 21:46:47 [01]        ...done
210113 21:46:47 [01] Compressing ./sakila/FTS_000000000000006e_0000000000000084_INDEX_3.ibd to /mysql-backup/3306/2021-01-13_21-46-41/sakila/FTS_000000000000006e_0000000000000084_INDEX_3.ibd.qp
210113 21:46:47 [01]        ...done
210113 21:46:47 [01] Compressing ./sakila/FTS_000000000000006e_0000000000000084_INDEX_4.ibd to /mysql-backup/3306/2021-01-13_21-46-41/sakila/FTS_000000000000006e_0000000000000084_INDEX_4.ibd.qp
210113 21:46:48 [01]        ...done
210113 21:46:48 [01] Compressing ./sakila/FTS_000000000000006e_0000000000000084_INDEX_5.ibd to /mysql-backup/3306/2021-01-13_21-46-41/sakila/FTS_000000000000006e_0000000000000084_INDEX_5.ibd.qp
210113 21:46:48 [01]        ...done
210113 21:46:48 [01] Compressing ./sakila/FTS_000000000000006e_0000000000000084_INDEX_6.ibd to /mysql-backup/3306/2021-01-13_21-46-41/sakila/FTS_000000000000006e_0000000000000084_INDEX_6.ibd.qp
210113 21:46:48 [01]        ...done
210113 21:46:48 [01] Compressing ./sakila/inventory.ibd to /mysql-backup/3306/2021-01-13_21-46-41/sakila/inventory.ibd.qp
210113 21:46:48 [01]        ...done
210113 21:46:48 [01] Compressing ./sakila/language.ibd to /mysql-backup/3306/2021-01-13_21-46-41/sakila/language.ibd.qp
210113 21:46:48 [01]        ...done
210113 21:46:48 [01] Compressing ./sakila/payment.ibd to /mysql-backup/3306/2021-01-13_21-46-41/sakila/payment.ibd.qp
210113 21:46:48 [01]        ...done
210113 21:46:48 >> log scanned up to (2377883047)
210113 21:46:48 [01] Compressing ./sakila/rental.ibd to /mysql-backup/3306/2021-01-13_21-46-41/sakila/rental.ibd.qp
210113 21:46:48 [01]        ...done
210113 21:46:48 [01] Compressing ./sakila/staff.ibd to /mysql-backup/3306/2021-01-13_21-46-41/sakila/staff.ibd.qp
210113 21:46:48 [01]        ...done
210113 21:46:48 [01] Compressing ./sakila/store.ibd to /mysql-backup/3306/2021-01-13_21-46-41/sakila/store.ibd.qp
210113 21:46:48 [01]        ...done
210113 21:46:48 [01] Compressing ./check_sum/test1.ibd to /mysql-backup/3306/2021-01-13_21-46-41/check_sum/test1.ibd.qp
210113 21:46:48 [01]        ...done
210113 21:46:48 Starting to backup non-InnoDB tables and files
210113 21:46:48 [01] Compressing ./mysql/db.opt to /mysql-backup/3306/2021-01-13_21-46-41/mysql/db.opt.qp
210113 21:46:48 [01]        ...done
210113 21:46:48 [01] Compressing ./mysql/db.frm to /mysql-backup/3306/2021-01-13_21-46-41/mysql/db.frm.qp
210113 21:46:48 [01]        ...done
210113 21:46:48 [01] Compressing ./mysql/db.MYI to /mysql-backup/3306/2021-01-13_21-46-41/mysql/db.MYI.qp
210113 21:46:48 [01]        ...done
210113 21:46:48 [01] Compressing ./mysql/db.MYD to /mysql-backup/3306/2021-01-13_21-46-41/mysql/db.MYD.qp
210113 21:46:48 [01]        ...done
210113 21:46:48 [01] Compressing ./mysql/user.frm to /mysql-backup/3306/2021-01-13_21-46-41/mysql/user.frm.qp
210113 21:46:48 [01]        ...done
210113 21:46:48 [01] Compressing ./mysql/user.MYI to /mysql-backup/3306/2021-01-13_21-46-41/mysql/user.MYI.qp
210113 21:46:48 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/user.MYD to /mysql-backup/3306/2021-01-13_21-46-41/mysql/user.MYD.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/func.frm to /mysql-backup/3306/2021-01-13_21-46-41/mysql/func.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/func.MYI to /mysql-backup/3306/2021-01-13_21-46-41/mysql/func.MYI.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/func.MYD to /mysql-backup/3306/2021-01-13_21-46-41/mysql/func.MYD.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/plugin.frm to /mysql-backup/3306/2021-01-13_21-46-41/mysql/plugin.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/servers.frm to /mysql-backup/3306/2021-01-13_21-46-41/mysql/servers.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/tables_priv.frm to /mysql-backup/3306/2021-01-13_21-46-41/mysql/tables_priv.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/tables_priv.MYI to /mysql-backup/3306/2021-01-13_21-46-41/mysql/tables_priv.MYI.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/tables_priv.MYD to /mysql-backup/3306/2021-01-13_21-46-41/mysql/tables_priv.MYD.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/columns_priv.frm to /mysql-backup/3306/2021-01-13_21-46-41/mysql/columns_priv.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/columns_priv.MYI to /mysql-backup/3306/2021-01-13_21-46-41/mysql/columns_priv.MYI.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/columns_priv.MYD to /mysql-backup/3306/2021-01-13_21-46-41/mysql/columns_priv.MYD.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/help_topic.frm to /mysql-backup/3306/2021-01-13_21-46-41/mysql/help_topic.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/help_category.frm to /mysql-backup/3306/2021-01-13_21-46-41/mysql/help_category.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/help_relation.frm to /mysql-backup/3306/2021-01-13_21-46-41/mysql/help_relation.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/help_keyword.frm to /mysql-backup/3306/2021-01-13_21-46-41/mysql/help_keyword.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/time_zone_name.frm to /mysql-backup/3306/2021-01-13_21-46-41/mysql/time_zone_name.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/time_zone.frm to /mysql-backup/3306/2021-01-13_21-46-41/mysql/time_zone.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/time_zone_transition.frm to /mysql-backup/3306/2021-01-13_21-46-41/mysql/time_zone_transition.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/time_zone_transition_type.frm to /mysql-backup/3306/2021-01-13_21-46-41/mysql/time_zone_transition_type.frm.qp
210113 21:46:49 >> log scanned up to (2377883047)
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/time_zone_leap_second.frm to /mysql-backup/3306/2021-01-13_21-46-41/mysql/time_zone_leap_second.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/proc.frm to /mysql-backup/3306/2021-01-13_21-46-41/mysql/proc.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/proc.MYI to /mysql-backup/3306/2021-01-13_21-46-41/mysql/proc.MYI.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/proc.MYD to /mysql-backup/3306/2021-01-13_21-46-41/mysql/proc.MYD.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/procs_priv.frm to /mysql-backup/3306/2021-01-13_21-46-41/mysql/procs_priv.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/procs_priv.MYI to /mysql-backup/3306/2021-01-13_21-46-41/mysql/procs_priv.MYI.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/procs_priv.MYD to /mysql-backup/3306/2021-01-13_21-46-41/mysql/procs_priv.MYD.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/general_log.frm to /mysql-backup/3306/2021-01-13_21-46-41/mysql/general_log.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/general_log.CSM to /mysql-backup/3306/2021-01-13_21-46-41/mysql/general_log.CSM.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/general_log.CSV to /mysql-backup/3306/2021-01-13_21-46-41/mysql/general_log.CSV.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/slow_log.frm to /mysql-backup/3306/2021-01-13_21-46-41/mysql/slow_log.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/slow_log.CSM to /mysql-backup/3306/2021-01-13_21-46-41/mysql/slow_log.CSM.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/slow_log.CSV to /mysql-backup/3306/2021-01-13_21-46-41/mysql/slow_log.CSV.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/event.frm to /mysql-backup/3306/2021-01-13_21-46-41/mysql/event.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/event.MYI to /mysql-backup/3306/2021-01-13_21-46-41/mysql/event.MYI.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/event.MYD to /mysql-backup/3306/2021-01-13_21-46-41/mysql/event.MYD.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/ndb_binlog_index.frm to /mysql-backup/3306/2021-01-13_21-46-41/mysql/ndb_binlog_index.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/ndb_binlog_index.MYI to /mysql-backup/3306/2021-01-13_21-46-41/mysql/ndb_binlog_index.MYI.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/ndb_binlog_index.MYD to /mysql-backup/3306/2021-01-13_21-46-41/mysql/ndb_binlog_index.MYD.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/innodb_table_stats.frm to /mysql-backup/3306/2021-01-13_21-46-41/mysql/innodb_table_stats.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/innodb_index_stats.frm to /mysql-backup/3306/2021-01-13_21-46-41/mysql/innodb_index_stats.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/slave_relay_log_info.frm to /mysql-backup/3306/2021-01-13_21-46-41/mysql/slave_relay_log_info.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/slave_master_info.frm to /mysql-backup/3306/2021-01-13_21-46-41/mysql/slave_master_info.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/slave_worker_info.frm to /mysql-backup/3306/2021-01-13_21-46-41/mysql/slave_worker_info.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/gtid_executed.frm to /mysql-backup/3306/2021-01-13_21-46-41/mysql/gtid_executed.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/server_cost.frm to /mysql-backup/3306/2021-01-13_21-46-41/mysql/server_cost.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/engine_cost.frm to /mysql-backup/3306/2021-01-13_21-46-41/mysql/engine_cost.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/proxies_priv.frm to /mysql-backup/3306/2021-01-13_21-46-41/mysql/proxies_priv.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/proxies_priv.MYI to /mysql-backup/3306/2021-01-13_21-46-41/mysql/proxies_priv.MYI.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./mysql/proxies_priv.MYD to /mysql-backup/3306/2021-01-13_21-46-41/mysql/proxies_priv.MYD.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/db.opt to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/db.opt.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/cond_instances.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/cond_instances.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/events_waits_current.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/events_waits_current.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/events_waits_history.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/events_waits_history.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/events_waits_history_long.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/events_waits_history_long.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/events_waits_summary_by_instance.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/events_waits_summary_by_instance.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/events_waits_summary_by_host_by_event_name.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/events_waits_summary_by_host_by_event_name.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/events_waits_summary_by_user_by_event_name.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/events_waits_summary_by_user_by_event_name.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/events_waits_summary_by_account_by_event_name.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/events_waits_summary_by_account_by_event_name.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/events_waits_summary_by_thread_by_event_name.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/events_waits_summary_by_thread_by_event_name.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/events_waits_summary_global_by_event_name.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/events_waits_summary_global_by_event_name.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/file_instances.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/file_instances.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/file_summary_by_event_name.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/file_summary_by_event_name.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/file_summary_by_instance.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/file_summary_by_instance.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/socket_instances.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/socket_instances.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/socket_summary_by_instance.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/socket_summary_by_instance.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/socket_summary_by_event_name.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/socket_summary_by_event_name.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/host_cache.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/host_cache.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/mutex_instances.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/mutex_instances.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/objects_summary_global_by_type.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/objects_summary_global_by_type.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/performance_timers.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/performance_timers.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/rwlock_instances.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/rwlock_instances.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/setup_actors.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/setup_actors.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/setup_consumers.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/setup_consumers.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/setup_instruments.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/setup_instruments.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/setup_objects.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/setup_objects.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/setup_timers.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/setup_timers.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/table_io_waits_summary_by_index_usage.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/table_io_waits_summary_by_index_usage.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/table_io_waits_summary_by_table.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/table_io_waits_summary_by_table.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/table_lock_waits_summary_by_table.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/table_lock_waits_summary_by_table.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/threads.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/threads.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/events_stages_current.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/events_stages_current.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/events_stages_history.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/events_stages_history.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/events_stages_history_long.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/events_stages_history_long.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/events_stages_summary_by_thread_by_event_name.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/events_stages_summary_by_thread_by_event_name.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/events_stages_summary_by_host_by_event_name.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/events_stages_summary_by_host_by_event_name.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/events_stages_summary_by_user_by_event_name.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/events_stages_summary_by_user_by_event_name.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/events_stages_summary_by_account_by_event_name.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/events_stages_summary_by_account_by_event_name.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/events_stages_summary_global_by_event_name.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/events_stages_summary_global_by_event_name.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/events_statements_current.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/events_statements_current.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/events_statements_history.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/events_statements_history.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/events_statements_history_long.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/events_statements_history_long.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/events_statements_summary_by_thread_by_event_name.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/events_statements_summary_by_thread_by_event_name.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/events_statements_summary_by_host_by_event_name.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/events_statements_summary_by_host_by_event_name.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/events_statements_summary_by_user_by_event_name.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/events_statements_summary_by_user_by_event_name.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/events_statements_summary_by_account_by_event_name.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/events_statements_summary_by_account_by_event_name.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/events_statements_summary_global_by_event_name.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/events_statements_summary_global_by_event_name.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/events_transactions_current.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/events_transactions_current.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/events_transactions_history.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/events_transactions_history.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/events_transactions_history_long.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/events_transactions_history_long.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/events_transactions_summary_by_thread_by_event_name.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/events_transactions_summary_by_thread_by_event_name.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/events_transactions_summary_by_host_by_event_name.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/events_transactions_summary_by_host_by_event_name.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/events_transactions_summary_by_user_by_event_name.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/events_transactions_summary_by_user_by_event_name.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/events_transactions_summary_by_account_by_event_name.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/events_transactions_summary_by_account_by_event_name.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/events_transactions_summary_global_by_event_name.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/events_transactions_summary_global_by_event_name.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/hosts.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/hosts.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/users.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/users.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/accounts.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/accounts.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/memory_summary_global_by_event_name.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/memory_summary_global_by_event_name.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/memory_summary_by_thread_by_event_name.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/memory_summary_by_thread_by_event_name.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/memory_summary_by_account_by_event_name.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/memory_summary_by_account_by_event_name.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/memory_summary_by_host_by_event_name.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/memory_summary_by_host_by_event_name.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/memory_summary_by_user_by_event_name.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/memory_summary_by_user_by_event_name.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/events_statements_summary_by_digest.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/events_statements_summary_by_digest.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/events_statements_summary_by_program.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/events_statements_summary_by_program.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/prepared_statements_instances.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/prepared_statements_instances.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/replication_connection_configuration.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/replication_connection_configuration.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/replication_group_member_stats.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/replication_group_member_stats.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/replication_group_members.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/replication_group_members.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/replication_connection_status.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/replication_connection_status.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/replication_applier_configuration.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/replication_applier_configuration.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/replication_applier_status.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/replication_applier_status.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/replication_applier_status_by_coordinator.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/replication_applier_status_by_coordinator.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/replication_applier_status_by_worker.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/replication_applier_status_by_worker.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/session_connect_attrs.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/session_connect_attrs.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/session_account_connect_attrs.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/session_account_connect_attrs.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/table_handles.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/table_handles.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/metadata_locks.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/metadata_locks.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/user_variables_by_thread.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/user_variables_by_thread.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/variables_by_thread.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/variables_by_thread.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/global_variables.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/global_variables.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/session_variables.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/session_variables.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/status_by_thread.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/status_by_thread.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/status_by_user.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/status_by_user.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/status_by_host.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/status_by_host.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/status_by_account.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/status_by_account.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/global_status.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/global_status.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./performance_schema/session_status.frm to /mysql-backup/3306/2021-01-13_21-46-41/performance_schema/session_status.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/db.opt to /mysql-backup/3306/2021-01-13_21-46-41/sys/db.opt.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/version.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/version.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/sys_config.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/sys_config.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/statements_with_full_table_scans.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/statements_with_full_table_scans.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/sys_config_insert_set_user.TRN to /mysql-backup/3306/2021-01-13_21-46-41/sys/sys_config_insert_set_user.TRN.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/processlist.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/processlist.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/sys_config.TRG to /mysql-backup/3306/2021-01-13_21-46-41/sys/sys_config.TRG.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/statements_with_sorting.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/statements_with_sorting.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/sys_config_update_set_user.TRN to /mysql-backup/3306/2021-01-13_21-46-41/sys/sys_config_update_set_user.TRN.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024statements_with_sorting.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024statements_with_sorting.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/innodb_buffer_stats_by_schema.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/innodb_buffer_stats_by_schema.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/schema_index_statistics.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/schema_index_statistics.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024innodb_buffer_stats_by_schema.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024innodb_buffer_stats_by_schema.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/statements_with_temp_tables.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/statements_with_temp_tables.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/innodb_buffer_stats_by_table.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/innodb_buffer_stats_by_table.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024ps_schema_table_statistics_io.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024ps_schema_table_statistics_io.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024innodb_buffer_stats_by_table.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024innodb_buffer_stats_by_table.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/host_summary.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/host_summary.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/innodb_lock_waits.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/innodb_lock_waits.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024host_summary.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024host_summary.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024innodb_lock_waits.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024innodb_lock_waits.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/waits_by_user_by_latency.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/waits_by_user_by_latency.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/schema_object_overview.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/schema_object_overview.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/user_summary_by_file_io_type.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/user_summary_by_file_io_type.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/schema_auto_increment_columns.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/schema_auto_increment_columns.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/user_summary_by_file_io.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/user_summary_by_file_io.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024schema_flattened_keys.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024schema_flattened_keys.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024user_summary_by_file_io.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024user_summary_by_file_io.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/schema_redundant_indexes.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/schema_redundant_indexes.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/user_summary_by_statement_type.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/user_summary_by_statement_type.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/ps_check_lost_instrumentation.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/ps_check_lost_instrumentation.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/latest_file_io.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/latest_file_io.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/waits_by_host_by_latency.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/waits_by_host_by_latency.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024latest_file_io.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024latest_file_io.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/waits_global_by_latency.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/waits_global_by_latency.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/io_by_thread_by_latency.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/io_by_thread_by_latency.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/user_summary_by_stages.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/user_summary_by_stages.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024io_by_thread_by_latency.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024io_by_thread_by_latency.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024user_summary_by_stages.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024user_summary_by_stages.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/io_global_by_file_by_bytes.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/io_global_by_file_by_bytes.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024schema_index_statistics.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024schema_index_statistics.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024io_global_by_file_by_bytes.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024io_global_by_file_by_bytes.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/user_summary.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/user_summary.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/io_global_by_file_by_latency.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/io_global_by_file_by_latency.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/schema_table_statistics.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/schema_table_statistics.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024io_global_by_file_by_latency.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024io_global_by_file_by_latency.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024user_summary.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024user_summary.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/io_global_by_wait_by_bytes.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/io_global_by_wait_by_bytes.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024schema_table_statistics.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024schema_table_statistics.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024io_global_by_wait_by_bytes.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024io_global_by_wait_by_bytes.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/host_summary_by_file_io_type.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/host_summary_by_file_io_type.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/io_global_by_wait_by_latency.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/io_global_by_wait_by_latency.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/schema_table_statistics_with_buffer.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/schema_table_statistics_with_buffer.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024io_global_by_wait_by_latency.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024io_global_by_wait_by_latency.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/host_summary_by_file_io.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/host_summary_by_file_io.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/memory_by_user_by_current_bytes.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/memory_by_user_by_current_bytes.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/schema_table_lock_waits.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/schema_table_lock_waits.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024memory_by_user_by_current_bytes.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024memory_by_user_by_current_bytes.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024host_summary_by_file_io.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024host_summary_by_file_io.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/memory_by_host_by_current_bytes.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/memory_by_host_by_current_bytes.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024schema_table_lock_waits.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024schema_table_lock_waits.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024memory_by_host_by_current_bytes.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024memory_by_host_by_current_bytes.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/statement_analysis.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/statement_analysis.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/memory_by_thread_by_current_bytes.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/memory_by_thread_by_current_bytes.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024statement_analysis.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024statement_analysis.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024memory_by_thread_by_current_bytes.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024memory_by_thread_by_current_bytes.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/host_summary_by_statement_type.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/host_summary_by_statement_type.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/memory_global_by_current_bytes.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/memory_global_by_current_bytes.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/statements_with_errors_or_warnings.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/statements_with_errors_or_warnings.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024memory_global_by_current_bytes.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024memory_global_by_current_bytes.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/metrics.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/metrics.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/memory_global_total.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/memory_global_total.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/host_summary_by_stages.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/host_summary_by_stages.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024memory_global_total.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024memory_global_total.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/session.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/session.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024schema_table_statistics_with_buffer.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024schema_table_statistics_with_buffer.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024statements_with_errors_or_warnings.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024statements_with_errors_or_warnings.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/schema_tables_with_full_table_scans.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/schema_tables_with_full_table_scans.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/schema_unused_indexes.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/schema_unused_indexes.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024schema_tables_with_full_table_scans.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024schema_tables_with_full_table_scans.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024host_summary_by_stages.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024host_summary_by_stages.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024statements_with_full_table_scans.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024statements_with_full_table_scans.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024ps_digest_avg_latency_distribution.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024ps_digest_avg_latency_distribution.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024ps_digest_95th_percentile_by_avg_us.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024ps_digest_95th_percentile_by_avg_us.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/statements_with_runtimes_in_95th_percentile.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/statements_with_runtimes_in_95th_percentile.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024statements_with_runtimes_in_95th_percentile.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024statements_with_runtimes_in_95th_percentile.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024statements_with_temp_tables.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024statements_with_temp_tables.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024user_summary_by_file_io_type.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024user_summary_by_file_io_type.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024user_summary_by_statement_type.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024user_summary_by_statement_type.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/user_summary_by_statement_latency.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/user_summary_by_statement_latency.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024user_summary_by_statement_latency.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024user_summary_by_statement_latency.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024host_summary_by_file_io_type.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024host_summary_by_file_io_type.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024host_summary_by_statement_type.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024host_summary_by_statement_type.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/host_summary_by_statement_latency.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/host_summary_by_statement_latency.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024host_summary_by_statement_latency.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024host_summary_by_statement_latency.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/wait_classes_global_by_avg_latency.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/wait_classes_global_by_avg_latency.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024wait_classes_global_by_avg_latency.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024wait_classes_global_by_avg_latency.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/wait_classes_global_by_latency.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/wait_classes_global_by_latency.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024wait_classes_global_by_latency.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024wait_classes_global_by_latency.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024waits_by_user_by_latency.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024waits_by_user_by_latency.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024waits_by_host_by_latency.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024waits_by_host_by_latency.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024waits_global_by_latency.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024waits_global_by_latency.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024processlist.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024processlist.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/x@0024session.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/x@0024session.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./sys/session_ssl_status.frm to /mysql-backup/3306/2021-01-13_21-46-41/sys/session_ssl_status.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./customer_db/db.opt to /mysql-backup/3306/2021-01-13_21-46-41/customer_db/db.opt.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./customer_db/product_brand_info.frm to /mysql-backup/3306/2021-01-13_21-46-41/customer_db/product_brand_info.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./customer_db/product_category.frm to /mysql-backup/3306/2021-01-13_21-46-41/customer_db/product_category.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./customer_db/product_comment.frm to /mysql-backup/3306/2021-01-13_21-46-41/customer_db/product_comment.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./customer_db/product_info.frm to /mysql-backup/3306/2021-01-13_21-46-41/customer_db/product_info.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./customer_db/product_pic_info.frm to /mysql-backup/3306/2021-01-13_21-46-41/customer_db/product_pic_info.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./customer_db/product_supplier_info.frm to /mysql-backup/3306/2021-01-13_21-46-41/customer_db/product_supplier_info.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./customer_db/serial.frm to /mysql-backup/3306/2021-01-13_21-46-41/customer_db/serial.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./customer_db/customer_balance_log.frm to /mysql-backup/3306/2021-01-13_21-46-41/customer_db/customer_balance_log.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./customer_db/customer_inf.frm to /mysql-backup/3306/2021-01-13_21-46-41/customer_db/customer_inf.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./customer_db/customer_login.frm to /mysql-backup/3306/2021-01-13_21-46-41/customer_db/customer_login.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./customer_db/customer_login_log.frm to /mysql-backup/3306/2021-01-13_21-46-41/customer_db/customer_login_log.frm.qp
210113 21:46:49 [01]        ...done
210113 21:46:49 [01] Compressing ./customer_db/customer_point_log.frm to /mysql-backup/3306/2021-01-13_21-46-41/customer_db/customer_point_log.frm.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./customer_db/order_cart.frm to /mysql-backup/3306/2021-01-13_21-46-41/customer_db/order_cart.frm.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./customer_db/order_customer_addr.frm to /mysql-backup/3306/2021-01-13_21-46-41/customer_db/order_customer_addr.frm.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./customer_db/order_detail.frm to /mysql-backup/3306/2021-01-13_21-46-41/customer_db/order_detail.frm.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./customer_db/order_master.frm to /mysql-backup/3306/2021-01-13_21-46-41/customer_db/order_master.frm.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./customer_db/region_info.frm to /mysql-backup/3306/2021-01-13_21-46-41/customer_db/region_info.frm.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./customer_db/shipping_info.frm to /mysql-backup/3306/2021-01-13_21-46-41/customer_db/shipping_info.frm.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./customer_db/warehouse_info.frm to /mysql-backup/3306/2021-01-13_21-46-41/customer_db/warehouse_info.frm.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./customer_db/warehouse_proudct.frm to /mysql-backup/3306/2021-01-13_21-46-41/customer_db/warehouse_proudct.frm.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./test/db.opt to /mysql-backup/3306/2021-01-13_21-46-41/test/db.opt.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./test/test_order.frm to /mysql-backup/3306/2021-01-13_21-46-41/test/test_order.frm.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./test/test_orderdetail.frm to /mysql-backup/3306/2021-01-13_21-46-41/test/test_orderdetail.frm.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./test/checksums.frm to /mysql-backup/3306/2021-01-13_21-46-41/test/checksums.frm.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 >> log scanned up to (2377883047)
210113 21:46:50 [01] Compressing ./sakila/db.opt to /mysql-backup/3306/2021-01-13_21-46-41/sakila/db.opt.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./sakila/actor.frm to /mysql-backup/3306/2021-01-13_21-46-41/sakila/actor.frm.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./sakila/address.frm to /mysql-backup/3306/2021-01-13_21-46-41/sakila/address.frm.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./sakila/category.frm to /mysql-backup/3306/2021-01-13_21-46-41/sakila/category.frm.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./sakila/city.frm to /mysql-backup/3306/2021-01-13_21-46-41/sakila/city.frm.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./sakila/country.frm to /mysql-backup/3306/2021-01-13_21-46-41/sakila/country.frm.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./sakila/customer.frm to /mysql-backup/3306/2021-01-13_21-46-41/sakila/customer.frm.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./sakila/film.frm to /mysql-backup/3306/2021-01-13_21-46-41/sakila/film.frm.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./sakila/film_actor.frm to /mysql-backup/3306/2021-01-13_21-46-41/sakila/film_actor.frm.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./sakila/film_category.frm to /mysql-backup/3306/2021-01-13_21-46-41/sakila/film_category.frm.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./sakila/film_text.frm to /mysql-backup/3306/2021-01-13_21-46-41/sakila/film_text.frm.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./sakila/ins_film.TRN to /mysql-backup/3306/2021-01-13_21-46-41/sakila/ins_film.TRN.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./sakila/film.TRG to /mysql-backup/3306/2021-01-13_21-46-41/sakila/film.TRG.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./sakila/upd_film.TRN to /mysql-backup/3306/2021-01-13_21-46-41/sakila/upd_film.TRN.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./sakila/del_film.TRN to /mysql-backup/3306/2021-01-13_21-46-41/sakila/del_film.TRN.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./sakila/inventory.frm to /mysql-backup/3306/2021-01-13_21-46-41/sakila/inventory.frm.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./sakila/language.frm to /mysql-backup/3306/2021-01-13_21-46-41/sakila/language.frm.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./sakila/payment.frm to /mysql-backup/3306/2021-01-13_21-46-41/sakila/payment.frm.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./sakila/rental.frm to /mysql-backup/3306/2021-01-13_21-46-41/sakila/rental.frm.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./sakila/staff.frm to /mysql-backup/3306/2021-01-13_21-46-41/sakila/staff.frm.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./sakila/store.frm to /mysql-backup/3306/2021-01-13_21-46-41/sakila/store.frm.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./sakila/customer_list.frm to /mysql-backup/3306/2021-01-13_21-46-41/sakila/customer_list.frm.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./sakila/film_list.frm to /mysql-backup/3306/2021-01-13_21-46-41/sakila/film_list.frm.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./sakila/nicer_but_slower_film_list.frm to /mysql-backup/3306/2021-01-13_21-46-41/sakila/nicer_but_slower_film_list.frm.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./sakila/staff_list.frm to /mysql-backup/3306/2021-01-13_21-46-41/sakila/staff_list.frm.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./sakila/sales_by_store.frm to /mysql-backup/3306/2021-01-13_21-46-41/sakila/sales_by_store.frm.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./sakila/sales_by_film_category.frm to /mysql-backup/3306/2021-01-13_21-46-41/sakila/sales_by_film_category.frm.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./sakila/actor_info.frm to /mysql-backup/3306/2021-01-13_21-46-41/sakila/actor_info.frm.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./sakila/customer_create_date.TRN to /mysql-backup/3306/2021-01-13_21-46-41/sakila/customer_create_date.TRN.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./sakila/customer.TRG to /mysql-backup/3306/2021-01-13_21-46-41/sakila/customer.TRG.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./sakila/payment_date.TRN to /mysql-backup/3306/2021-01-13_21-46-41/sakila/payment_date.TRN.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./sakila/payment.TRG to /mysql-backup/3306/2021-01-13_21-46-41/sakila/payment.TRG.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./sakila/rental_date.TRN to /mysql-backup/3306/2021-01-13_21-46-41/sakila/rental_date.TRN.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./sakila/rental.TRG to /mysql-backup/3306/2021-01-13_21-46-41/sakila/rental.TRG.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./sbtest/db.opt to /mysql-backup/3306/2021-01-13_21-46-41/sbtest/db.opt.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./sbtest/sbtest1.MYI to /mysql-backup/3306/2021-01-13_21-46-41/sbtest/sbtest1.MYI.qp
210113 21:46:50 [01]        ...done
210113 21:46:50 [01] Compressing ./sbtest/sbtest1.MYD to /mysql-backup/3306/2021-01-13_21-46-41/sbtest/sbtest1.MYD.qp
210113 21:46:51 >> log scanned up to (2377883047)
210113 21:46:52 >> log scanned up to (2377883047)
210113 21:46:53 >> log scanned up to (2377883047)
210113 21:46:54 >> log scanned up to (2377883047)
210113 21:46:55 >> log scanned up to (2377883047)
210113 21:46:56 >> log scanned up to (2377883047)
210113 21:46:57 >> log scanned up to (2377883047)
210113 21:46:58 >> log scanned up to (2377883047)
210113 21:46:59 >> log scanned up to (2377883047)
210113 21:47:00 >> log scanned up to (2377883047)
210113 21:47:01 >> log scanned up to (2377883047)
210113 21:47:02 >> log scanned up to (2377883047)
210113 21:47:03 >> log scanned up to (2377883047)
210113 21:47:04 >> log scanned up to (2377883047)
210113 21:47:04 [01]        ...done
210113 21:47:04 [01] Compressing ./sbtest/sbtest1.frm to /mysql-backup/3306/2021-01-13_21-46-41/sbtest/sbtest1.frm.qp
210113 21:47:05 [01]        ...done
210113 21:47:05 [01] Compressing ./check_sum/db.opt to /mysql-backup/3306/2021-01-13_21-46-41/check_sum/db.opt.qp
210113 21:47:05 [01]        ...done
210113 21:47:05 [01] Compressing ./check_sum/test1.frm to /mysql-backup/3306/2021-01-13_21-46-41/check_sum/test1.frm.qp
210113 21:47:05 [01]        ...done
210113 21:47:05 Finished backing up non-InnoDB tables and files
210113 21:47:05 [00] Compressing xtrabackup_binlog_info
210113 21:47:05 [00]        ...done
210113 21:47:05 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
xtrabackup: The latest check point (for incremental): '2377883038'
xtrabackup: Stopping log copying thread.
.210113 21:47:05 >> log scanned up to (2377883047)
210113 21:47:05 Backup created in directory '/mysql-backup/3306/2021-01-13_21-46-41/'
MySQL binlog position: filename 'log-bin.000018', position '152767204', GTID of the last change '6c26c068-a952-11ea-ac80-000c29407201:1-669,
6c26c068-a952-11ea-ac80-000c29407202:1-611,
6c26c068-a952-11ea-ac80-000c29407203:1-2110'
210113 21:47:05 [00] Compressing backup-my.cnf
210113 21:47:05 [00]        ...done
210113 21:47:05 [00] Compressing xtrabackup_info
210113 21:47:05 [00]        ...done
xtrabackup: Transaction log of lsn (2377883038) to (2377883047) was copied.
210113 21:47:05 completed OK!
 
 
在Slave上备份
[root@MHA-Slave-202 ~]# innobackupex --defaults-file=/etc/my.cnf --host=127.0.0.1  --user=xtrabackup --password=123456 --no-lock --use-memory=2G --slave-info --safe-slave-backup /mysql-backup/3306
 
 
# 压缩打包方式 
[root@test206 scripts]# innobackupex --defaults-file=/etc/my.cnf --user=xtrabackup --password=123456 --no-lock --use-memory=2G --slave-info --safe-slave-backup --compress --compress-threads=4 --stream=xbstream --parallel=4  /mysql-backup/3306 
   
 
 
 
 
 
 
 
 
 
 
 
 
 
[root@MHA-Master-201 bin]#
创建时间:2021-12-22 09:05
浏览量:0