xtrackup备份测试
实验环境
k8s环境参考: k8s-v1.20.10 二进制部署指导文档
测试原因
由于之前本人在网上查找k8s部署MySQL主从的时候,很多博客文章都在statefulset中有如下类型的逻辑判断,认为xtrackup备份出来的文件有xtrabackup_binlog_info而没有xtrabackup_slave_info,这种情况属于备份Master节点
,既有xtrabackup_binlog_info又有xtrabackup_slave_info属于备份Slave节点
,在后续测试中发现并不是如此,实际上是xtrabackup备份Master、Slave这二个文件都有,不同的是备份Slave文件时,如果加了--slave-info参数,该文件内容类似这样:CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000003', MASTER_LOG_POS=154;
command:
- bash
- "-c"
- |
set -ex
cd /var/lib/mysql # 要先进到这个目录,否则xbk后续流式传输时会报错
# xtrabackup备份后会生成一个文件,有两种情况,xtrabackup_slave_info和xtrabackup_binlog_info
# 如果不是Master节点,xtrabackup_slave_info是记录了信息的,例如:CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000003', MASTER_LOG_POS=437;
if [[ -f xtrabackup_slave_info ]];then
# xtrabackup_slave_info存在则表示这个备份来自一个从节点,文件包含change master to sql语句,将这个文件改为change_master_to.sql.in
cat xtrabackup_slave_info | sed -E 's/;$//g' > change_master_to.sql.in
rm -f xtrabackup_slave_info
elif [[ -f xtrabackup_binlog_info ]];then
# 如果只存在xtrabackup_binlog_info文件则备份来自主节点,这个文件包含了bin-log文件名和position偏移量,需要我们自己解析成change master to sql
# 使用正则解析获取binlog信息,并生成change master to sql
[[ `cat xtrabackup_binlog_info` =~ ^(.*?)[[:space:]]+([0-9]+)$ ]] || exit 1
echo "CHANGE MASTER TO MASTER_LOG_FILE='${BASH_REMATCH[1]}', MASTER_LOG_POS=${BASH_REMATCH[2]}" > change_master_to.sql.in
# 删除xtrabackup_binlog_info,防止下一次没有经过备份时,重复生成change_master_to.sql.in
rm -f xtrabackup_binlog_info
fi
# 判断initcontainer是否进行了备份,如果进行了备份会经过我们上面的逻辑生成change_master_to.sql.in,如果存在change_master_to.sql.in,则需要执行相应的sql
if [[ -f change_master_to.sql.in ]];then
# 等待mysql容器启动
echo 'Waiting for mysqld to be ready (accept connections)'
until mysql -h 127.0.0.1 -e 'select 1';do sleep 1;done
sleep 5
echo 'Initializing replication from clone position'
# 执行change master sql
sql="$(<change_master_to.sql.in), master_host='mysql-0.mysql', master_user='root', master_password='', master_connect_retry=10; start slave;"
mysql -h 127.0.0.1 -e "$sql" || exit 1
# 重命名change_master_to.sql.in文件,防止重复执行change master
mv change_master_to.sql.in change_master_to.sql.in.orig
fi
# 使用ncat监听3307端口,在收到传输请求时会执行xtrabackup备份操作,然后传输数据给请求数据的节点
# 使用exec将ncat作为常驻进程,决定这个容器的生命周期
exec ncat --listen --keep-open --send-only --max-conns=1 3307 -c "xtrabackup --backup --slave-info --stream=xbstream --host=127.0.0.1 --user=root"
搭建测试Pod
[root@k8s-master-1 MySQL]# cat test.yaml
apiVersion: v1
kind: ConfigMap
metadata:
name: mysql-test
data:
mysql-1: |
[mysqld]
log_bin=mysql-bin #写文件名,默认是以/var/lib/mysql为路径
server_id=1
mysql-2: |
[mysqld]
log_bin=mysql-bin
server_id=2
---
apiVersion: v1
kind: Pod
metadata:
name: mysql-1
spec:
containers:
- name: mysql-1
image: registry.cn-hangzhou.aliyuncs.com/jiayu-kubernetes/mysql:5.7.36
imagePullPolicy: IfNotPresent
ports:
- containerPort: 3306
env:
- name: MYSQL_ROOT_PASSWORD
value: "password"
volumeMounts:
- name: config-volume
mountPath: /etc/mysql/my.cnf
subPath: mysql-1
volumes:
- name: config-volume
configMap:
name: mysql-test
---
apiVersion: v1
kind: Pod
metadata:
name: mysql-2
spec:
containers:
- name: mysql-2
image: registry.cn-hangzhou.aliyuncs.com/jiayu-kubernetes/mysql:5.7.36
imagePullPolicy: IfNotPresent
ports:
- containerPort: 3306
env:
- name: MYSQL_ROOT_PASSWORD
value: "password"
volumeMounts:
- name: config-volume
mountPath: /etc/mysql/my.cnf
subPath: mysql-1
volumes:
- name: config-volume
configMap:
name: mysql-test
---
apiVersion: v1
kind: Pod
metadata:
name: "xtrabackup"
spec:
containers:
- name: "xtrabackup"
image: registry.cn-hangzhou.aliyuncs.com/jiayu-kubernetes/xtrabackup:v2.4.24
command: ["/bin/bash","-c","sleep 8640000"]
[root@k8s-master-1 MySQL]# kubectl get pods
NAME READY STATUS RESTARTS AGE
mysql-1 1/1 Running 0 2m30s
mysql-2 1/1 Running 0 2m30s
xtrabackup 1/1 Running 0 2m30s
搭建MySQL主从
# 查看pod ip
[root@k8s-master-1 MySQL]# kubectl get pods -o wide
NAME READY STATUS RESTARTS AGE IP NODE NOMINATED NODE READINESS GATES
mysql-1 1/1 Running 0 11m 10.70.2.25 k8s-node-1 <none> <none>
mysql-2 1/1 Running 0 11m 10.70.2.26 k8s-node-1 <none> <none>
xtrabackup 1/1 Running 0 11m 10.70.2.27 k8s-node-1 <none> <none>
# 查看 mysql-1 binglog信息
[root@k8s-master-1 MySQL]# kubectl exec -it mysql-1 -- mysql -uroot -ppassword -e 'show master status;'
mysql: [Warning] Using a password on the command line interface can be insecure.
+------------------+----------+--------------+------------------+-------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------+----------+--------------+------------------+-------------------+
| mysql-bin.000003 | 154 | | | |
+------------------+----------+--------------+------------------+-------------------+
# mysql-1 创建repl 同步账号
[root@k8s-master-1 MySQL]# kubectl exec -it mysql-1 -- mysql -uroot -ppassword -e "grant replication slave on *.* to repl@'%' identified by 'password';"
mysql: [Warning] Using a password on the command line interface can be insecure.
# mysql-2同步mysql-1数据,可以发现mysql-2已经同步mysql-1的数据了
[root@k8s-master-1 MySQL]# kubectl exec -it mysql-2 -- mysql -uroot -ppassword -e "CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000003',MASTER_LOG_POS=154,MASTER_HOST='10.70.2.25',MASTER_PORT=3306,MASTER_USER='repl',MASTER_PASSWORD='password',MASTER_CONNECT_RETRY=10; start slave; show slave status\G"
mysql: [Warning] Using a password on the command line interface can be insecure.
*************************** 1. row ***************************
Slave_IO_State: Connecting to master
Master_Host: 10.70.2.25
Master_User: repl
Master_Port: 3306
Connect_Retry: 10
Master_Log_File: mysql-bin.000003
Read_Master_Log_Pos: 154
Relay_Log_File: mysql-2-relay-bin.000001
Relay_Log_Pos: 4
Relay_Master_Log_File: mysql-bin.000003
Slave_IO_Running: Connecting
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 154
Relay_Log_Space: 154
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 1
Master_UUID:
Master_Info_File: /var/lib/mysql/master.info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates
Master_Retry_Count: 86400
Master_Bind:
Last_IO_Error_Timestamp:
Last_SQL_Error_Timestamp:
Master_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set:
Executed_Gtid_Set:
Auto_Position: 0
Replicate_Rewrite_DB:
Channel_Name:
Master_TLS_Version:
xtrabackup备份
由于我自制xtrabackup镜像在远程备份的时候,报错了,后续我在mysql-1,mysql-2安装xtrabackup上测试的
# xtrabackup 备份mysql-1,由于xtrabackup不知道什么原因,有问题,这里只说下测试结果
root@mysql-1:/tmp/mysql# xtrabackup --backup --slave-info --host=127.0.0.1 --user=root --password=password --target-dir=/tmp/mysql
root@mysql-1:/tmp/mysql# ls
backup-my.cnf ibdata1 performance_schema xtrabackup_binlog_info xtrabackup_info xtrabackup_slave_info
ib_buffer_pool mysql sys xtrabackup_checkpoints xtrabackup_logfile
# 可以发现xtrabackup_slave文件信息为空,和之前测试一样,所以statefulset中command判断逻辑需要改
root@mysql-1:/tmp/mysql# cat xtrabackup_slave_info
root@mysql-1:/tmp/mysql#
# xtrabackup 备份mysql-2
root@mysql-2:/tmp/mysql# xtrabackup --backup --slave-info --host=127.0.0.1 --user=root --password=password --target-dir=/tmp/mysql
root@mysql-2:/tmp/mysql# ls
backup-my.cnf ibdata1 performance_schema xtrabackup_binlog_info xtrabackup_info xtrabackup_slave_info
ib_buffer_pool mysql sys xtrabackup_checkpoints xtrabackup_logfile
# 可以发现xtrabackup_slave_info中含有数据了,后续节点根据这里的信息去同步Master节点即可
root@mysql-2:/tmp/mysql# cat xtrabackup_slave_info
CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000003', MASTER_LOG_POS=154;
改良版
因为xtrabackup没法远程备份数据库,他要读取本地数据库文件
[root@k8s-master-1 MySQL]# cat test.yaml
apiVersion: v1
kind: ConfigMap
metadata:
name: mysql-test
data:
mysql-1: |
[mysqld]
log_bin=mysql-bin #写文件名,默认是以/var/lib/mysql为路径
server_id=1
mysql-2: |
[mysqld]
log_bin=mysql-bin
server_id=2
---
apiVersion: v1
kind: Pod
metadata:
name: mysql-1
spec:
containers:
- name: mysql-1
image: registry.cn-hangzhou.aliyuncs.com/jiayu-kubernetes/mysql:5.7.36
imagePullPolicy: IfNotPresent
ports:
- containerPort: 3306
env:
- name: MYSQL_ROOT_PASSWORD
value: "password"
volumeMounts:
- name: config-volume
mountPath: /etc/mysql/my.cnf
subPath: mysql-1
volumes:
- name: config-volume
configMap:
name: mysql-test
---
apiVersion: v1
kind: Pod
metadata:
name: mysql-2
spec:
containers:
- name: mysql-2
image: registry.cn-hangzhou.aliyuncs.com/jiayu-kubernetes/mysql:5.7.36
imagePullPolicy: IfNotPresent
ports:
- containerPort: 3306
env:
- name: MYSQL_ROOT_PASSWORD
value: "password"
volumeMounts:
- name: config-volume
mountPath: /etc/mysql/my.cnf
subPath: mysql-1
- name: mysql-data
mountPath: /var/lib/mysql
- name: "xtrabackup"
image: registry.cn-hangzhou.aliyuncs.com/jiayu-kubernetes/xtrabackup:v2.4.24
command: ["/bin/bash","-c","sleep 8640000"]
volumeMounts:
- name: mysql-data
mountPath: /var/lib/mysql
volumes:
- name: config-volume
configMap:
name: mysql-test
- name: mysql-data
emptyDir: {}
备份
[root@k8s-master-1 MySQL]# kubectl exec -it mysql-2 -c xtrabackup -- /bin/bash
[root@mysql-2 /]# xtrabackup --backup --slave-info --host=127.0.0.1 --user=root --password=password --target-dir=/tmp/mysql
xtrabackup: recognized server arguments: --datadir=/var/lib/mysql
xtrabackup: recognized client arguments: --backup=1 --slave-info=1 --host=127.0.0.1 --user=root --password=* --target-dir=/tmp/mysql
xtrabackup: perl binary not found. Skipping the version check
211118 12:15:06 Connecting to MySQL server host: 127.0.0.1, user: root, password: set, port: not set, socket: not set
Using server version 5.7.36-log
xtrabackup version 2.4.24 based on MySQL server 5.7.35 Linux (x86_64) (revision id: b4ee263)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /var/lib/mysql
xtrabackup: open files limit requested 0, set to 1048576
xtrabackup: using the following InnoDB configuration:
xtrabackup: innodb_data_home_dir = .
xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend
xtrabackup: innodb_log_group_home_dir = ./
xtrabackup: innodb_log_files_in_group = 2
xtrabackup: innodb_log_file_size = 50331648
InnoDB: Number of pools: 1
211118 12:15:06 >> log scanned up to (12660308)
xtrabackup: Generating a list of tablespaces
InnoDB: Allocated tablespace ID 2 for mysql/plugin, old maximum was 0
211118 12:15:06 [01] Copying ./ibdata1 to /tmp/mysql/ibdata1
211118 12:15:06 [01] ...done
211118 12:15:06 [01] Copying ./mysql/plugin.ibd to /tmp/mysql/mysql/plugin.ibd
211118 12:15:06 [01] ...done
211118 12:15:06 [01] Copying ./mysql/servers.ibd to /tmp/mysql/mysql/servers.ibd
211118 12:15:06 [01] ...done
211118 12:15:06 [01] Copying ./mysql/help_topic.ibd to /tmp/mysql/mysql/help_topic.ibd
211118 12:15:06 [01] ...done
211118 12:15:06 [01] Copying ./mysql/help_category.ibd to /tmp/mysql/mysql/help_category.ibd
211118 12:15:06 [01] ...done
211118 12:15:06 [01] Copying ./mysql/help_relation.ibd to /tmp/mysql/mysql/help_relation.ibd
211118 12:15:06 [01] ...done
211118 12:15:06 [01] Copying ./mysql/help_keyword.ibd to /tmp/mysql/mysql/help_keyword.ibd
211118 12:15:06 [01] ...done
211118 12:15:06 [01] Copying ./mysql/time_zone_name.ibd to /tmp/mysql/mysql/time_zone_name.ibd
211118 12:15:06 [01] ...done
211118 12:15:06 [01] Copying ./mysql/time_zone.ibd to /tmp/mysql/mysql/time_zone.ibd
211118 12:15:06 [01] ...done
211118 12:15:06 [01] Copying ./mysql/time_zone_transition.ibd to /tmp/mysql/mysql/time_zone_transition.ibd
211118 12:15:06 [01] ...done
211118 12:15:06 [01] Copying ./mysql/time_zone_transition_type.ibd to /tmp/mysql/mysql/time_zone_transition_type.ibd
211118 12:15:06 [01] ...done
211118 12:15:06 [01] Copying ./mysql/time_zone_leap_second.ibd to /tmp/mysql/mysql/time_zone_leap_second.ibd
211118 12:15:06 [01] ...done
211118 12:15:06 [01] Copying ./mysql/innodb_table_stats.ibd to /tmp/mysql/mysql/innodb_table_stats.ibd
211118 12:15:06 [01] ...done
211118 12:15:06 [01] Copying ./mysql/innodb_index_stats.ibd to /tmp/mysql/mysql/innodb_index_stats.ibd
211118 12:15:06 [01] ...done
211118 12:15:06 [01] Copying ./mysql/slave_relay_log_info.ibd to /tmp/mysql/mysql/slave_relay_log_info.ibd
211118 12:15:06 [01] ...done
211118 12:15:06 [01] Copying ./mysql/slave_master_info.ibd to /tmp/mysql/mysql/slave_master_info.ibd
211118 12:15:06 [01] ...done
211118 12:15:06 [01] Copying ./mysql/slave_worker_info.ibd to /tmp/mysql/mysql/slave_worker_info.ibd
211118 12:15:06 [01] ...done
211118 12:15:06 [01] Copying ./mysql/gtid_executed.ibd to /tmp/mysql/mysql/gtid_executed.ibd
211118 12:15:06 [01] ...done
211118 12:15:06 [01] Copying ./mysql/server_cost.ibd to /tmp/mysql/mysql/server_cost.ibd
211118 12:15:06 [01] ...done
211118 12:15:06 [01] Copying ./mysql/engine_cost.ibd to /tmp/mysql/mysql/engine_cost.ibd
211118 12:15:06 [01] ...done
211118 12:15:06 [01] Copying ./sys/sys_config.ibd to /tmp/mysql/sys/sys_config.ibd
211118 12:15:06 [01] ...done
211118 12:15:07 >> log scanned up to (12660308)
211118 12:15:07 Executing FLUSH NO_WRITE_TO_BINLOG TABLES...
211118 12:15:07 Executing FLUSH TABLES WITH READ LOCK...
211118 12:15:07 Starting to backup non-InnoDB tables and files
211118 12:15:07 [01] Copying ./mysql/db.opt to /tmp/mysql/mysql/db.opt
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/db.frm to /tmp/mysql/mysql/db.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/db.MYI to /tmp/mysql/mysql/db.MYI
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/db.MYD to /tmp/mysql/mysql/db.MYD
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/user.frm to /tmp/mysql/mysql/user.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/user.MYI to /tmp/mysql/mysql/user.MYI
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/user.MYD to /tmp/mysql/mysql/user.MYD
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/func.frm to /tmp/mysql/mysql/func.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/func.MYI to /tmp/mysql/mysql/func.MYI
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/func.MYD to /tmp/mysql/mysql/func.MYD
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/plugin.frm to /tmp/mysql/mysql/plugin.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/servers.frm to /tmp/mysql/mysql/servers.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/tables_priv.frm to /tmp/mysql/mysql/tables_priv.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/tables_priv.MYI to /tmp/mysql/mysql/tables_priv.MYI
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/tables_priv.MYD to /tmp/mysql/mysql/tables_priv.MYD
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/columns_priv.frm to /tmp/mysql/mysql/columns_priv.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/columns_priv.MYI to /tmp/mysql/mysql/columns_priv.MYI
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/columns_priv.MYD to /tmp/mysql/mysql/columns_priv.MYD
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/help_topic.frm to /tmp/mysql/mysql/help_topic.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/help_category.frm to /tmp/mysql/mysql/help_category.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/help_relation.frm to /tmp/mysql/mysql/help_relation.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/help_keyword.frm to /tmp/mysql/mysql/help_keyword.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/time_zone_name.frm to /tmp/mysql/mysql/time_zone_name.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/time_zone.frm to /tmp/mysql/mysql/time_zone.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/time_zone_transition.frm to /tmp/mysql/mysql/time_zone_transition.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/time_zone_transition_type.frm to /tmp/mysql/mysql/time_zone_transition_type.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/time_zone_leap_second.frm to /tmp/mysql/mysql/time_zone_leap_second.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/proc.frm to /tmp/mysql/mysql/proc.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/proc.MYI to /tmp/mysql/mysql/proc.MYI
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/proc.MYD to /tmp/mysql/mysql/proc.MYD
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/procs_priv.frm to /tmp/mysql/mysql/procs_priv.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/procs_priv.MYI to /tmp/mysql/mysql/procs_priv.MYI
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/procs_priv.MYD to /tmp/mysql/mysql/procs_priv.MYD
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/general_log.frm to /tmp/mysql/mysql/general_log.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/general_log.CSM to /tmp/mysql/mysql/general_log.CSM
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/general_log.CSV to /tmp/mysql/mysql/general_log.CSV
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/slow_log.frm to /tmp/mysql/mysql/slow_log.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/slow_log.CSM to /tmp/mysql/mysql/slow_log.CSM
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/slow_log.CSV to /tmp/mysql/mysql/slow_log.CSV
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/event.frm to /tmp/mysql/mysql/event.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/event.MYI to /tmp/mysql/mysql/event.MYI
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/event.MYD to /tmp/mysql/mysql/event.MYD
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/ndb_binlog_index.frm to /tmp/mysql/mysql/ndb_binlog_index.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/ndb_binlog_index.MYI to /tmp/mysql/mysql/ndb_binlog_index.MYI
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/ndb_binlog_index.MYD to /tmp/mysql/mysql/ndb_binlog_index.MYD
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/innodb_table_stats.frm to /tmp/mysql/mysql/innodb_table_stats.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/innodb_index_stats.frm to /tmp/mysql/mysql/innodb_index_stats.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/slave_relay_log_info.frm to /tmp/mysql/mysql/slave_relay_log_info.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/slave_master_info.frm to /tmp/mysql/mysql/slave_master_info.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/slave_worker_info.frm to /tmp/mysql/mysql/slave_worker_info.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/gtid_executed.frm to /tmp/mysql/mysql/gtid_executed.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/server_cost.frm to /tmp/mysql/mysql/server_cost.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/engine_cost.frm to /tmp/mysql/mysql/engine_cost.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/proxies_priv.frm to /tmp/mysql/mysql/proxies_priv.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/proxies_priv.MYI to /tmp/mysql/mysql/proxies_priv.MYI
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./mysql/proxies_priv.MYD to /tmp/mysql/mysql/proxies_priv.MYD
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/db.opt to /tmp/mysql/performance_schema/db.opt
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/cond_instances.frm to /tmp/mysql/performance_schema/cond_instances.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/events_waits_current.frm to /tmp/mysql/performance_schema/events_waits_current.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/events_waits_history.frm to /tmp/mysql/performance_schema/events_waits_history.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/events_waits_history_long.frm to /tmp/mysql/performance_schema/events_waits_history_long.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/events_waits_summary_by_instance.frm to /tmp/mysql/performance_schema/events_waits_summary_by_instance.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/events_waits_summary_by_host_by_event_name.frm to /tmp/mysql/performance_schema/events_waits_summary_by_host_by_event_name.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/events_waits_summary_by_user_by_event_name.frm to /tmp/mysql/performance_schema/events_waits_summary_by_user_by_event_name.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/events_waits_summary_by_account_by_event_name.frm to /tmp/mysql/performance_schema/events_waits_summary_by_account_by_event_name.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/events_waits_summary_by_thread_by_event_name.frm to /tmp/mysql/performance_schema/events_waits_summary_by_thread_by_event_name.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/events_waits_summary_global_by_event_name.frm to /tmp/mysql/performance_schema/events_waits_summary_global_by_event_name.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/file_instances.frm to /tmp/mysql/performance_schema/file_instances.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/file_summary_by_event_name.frm to /tmp/mysql/performance_schema/file_summary_by_event_name.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/file_summary_by_instance.frm to /tmp/mysql/performance_schema/file_summary_by_instance.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/socket_instances.frm to /tmp/mysql/performance_schema/socket_instances.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/socket_summary_by_instance.frm to /tmp/mysql/performance_schema/socket_summary_by_instance.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/socket_summary_by_event_name.frm to /tmp/mysql/performance_schema/socket_summary_by_event_name.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/host_cache.frm to /tmp/mysql/performance_schema/host_cache.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/mutex_instances.frm to /tmp/mysql/performance_schema/mutex_instances.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/objects_summary_global_by_type.frm to /tmp/mysql/performance_schema/objects_summary_global_by_type.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/performance_timers.frm to /tmp/mysql/performance_schema/performance_timers.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/rwlock_instances.frm to /tmp/mysql/performance_schema/rwlock_instances.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/setup_actors.frm to /tmp/mysql/performance_schema/setup_actors.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/setup_consumers.frm to /tmp/mysql/performance_schema/setup_consumers.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/setup_instruments.frm to /tmp/mysql/performance_schema/setup_instruments.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/setup_objects.frm to /tmp/mysql/performance_schema/setup_objects.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/setup_timers.frm to /tmp/mysql/performance_schema/setup_timers.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/table_io_waits_summary_by_index_usage.frm to /tmp/mysql/performance_schema/table_io_waits_summary_by_index_usage.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/table_io_waits_summary_by_table.frm to /tmp/mysql/performance_schema/table_io_waits_summary_by_table.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/table_lock_waits_summary_by_table.frm to /tmp/mysql/performance_schema/table_lock_waits_summary_by_table.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/threads.frm to /tmp/mysql/performance_schema/threads.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/events_stages_current.frm to /tmp/mysql/performance_schema/events_stages_current.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/events_stages_history.frm to /tmp/mysql/performance_schema/events_stages_history.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/events_stages_history_long.frm to /tmp/mysql/performance_schema/events_stages_history_long.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/events_stages_summary_by_thread_by_event_name.frm to /tmp/mysql/performance_schema/events_stages_summary_by_thread_by_event_name.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/events_stages_summary_by_host_by_event_name.frm to /tmp/mysql/performance_schema/events_stages_summary_by_host_by_event_name.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/events_stages_summary_by_user_by_event_name.frm to /tmp/mysql/performance_schema/events_stages_summary_by_user_by_event_name.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/events_stages_summary_by_account_by_event_name.frm to /tmp/mysql/performance_schema/events_stages_summary_by_account_by_event_name.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/events_stages_summary_global_by_event_name.frm to /tmp/mysql/performance_schema/events_stages_summary_global_by_event_name.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/events_statements_current.frm to /tmp/mysql/performance_schema/events_statements_current.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/events_statements_history.frm to /tmp/mysql/performance_schema/events_statements_history.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/events_statements_history_long.frm to /tmp/mysql/performance_schema/events_statements_history_long.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/events_statements_summary_by_thread_by_event_name.frm to /tmp/mysql/performance_schema/events_statements_summary_by_thread_by_event_name.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/events_statements_summary_by_host_by_event_name.frm to /tmp/mysql/performance_schema/events_statements_summary_by_host_by_event_name.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/events_statements_summary_by_user_by_event_name.frm to /tmp/mysql/performance_schema/events_statements_summary_by_user_by_event_name.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/events_statements_summary_by_account_by_event_name.frm to /tmp/mysql/performance_schema/events_statements_summary_by_account_by_event_name.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/events_statements_summary_global_by_event_name.frm to /tmp/mysql/performance_schema/events_statements_summary_global_by_event_name.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/events_transactions_current.frm to /tmp/mysql/performance_schema/events_transactions_current.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/events_transactions_history.frm to /tmp/mysql/performance_schema/events_transactions_history.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/events_transactions_history_long.frm to /tmp/mysql/performance_schema/events_transactions_history_long.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/events_transactions_summary_by_thread_by_event_name.frm to /tmp/mysql/performance_schema/events_transactions_summary_by_thread_by_event_name.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/events_transactions_summary_by_host_by_event_name.frm to /tmp/mysql/performance_schema/events_transactions_summary_by_host_by_event_name.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/events_transactions_summary_by_user_by_event_name.frm to /tmp/mysql/performance_schema/events_transactions_summary_by_user_by_event_name.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/events_transactions_summary_by_account_by_event_name.frm to /tmp/mysql/performance_schema/events_transactions_summary_by_account_by_event_name.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/events_transactions_summary_global_by_event_name.frm to /tmp/mysql/performance_schema/events_transactions_summary_global_by_event_name.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/hosts.frm to /tmp/mysql/performance_schema/hosts.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/users.frm to /tmp/mysql/performance_schema/users.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/accounts.frm to /tmp/mysql/performance_schema/accounts.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/memory_summary_global_by_event_name.frm to /tmp/mysql/performance_schema/memory_summary_global_by_event_name.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/memory_summary_by_thread_by_event_name.frm to /tmp/mysql/performance_schema/memory_summary_by_thread_by_event_name.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/memory_summary_by_account_by_event_name.frm to /tmp/mysql/performance_schema/memory_summary_by_account_by_event_name.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/memory_summary_by_host_by_event_name.frm to /tmp/mysql/performance_schema/memory_summary_by_host_by_event_name.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/memory_summary_by_user_by_event_name.frm to /tmp/mysql/performance_schema/memory_summary_by_user_by_event_name.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/events_statements_summary_by_digest.frm to /tmp/mysql/performance_schema/events_statements_summary_by_digest.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/events_statements_summary_by_program.frm to /tmp/mysql/performance_schema/events_statements_summary_by_program.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/prepared_statements_instances.frm to /tmp/mysql/performance_schema/prepared_statements_instances.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/replication_connection_configuration.frm to /tmp/mysql/performance_schema/replication_connection_configuration.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/replication_group_member_stats.frm to /tmp/mysql/performance_schema/replication_group_member_stats.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/replication_group_members.frm to /tmp/mysql/performance_schema/replication_group_members.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/replication_connection_status.frm to /tmp/mysql/performance_schema/replication_connection_status.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/replication_applier_configuration.frm to /tmp/mysql/performance_schema/replication_applier_configuration.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/replication_applier_status.frm to /tmp/mysql/performance_schema/replication_applier_status.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/replication_applier_status_by_coordinator.frm to /tmp/mysql/performance_schema/replication_applier_status_by_coordinator.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/replication_applier_status_by_worker.frm to /tmp/mysql/performance_schema/replication_applier_status_by_worker.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/session_connect_attrs.frm to /tmp/mysql/performance_schema/session_connect_attrs.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/session_account_connect_attrs.frm to /tmp/mysql/performance_schema/session_account_connect_attrs.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/table_handles.frm to /tmp/mysql/performance_schema/table_handles.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/metadata_locks.frm to /tmp/mysql/performance_schema/metadata_locks.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/user_variables_by_thread.frm to /tmp/mysql/performance_schema/user_variables_by_thread.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/variables_by_thread.frm to /tmp/mysql/performance_schema/variables_by_thread.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/global_variables.frm to /tmp/mysql/performance_schema/global_variables.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/session_variables.frm to /tmp/mysql/performance_schema/session_variables.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/status_by_thread.frm to /tmp/mysql/performance_schema/status_by_thread.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/status_by_user.frm to /tmp/mysql/performance_schema/status_by_user.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/status_by_host.frm to /tmp/mysql/performance_schema/status_by_host.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/status_by_account.frm to /tmp/mysql/performance_schema/status_by_account.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/global_status.frm to /tmp/mysql/performance_schema/global_status.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./performance_schema/session_status.frm to /tmp/mysql/performance_schema/session_status.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/db.opt to /tmp/mysql/sys/db.opt
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/version.frm to /tmp/mysql/sys/version.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/sys_config.frm to /tmp/mysql/sys/sys_config.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/statements_with_full_table_scans.frm to /tmp/mysql/sys/statements_with_full_table_scans.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/sys_config_insert_set_user.TRN to /tmp/mysql/sys/sys_config_insert_set_user.TRN
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/processlist.frm to /tmp/mysql/sys/processlist.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/sys_config.TRG to /tmp/mysql/sys/sys_config.TRG
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/statements_with_sorting.frm to /tmp/mysql/sys/statements_with_sorting.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/sys_config_update_set_user.TRN to /tmp/mysql/sys/sys_config_update_set_user.TRN
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024statements_with_sorting.frm to /tmp/mysql/sys/x@0024statements_with_sorting.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/innodb_buffer_stats_by_schema.frm to /tmp/mysql/sys/innodb_buffer_stats_by_schema.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/schema_index_statistics.frm to /tmp/mysql/sys/schema_index_statistics.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024innodb_buffer_stats_by_schema.frm to /tmp/mysql/sys/x@0024innodb_buffer_stats_by_schema.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/statements_with_temp_tables.frm to /tmp/mysql/sys/statements_with_temp_tables.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/innodb_buffer_stats_by_table.frm to /tmp/mysql/sys/innodb_buffer_stats_by_table.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024ps_schema_table_statistics_io.frm to /tmp/mysql/sys/x@0024ps_schema_table_statistics_io.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024innodb_buffer_stats_by_table.frm to /tmp/mysql/sys/x@0024innodb_buffer_stats_by_table.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/host_summary.frm to /tmp/mysql/sys/host_summary.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/innodb_lock_waits.frm to /tmp/mysql/sys/innodb_lock_waits.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024host_summary.frm to /tmp/mysql/sys/x@0024host_summary.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024innodb_lock_waits.frm to /tmp/mysql/sys/x@0024innodb_lock_waits.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/waits_by_user_by_latency.frm to /tmp/mysql/sys/waits_by_user_by_latency.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/schema_object_overview.frm to /tmp/mysql/sys/schema_object_overview.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/user_summary_by_file_io_type.frm to /tmp/mysql/sys/user_summary_by_file_io_type.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/schema_auto_increment_columns.frm to /tmp/mysql/sys/schema_auto_increment_columns.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/user_summary_by_file_io.frm to /tmp/mysql/sys/user_summary_by_file_io.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024schema_flattened_keys.frm to /tmp/mysql/sys/x@0024schema_flattened_keys.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024user_summary_by_file_io.frm to /tmp/mysql/sys/x@0024user_summary_by_file_io.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/schema_redundant_indexes.frm to /tmp/mysql/sys/schema_redundant_indexes.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/user_summary_by_statement_type.frm to /tmp/mysql/sys/user_summary_by_statement_type.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/ps_check_lost_instrumentation.frm to /tmp/mysql/sys/ps_check_lost_instrumentation.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/latest_file_io.frm to /tmp/mysql/sys/latest_file_io.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/waits_by_host_by_latency.frm to /tmp/mysql/sys/waits_by_host_by_latency.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024latest_file_io.frm to /tmp/mysql/sys/x@0024latest_file_io.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/waits_global_by_latency.frm to /tmp/mysql/sys/waits_global_by_latency.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/io_by_thread_by_latency.frm to /tmp/mysql/sys/io_by_thread_by_latency.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/user_summary_by_stages.frm to /tmp/mysql/sys/user_summary_by_stages.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024io_by_thread_by_latency.frm to /tmp/mysql/sys/x@0024io_by_thread_by_latency.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024user_summary_by_stages.frm to /tmp/mysql/sys/x@0024user_summary_by_stages.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/io_global_by_file_by_bytes.frm to /tmp/mysql/sys/io_global_by_file_by_bytes.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024schema_index_statistics.frm to /tmp/mysql/sys/x@0024schema_index_statistics.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024io_global_by_file_by_bytes.frm to /tmp/mysql/sys/x@0024io_global_by_file_by_bytes.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/user_summary.frm to /tmp/mysql/sys/user_summary.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/io_global_by_file_by_latency.frm to /tmp/mysql/sys/io_global_by_file_by_latency.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/schema_table_statistics.frm to /tmp/mysql/sys/schema_table_statistics.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024io_global_by_file_by_latency.frm to /tmp/mysql/sys/x@0024io_global_by_file_by_latency.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024user_summary.frm to /tmp/mysql/sys/x@0024user_summary.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/io_global_by_wait_by_bytes.frm to /tmp/mysql/sys/io_global_by_wait_by_bytes.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024schema_table_statistics.frm to /tmp/mysql/sys/x@0024schema_table_statistics.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024io_global_by_wait_by_bytes.frm to /tmp/mysql/sys/x@0024io_global_by_wait_by_bytes.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/host_summary_by_file_io_type.frm to /tmp/mysql/sys/host_summary_by_file_io_type.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/io_global_by_wait_by_latency.frm to /tmp/mysql/sys/io_global_by_wait_by_latency.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/schema_table_statistics_with_buffer.frm to /tmp/mysql/sys/schema_table_statistics_with_buffer.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024io_global_by_wait_by_latency.frm to /tmp/mysql/sys/x@0024io_global_by_wait_by_latency.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/host_summary_by_file_io.frm to /tmp/mysql/sys/host_summary_by_file_io.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/memory_by_user_by_current_bytes.frm to /tmp/mysql/sys/memory_by_user_by_current_bytes.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/schema_table_lock_waits.frm to /tmp/mysql/sys/schema_table_lock_waits.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024memory_by_user_by_current_bytes.frm to /tmp/mysql/sys/x@0024memory_by_user_by_current_bytes.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024host_summary_by_file_io.frm to /tmp/mysql/sys/x@0024host_summary_by_file_io.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/memory_by_host_by_current_bytes.frm to /tmp/mysql/sys/memory_by_host_by_current_bytes.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024schema_table_lock_waits.frm to /tmp/mysql/sys/x@0024schema_table_lock_waits.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024memory_by_host_by_current_bytes.frm to /tmp/mysql/sys/x@0024memory_by_host_by_current_bytes.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/statement_analysis.frm to /tmp/mysql/sys/statement_analysis.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/memory_by_thread_by_current_bytes.frm to /tmp/mysql/sys/memory_by_thread_by_current_bytes.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024statement_analysis.frm to /tmp/mysql/sys/x@0024statement_analysis.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024memory_by_thread_by_current_bytes.frm to /tmp/mysql/sys/x@0024memory_by_thread_by_current_bytes.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/host_summary_by_statement_type.frm to /tmp/mysql/sys/host_summary_by_statement_type.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/memory_global_by_current_bytes.frm to /tmp/mysql/sys/memory_global_by_current_bytes.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/statements_with_errors_or_warnings.frm to /tmp/mysql/sys/statements_with_errors_or_warnings.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024memory_global_by_current_bytes.frm to /tmp/mysql/sys/x@0024memory_global_by_current_bytes.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/metrics.frm to /tmp/mysql/sys/metrics.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/memory_global_total.frm to /tmp/mysql/sys/memory_global_total.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/host_summary_by_stages.frm to /tmp/mysql/sys/host_summary_by_stages.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024memory_global_total.frm to /tmp/mysql/sys/x@0024memory_global_total.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/session.frm to /tmp/mysql/sys/session.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024schema_table_statistics_with_buffer.frm to /tmp/mysql/sys/x@0024schema_table_statistics_with_buffer.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024statements_with_errors_or_warnings.frm to /tmp/mysql/sys/x@0024statements_with_errors_or_warnings.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/schema_tables_with_full_table_scans.frm to /tmp/mysql/sys/schema_tables_with_full_table_scans.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/schema_unused_indexes.frm to /tmp/mysql/sys/schema_unused_indexes.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024schema_tables_with_full_table_scans.frm to /tmp/mysql/sys/x@0024schema_tables_with_full_table_scans.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024host_summary_by_stages.frm to /tmp/mysql/sys/x@0024host_summary_by_stages.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024statements_with_full_table_scans.frm to /tmp/mysql/sys/x@0024statements_with_full_table_scans.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024ps_digest_avg_latency_distribution.frm to /tmp/mysql/sys/x@0024ps_digest_avg_latency_distribution.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024ps_digest_95th_percentile_by_avg_us.frm to /tmp/mysql/sys/x@0024ps_digest_95th_percentile_by_avg_us.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/statements_with_runtimes_in_95th_percentile.frm to /tmp/mysql/sys/statements_with_runtimes_in_95th_percentile.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024statements_with_runtimes_in_95th_percentile.frm to /tmp/mysql/sys/x@0024statements_with_runtimes_in_95th_percentile.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024statements_with_temp_tables.frm to /tmp/mysql/sys/x@0024statements_with_temp_tables.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024user_summary_by_file_io_type.frm to /tmp/mysql/sys/x@0024user_summary_by_file_io_type.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024user_summary_by_statement_type.frm to /tmp/mysql/sys/x@0024user_summary_by_statement_type.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/user_summary_by_statement_latency.frm to /tmp/mysql/sys/user_summary_by_statement_latency.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024user_summary_by_statement_latency.frm to /tmp/mysql/sys/x@0024user_summary_by_statement_latency.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024host_summary_by_file_io_type.frm to /tmp/mysql/sys/x@0024host_summary_by_file_io_type.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024host_summary_by_statement_type.frm to /tmp/mysql/sys/x@0024host_summary_by_statement_type.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/host_summary_by_statement_latency.frm to /tmp/mysql/sys/host_summary_by_statement_latency.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024host_summary_by_statement_latency.frm to /tmp/mysql/sys/x@0024host_summary_by_statement_latency.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/wait_classes_global_by_avg_latency.frm to /tmp/mysql/sys/wait_classes_global_by_avg_latency.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024wait_classes_global_by_avg_latency.frm to /tmp/mysql/sys/x@0024wait_classes_global_by_avg_latency.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/wait_classes_global_by_latency.frm to /tmp/mysql/sys/wait_classes_global_by_latency.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024wait_classes_global_by_latency.frm to /tmp/mysql/sys/x@0024wait_classes_global_by_latency.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024waits_by_user_by_latency.frm to /tmp/mysql/sys/x@0024waits_by_user_by_latency.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024waits_by_host_by_latency.frm to /tmp/mysql/sys/x@0024waits_by_host_by_latency.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024waits_global_by_latency.frm to /tmp/mysql/sys/x@0024waits_global_by_latency.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024processlist.frm to /tmp/mysql/sys/x@0024processlist.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/x@0024session.frm to /tmp/mysql/sys/x@0024session.frm
211118 12:15:07 [01] ...done
211118 12:15:07 [01] Copying ./sys/session_ssl_status.frm to /tmp/mysql/sys/session_ssl_status.frm
211118 12:15:07 [01] ...done
211118 12:15:07 Finished backing up non-InnoDB tables and files
211118 12:15:07 [00] Writing /tmp/mysql/xtrabackup_slave_info
211118 12:15:07 [00] ...done
211118 12:15:07 [00] Writing /tmp/mysql/xtrabackup_binlog_info
211118 12:15:07 [00] ...done
211118 12:15:07 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
xtrabackup: The latest check point (for incremental): '12660299'
xtrabackup: Stopping log copying thread.
.211118 12:15:07 >> log scanned up to (12660308)
211118 12:15:07 Executing UNLOCK TABLES
211118 12:15:07 All tables unlocked
211118 12:15:07 [00] Copying ib_buffer_pool to /tmp/mysql/ib_buffer_pool
211118 12:15:07 [00] ...done
211118 12:15:07 Backup created in directory '/tmp/mysql/'
MySQL binlog position: filename 'mysql-bin.000003', position '154'
MySQL slave binlog position: master host '10.70.2.33', filename 'mysql-bin.000003', position '154', channel name: ''
211118 12:15:07 [00] Writing /tmp/mysql/backup-my.cnf
211118 12:15:07 [00] ...done
211118 12:15:07 [00] Writing /tmp/mysql/xtrabackup_info
211118 12:15:07 [00] ...done
xtrabackup: Transaction log of lsn (12660299) to (12660308) was copied.
211118 12:15:08 completed OK!
[root@mysql-2 /]# cd /tmp/mysql/
[root@mysql-2 mysql]# ls
backup-my.cnf ibdata1 performance_schema xtrabackup_binlog_info xtrabackup_info xtrabackup_slave_info
ib_buffer_pool mysql sys xtrabackup_checkpoints xtrabackup_logfile
[root@mysql-2 mysql]# cat xtrabackup_slave_info
CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000003', MASTER_LOG_POS=154;
[root@mysql-2 mysql]# exit