安装MySQL5.7
1、检查当前系统是否安装过mysql
[root@node3 ~]# rpm -qa |grep mariadb
mariadb-libs-5.5.52-1.el7.x86_64
# 卸载自带的mariadb
[root@node3 ~]# rpm -e --nodeps mariadb-libs
2、下载MySQL RPM包(含5.5~8版本)
下载地址：https://dev.mysql.com/downloads/repo/yum/
[root@node3 ~]# wget https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm
[root@node3 ~]# yum -y install mysql80-community-release-el7-3.noarch.rpm
[root@node3 ~]# vim /etc/yum.repos.d/mysql-community.repo
要安装5.7版本，将5.7源的enabled=0改成enabled=1。其他的enabled=1改成enabled=0即可
[root@node3 ~]# yum -y install mysql-community-server
注：如需修改存储路径，此时可打开/etc/my.cnf进行修改
[root@node3 ~]# systemctl start mysqld && systemctl enable mysqld
[root@node3 ~]# systemctl status mysqld
# [root@node3 ~]# systemctl daemon-reload
修改root本地登录密码
[root@node3 ~]# grep 'temporary password' /var/log/mysqld.log
2021-08-23T03:56:42.881779Z 1 [Note] A temporary password is generated for root@localhost: (u:vg;SjX1jf
[root@node3 ~]# mysql -uroot -p
mysql> alter user 'root'@'localhost' identified by 'Aa7788**';
# mysql> show variables like '%password%';
添加远程登录用户
mysql> grant all privileges on *.* to 'xtrabackuser'@'%' identified by 'Aa7788**' with grant option;
注意：备份时需启动MySQL,恢复时需关闭MySQL,清空mysql数据目录且不能重新初始化,恢复数据后应该立即进行一次全备
配置默认编码为utf8
[root@node3 ~]# vim /etc/my.cnf
[mysqld]
character_set_server=utf8
init_connect='SET NAMES utf8'
重新启动mysql服务，查看数据库默认编码
[root@node3 ~]# systemctl restart mysqld
[root@node3 ~]# mysql -uroot -p -e "show variables like '%character%'";
Enter password:
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
默认配置文件路径：
配置文件：/etc/my.cnf
日志文件：/var/log//var/log/mysqld.log
服务启动脚本：/usr/lib/systemd/system/mysqld.service
socket文件：/var/run/mysqld/mysqld.pid
创建测试数据库和表
[root@node3 ~]# mysql -uroot -p
mysql> create database db_book default character set utf8mb4;
mysql> use db_book;
mysql> create table t_xi(
id int primary key,
username varchar(255),
nickname varchar(255),
address varchar(255),
age int, gender varchar(255),
intro varchar(255),
seat varchar(255));
mysql> create table t_hong(
id int primary key,
username varchar(255),
nickname varchar(255),
address varchar(255),
age int, gender varchar(255),
intro varchar(255),
seat varchar(255));
mysql> create table t_shui(
id int primary key,
username varchar(255),
nickname varchar(255),
address varchar(255),
age int, gender varchar(255),
intro varchar(255),
seat varchar(255));
mysql> create table t_san(
id int primary key,
username varchar(255),
nickname varchar(255),
address varchar(255),
age int, gender varchar(255),
intro varchar(255),
seat varchar(255));
mysql> show tables;
+-------------------+
| Tables_in_db_book |
+-------------------+
| t_hong |
| t_san |
| t_shui |
| t_xi |
+-------------------+
4 rows in set (0.00 sec)
插入数据
mysql> insert into t_xi values(5,"小白龙","白龙马","东海",18,"男","能奔驰",5);
mysql> insert into t_xi values(6,"小黑","黑龙马","南海",22,"女","广汽",22);
mysql> insert into t_san values(1,"刘备","蜀汉的开国皇帝", "蜀汉",null,"男","汉最帝之子中山靖王刘胜的后代",null);
mysql> insert into t_san values(2,"张飞","五虎大将中第二位","涿邵",null,"男","少时即与关羽共事刘备",null);
mysql> insert into t_san values(3,"关羽","五虎大将中第一位","河东解县",null,"男","其后与张飞一起追随刘备。曾在汜水关前斩华雄",null);
mysql> insert into t_san vaLues(4,"赵云","五虎大将中第三位","常山真定",null,"男","以勇敢善战著称。原为公孙瓒的部下",null);
mysql> insert into t_san values(5,"黄忠","五虎大将","蜀汉",null,"男","原为韩玄手下..年近六句有万夫不当之勇",null);
mysql> insert into t_san values(6,"马超","五虎大将","后汉",null,"男","后汉征西将军马腾长子。年十七，随父腾、韩遂袭长安",null);
mysql> show tables;
+-------------------+
| Tables_in_db_book |
+-------------------+
| t_hong |
| t_san |
| t_shui |
| t_xi |
+-------------------+
mysql> select * from t_san;
XtraBackup-2.4安装设置
[root@node3 ~]# wget https://downloads.percona.com/downloads/Percona-XtraBackup-2.4/Percona-XtraBackup-2.4.23/binary/redhat/7/x86_64/Percona-XtraBackup-2.4.23-r3320f39-el7-x86_64-bundle.tar
[root@node3 ~]# tar -xvf Percona-XtraBackup-2.4.23-r3320f39-el7-x86_64-bundle.tar
[root@node3 ~]# yum -y install percona-xtrabackup-24-2.4.23-1.el7.x86_64.rpm
[root@node3 ~]# rpm -qa |grep xtrabackup
Xtrabackup中主要包含两个工具：
xtrabackup：是用于热备innodb，xtradb表中数据的工具，不能备份其他类型的表，也不能备份数据表结构；
innobackupex：是将xtrabackup进行封装的perl脚本，提供了备份myisam表的能力。
常用选项:
--host 指定主机
--user 指定用户名
--password 指定密码
--port 指定端口
--databases 指定数据库
--incremental 创建增量备份
--incremental-basedir 指定包含完全备份的目录
--incremental-dir 指定包含增量备份的目录
--apply-log 对备份进行预处理操作
一般情况下，在备份完成后，数据尚且不能用于恢复操作，因为备份的数据中可能会包含尚未提交的事务或已经提交但尚未同步至数据文件中的事务。因此，此时数据文件仍处理不一致状态。“准备”的主要作用正是通过回滚未提交的事务及同步已经提交的事务至数据文件也使得数据文件处于一致性状态。
--redo-only 不回滚未提交事务
--copy-back 恢复备份目录
使用innobackupex备份时，其会调用xtrabackup备份所有的InnoDB表，复制所有关于表结构定义的相关文件(.frm)、以及MyISAM、MERGE、CSV和ARCHIVE表的相关文件，同时还会备份触发器和数据库配置信息相关的文件，这些文件会被保存到一个以时间命名的目录当中。在备份的同时，innobackupex还会在备份目录中创建如下文件：
(1)xtrabackup_checkpoints -- 备份类型(如完全或增量)、备份状态(如是否已经为prepared状态)和LSN(日志序列号)范围信息：
每个InnoDB页(通常为16k大小)
都会包含一个日志序列号，即LSN，LSN是整个数据库系统的系统版本号，每个页面相关的LSN能够表明此页面最近是如何发生改变的。
(2)xtrabackup_binlog_info -- mysql服务器当前正在使用的二进制日志文件及备份这一刻位置二进制日志时间的位置。
(3)xtrabackup_binlog_pos_innodb -- 二进制日志文件及用于InnoDB或XtraDB表的二进制日志文件的当前position。
(4)xtrabackup_binary -- 备份中用到的xtrabackup的可执行文件；
(5)backup-my.cnf -- 备份命令用到的配置选项信息：
在使用innobackupex进行备份时，还可以使用--no-timestamp选项来阻止命令自动创建一个以时间命名的目录：如此一来，innobackupex命令将会创建一个BACKUP-DIR目录来存储备份数据。
xtrabackup全量备份与恢复
全量备份
Tips:
1、如在执行innobackupex命令时备份时出现 xtrabackup: Error: --defaults-file must be specified first on the command line 报错是因为 --defaults-file 参数必须为 innobackupex 命令后面第一个参数，如放在第三个或第四个参数位置时则会报该错误
2、如是普通用户备份则至少具备以下权限才能正常备份
mysql> grant reload,create tablespace,lock tables ,replication client,super on . to 'bakusr'@localhost;
mysql> select user,host,Reload_priv from user where user='bakusr';
[root@node3 ~]# mkdir /home/mysql_backup
[root@node3 ~]# innobackupex --defaults-file=/etc/my.cnf --user=xtrabackuser --password='Aa7788**' --socket=/var/lib/mysql/mysql.sock /home/mysql_backup/full
xtrabackup: recognized server arguments: --datadir=/var/lib/mysql
xtrabackup: recognized client arguments:
210823 03:25:18 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!".
210823 03:25:19 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;mysql_socket=/var/lib/mysql/mysql.sock' as 'xtrabackuser' (using password: YES).
Failed to connect to MySQL server as DBD::mysql module is not installed at - line 1327.
210823 03:25:19 Connecting to MySQL server host: localhost, user: xtrabackuser, password: set, port: not set, socket: /var/lib/mysql/mysql.sock
Using server version 5.7.35
innobackupex version 2.4.23 based on MySQL server 5.7.34 Linux (x86_64) (revision id: 3320f39)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /var/lib/mysql
xtrabackup: open files limit requested 0, set to 1024
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
210823 03:25:19 >> log scanned up to (2782090)
xtrabackup: Generating a list of tablespaces
InnoDB: Allocated tablespace ID 2 for mysql/plugin, old maximum was 0
210823 03:25:19 [01] Copying ./ibdata1 to /home/mysql_backup/full/2021-08-23_03-25-18/ibdata1
210823 03:25:19 [01] ...done
210823 03:25:19 [01] Copying ./mysql/plugin.ibd to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/plugin.ibd
210823 03:25:19 [01] ...done
210823 03:25:19 [01] Copying ./mysql/servers.ibd to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/servers.ibd
210823 03:25:19 [01] ...done
210823 03:25:19 [01] Copying ./mysql/help_topic.ibd to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/help_topic.ibd
210823 03:25:19 [01] ...done
210823 03:25:19 [01] Copying ./mysql/help_category.ibd to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/help_category.ibd
210823 03:25:19 [01] ...done
210823 03:25:19 [01] Copying ./mysql/help_relation.ibd to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/help_relation.ibd
210823 03:25:19 [01] ...done
210823 03:25:19 [01] Copying ./mysql/help_keyword.ibd to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/help_keyword.ibd
210823 03:25:19 [01] ...done
210823 03:25:19 [01] Copying ./mysql/time_zone_name.ibd to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/time_zone_name.ibd
210823 03:25:19 [01] ...done
210823 03:25:19 [01] Copying ./mysql/time_zone.ibd to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/time_zone.ibd
210823 03:25:19 [01] ...done
210823 03:25:19 [01] Copying ./mysql/time_zone_transition.ibd to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/time_zone_transition.ibd
210823 03:25:19 [01] ...done
210823 03:25:19 [01] Copying ./mysql/time_zone_transition_type.ibd to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/time_zone_transition_type.ibd
210823 03:25:19 [01] ...done
210823 03:25:19 [01] Copying ./mysql/time_zone_leap_second.ibd to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/time_zone_leap_second.ibd
210823 03:25:19 [01] ...done
210823 03:25:19 [01] Copying ./mysql/innodb_table_stats.ibd to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/innodb_table_stats.ibd
210823 03:25:19 [01] ...done
210823 03:25:19 [01] Copying ./mysql/innodb_index_stats.ibd to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/innodb_index_stats.ibd
210823 03:25:19 [01] ...done
210823 03:25:19 [01] Copying ./mysql/slave_relay_log_info.ibd to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/slave_relay_log_info.ibd
210823 03:25:19 [01] ...done
210823 03:25:19 [01] Copying ./mysql/slave_master_info.ibd to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/slave_master_info.ibd
210823 03:25:19 [01] ...done
210823 03:25:19 [01] Copying ./mysql/slave_worker_info.ibd to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/slave_worker_info.ibd
210823 03:25:19 [01] ...done
210823 03:25:19 [01] Copying ./mysql/gtid_executed.ibd to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/gtid_executed.ibd
210823 03:25:19 [01] ...done
210823 03:25:19 [01] Copying ./mysql/server_cost.ibd to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/server_cost.ibd
210823 03:25:19 [01] ...done
210823 03:25:19 [01] Copying ./mysql/engine_cost.ibd to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/engine_cost.ibd
210823 03:25:19 [01] ...done
210823 03:25:19 [01] Copying ./sys/sys_config.ibd to /home/mysql_backup/full/2021-08-23_03-25-18/sys/sys_config.ibd
210823 03:25:19 [01] ...done
210823 03:25:19 [01] Copying ./db_book/t_xi.ibd to /home/mysql_backup/full/2021-08-23_03-25-18/db_book/t_xi.ibd
210823 03:25:19 [01] ...done
210823 03:25:19 [01] Copying ./db_book/t_hong.ibd to /home/mysql_backup/full/2021-08-23_03-25-18/db_book/t_hong.ibd
210823 03:25:19 [01] ...done
210823 03:25:19 [01] Copying ./db_book/t_shui.ibd to /home/mysql_backup/full/2021-08-23_03-25-18/db_book/t_shui.ibd
210823 03:25:19 [01] ...done
210823 03:25:19 [01] Copying ./db_book/t_san.ibd to /home/mysql_backup/full/2021-08-23_03-25-18/db_book/t_san.ibd
210823 03:25:19 [01] ...done
210823 03:25:20 >> log scanned up to (2782090)
210823 03:25:20 Executing FLUSH NO_WRITE_TO_BINLOG TABLES...
210823 03:25:20 Executing FLUSH TABLES WITH READ LOCK...
210823 03:25:20 Starting to backup non-InnoDB tables and files
210823 03:25:20 [01] Copying ./mysql/db.opt to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/db.opt
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/db.frm to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/db.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/db.MYI to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/db.MYI
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/db.MYD to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/db.MYD
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/user.frm to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/user.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/user.MYI to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/user.MYI
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/user.MYD to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/user.MYD
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/func.frm to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/func.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/func.MYI to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/func.MYI
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/func.MYD to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/func.MYD
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/plugin.frm to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/plugin.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/servers.frm to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/servers.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/tables_priv.frm to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/tables_priv.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/tables_priv.MYI to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/tables_priv.MYI
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/tables_priv.MYD to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/tables_priv.MYD
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/columns_priv.frm to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/columns_priv.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/columns_priv.MYI to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/columns_priv.MYI
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/columns_priv.MYD to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/columns_priv.MYD
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/help_topic.frm to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/help_topic.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/help_category.frm to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/help_category.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/help_relation.frm to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/help_relation.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/help_keyword.frm to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/help_keyword.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/time_zone_name.frm to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/time_zone_name.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/time_zone.frm to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/time_zone.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/time_zone_transition.frm to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/time_zone_transition.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/time_zone_transition_type.frm to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/time_zone_transition_type.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/time_zone_leap_second.frm to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/time_zone_leap_second.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/proc.frm to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/proc.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/proc.MYI to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/proc.MYI
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/proc.MYD to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/proc.MYD
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/procs_priv.frm to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/procs_priv.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/procs_priv.MYI to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/procs_priv.MYI
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/procs_priv.MYD to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/procs_priv.MYD
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/general_log.frm to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/general_log.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/general_log.CSM to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/general_log.CSM
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/general_log.CSV to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/general_log.CSV
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/slow_log.frm to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/slow_log.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/slow_log.CSM to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/slow_log.CSM
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/slow_log.CSV to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/slow_log.CSV
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/event.frm to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/event.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/event.MYI to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/event.MYI
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/event.MYD to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/event.MYD
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/ndb_binlog_index.frm to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/ndb_binlog_index.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/ndb_binlog_index.MYI to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/ndb_binlog_index.MYI
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/ndb_binlog_index.MYD to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/ndb_binlog_index.MYD
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/innodb_table_stats.frm to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/innodb_table_stats.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/innodb_index_stats.frm to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/innodb_index_stats.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/slave_relay_log_info.frm to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/slave_relay_log_info.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/slave_master_info.frm to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/slave_master_info.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/slave_worker_info.frm to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/slave_worker_info.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/gtid_executed.frm to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/gtid_executed.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/server_cost.frm to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/server_cost.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/engine_cost.frm to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/engine_cost.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/proxies_priv.frm to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/proxies_priv.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/proxies_priv.MYI to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/proxies_priv.MYI
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./mysql/proxies_priv.MYD to /home/mysql_backup/full/2021-08-23_03-25-18/mysql/proxies_priv.MYD
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/db.opt to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/db.opt
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/cond_instances.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/cond_instances.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/events_waits_current.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/events_waits_current.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/events_waits_history.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/events_waits_history.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/events_waits_history_long.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/events_waits_history_long.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/events_waits_summary_by_instance.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/events_waits_summary_by_instance.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/events_waits_summary_by_host_by_event_name.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/events_waits_summary_by_host_by_event_name.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/events_waits_summary_by_user_by_event_name.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/events_waits_summary_by_user_by_event_name.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/events_waits_summary_by_account_by_event_name.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/events_waits_summary_by_account_by_event_name.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/events_waits_summary_by_thread_by_event_name.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/events_waits_summary_by_thread_by_event_name.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/events_waits_summary_global_by_event_name.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/events_waits_summary_global_by_event_name.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/file_instances.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/file_instances.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/file_summary_by_event_name.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/file_summary_by_event_name.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/file_summary_by_instance.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/file_summary_by_instance.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/socket_instances.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/socket_instances.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/socket_summary_by_instance.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/socket_summary_by_instance.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/socket_summary_by_event_name.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/socket_summary_by_event_name.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/host_cache.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/host_cache.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/mutex_instances.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/mutex_instances.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/objects_summary_global_by_type.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/objects_summary_global_by_type.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/performance_timers.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/performance_timers.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/rwlock_instances.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/rwlock_instances.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/setup_actors.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/setup_actors.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/setup_consumers.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/setup_consumers.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/setup_instruments.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/setup_instruments.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/setup_objects.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/setup_objects.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/setup_timers.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/setup_timers.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/table_io_waits_summary_by_index_usage.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/table_io_waits_summary_by_index_usage.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/table_io_waits_summary_by_table.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/table_io_waits_summary_by_table.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/table_lock_waits_summary_by_table.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/table_lock_waits_summary_by_table.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/threads.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/threads.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/events_stages_current.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/events_stages_current.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/events_stages_history.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/events_stages_history.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/events_stages_history_long.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/events_stages_history_long.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/events_stages_summary_by_thread_by_event_name.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/events_stages_summary_by_thread_by_event_name.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/events_stages_summary_by_host_by_event_name.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/events_stages_summary_by_host_by_event_name.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/events_stages_summary_by_user_by_event_name.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/events_stages_summary_by_user_by_event_name.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/events_stages_summary_by_account_by_event_name.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/events_stages_summary_by_account_by_event_name.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/events_stages_summary_global_by_event_name.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/events_stages_summary_global_by_event_name.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/events_statements_current.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/events_statements_current.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/events_statements_history.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/events_statements_history.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/events_statements_history_long.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/events_statements_history_long.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/events_statements_summary_by_thread_by_event_name.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/events_statements_summary_by_thread_by_event_name.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/events_statements_summary_by_host_by_event_name.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/events_statements_summary_by_host_by_event_name.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/events_statements_summary_by_user_by_event_name.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/events_statements_summary_by_user_by_event_name.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/events_statements_summary_by_account_by_event_name.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/events_statements_summary_by_account_by_event_name.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/events_statements_summary_global_by_event_name.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/events_statements_summary_global_by_event_name.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/events_transactions_current.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/events_transactions_current.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/events_transactions_history.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/events_transactions_history.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/events_transactions_history_long.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/events_transactions_history_long.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/events_transactions_summary_by_thread_by_event_name.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/events_transactions_summary_by_thread_by_event_name.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/events_transactions_summary_by_host_by_event_name.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/events_transactions_summary_by_host_by_event_name.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/events_transactions_summary_by_user_by_event_name.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/events_transactions_summary_by_user_by_event_name.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/events_transactions_summary_by_account_by_event_name.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/events_transactions_summary_by_account_by_event_name.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/events_transactions_summary_global_by_event_name.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/events_transactions_summary_global_by_event_name.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/hosts.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/hosts.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/users.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/users.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/accounts.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/accounts.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/memory_summary_global_by_event_name.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/memory_summary_global_by_event_name.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/memory_summary_by_thread_by_event_name.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/memory_summary_by_thread_by_event_name.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/memory_summary_by_account_by_event_name.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/memory_summary_by_account_by_event_name.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/memory_summary_by_host_by_event_name.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/memory_summary_by_host_by_event_name.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/memory_summary_by_user_by_event_name.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/memory_summary_by_user_by_event_name.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/events_statements_summary_by_digest.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/events_statements_summary_by_digest.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/events_statements_summary_by_program.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/events_statements_summary_by_program.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/prepared_statements_instances.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/prepared_statements_instances.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/replication_connection_configuration.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/replication_connection_configuration.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/replication_group_member_stats.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/replication_group_member_stats.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/replication_group_members.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/replication_group_members.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/replication_connection_status.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/replication_connection_status.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/replication_applier_configuration.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/replication_applier_configuration.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/replication_applier_status.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/replication_applier_status.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/replication_applier_status_by_coordinator.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/replication_applier_status_by_coordinator.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/replication_applier_status_by_worker.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/replication_applier_status_by_worker.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/session_connect_attrs.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/session_connect_attrs.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/session_account_connect_attrs.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/session_account_connect_attrs.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/table_handles.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/table_handles.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/metadata_locks.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/metadata_locks.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/user_variables_by_thread.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/user_variables_by_thread.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/variables_by_thread.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/variables_by_thread.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/global_variables.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/global_variables.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/session_variables.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/session_variables.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/status_by_thread.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/status_by_thread.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/status_by_user.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/status_by_user.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/status_by_host.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/status_by_host.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/status_by_account.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/status_by_account.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/global_status.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/global_status.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./performance_schema/session_status.frm to /home/mysql_backup/full/2021-08-23_03-25-18/performance_schema/session_status.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/db.opt to /home/mysql_backup/full/2021-08-23_03-25-18/sys/db.opt
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/version.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/version.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/sys_config.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/sys_config.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/statements_with_full_table_scans.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/statements_with_full_table_scans.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/sys_config_insert_set_user.TRN to /home/mysql_backup/full/2021-08-23_03-25-18/sys/sys_config_insert_set_user.TRN
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/processlist.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/processlist.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/sys_config.TRG to /home/mysql_backup/full/2021-08-23_03-25-18/sys/sys_config.TRG
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/statements_with_sorting.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/statements_with_sorting.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/sys_config_update_set_user.TRN to /home/mysql_backup/full/2021-08-23_03-25-18/sys/sys_config_update_set_user.TRN
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024statements_with_sorting.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024statements_with_sorting.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/innodb_buffer_stats_by_schema.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/innodb_buffer_stats_by_schema.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/schema_index_statistics.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/schema_index_statistics.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024innodb_buffer_stats_by_schema.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024innodb_buffer_stats_by_schema.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/statements_with_temp_tables.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/statements_with_temp_tables.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/innodb_buffer_stats_by_table.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/innodb_buffer_stats_by_table.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024ps_schema_table_statistics_io.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024ps_schema_table_statistics_io.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024innodb_buffer_stats_by_table.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024innodb_buffer_stats_by_table.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/host_summary.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/host_summary.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/innodb_lock_waits.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/innodb_lock_waits.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024host_summary.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024host_summary.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024innodb_lock_waits.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024innodb_lock_waits.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/waits_by_user_by_latency.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/waits_by_user_by_latency.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/schema_object_overview.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/schema_object_overview.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/user_summary_by_file_io_type.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/user_summary_by_file_io_type.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/schema_auto_increment_columns.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/schema_auto_increment_columns.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/user_summary_by_file_io.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/user_summary_by_file_io.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024schema_flattened_keys.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024schema_flattened_keys.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024user_summary_by_file_io.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024user_summary_by_file_io.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/schema_redundant_indexes.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/schema_redundant_indexes.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/user_summary_by_statement_type.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/user_summary_by_statement_type.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/ps_check_lost_instrumentation.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/ps_check_lost_instrumentation.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/latest_file_io.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/latest_file_io.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/waits_by_host_by_latency.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/waits_by_host_by_latency.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024latest_file_io.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024latest_file_io.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/waits_global_by_latency.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/waits_global_by_latency.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/io_by_thread_by_latency.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/io_by_thread_by_latency.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/user_summary_by_stages.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/user_summary_by_stages.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024io_by_thread_by_latency.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024io_by_thread_by_latency.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024user_summary_by_stages.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024user_summary_by_stages.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/io_global_by_file_by_bytes.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/io_global_by_file_by_bytes.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024schema_index_statistics.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024schema_index_statistics.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024io_global_by_file_by_bytes.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024io_global_by_file_by_bytes.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/user_summary.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/user_summary.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/io_global_by_file_by_latency.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/io_global_by_file_by_latency.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/schema_table_statistics.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/schema_table_statistics.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024io_global_by_file_by_latency.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024io_global_by_file_by_latency.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024user_summary.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024user_summary.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/io_global_by_wait_by_bytes.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/io_global_by_wait_by_bytes.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024schema_table_statistics.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024schema_table_statistics.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024io_global_by_wait_by_bytes.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024io_global_by_wait_by_bytes.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/host_summary_by_file_io_type.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/host_summary_by_file_io_type.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/io_global_by_wait_by_latency.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/io_global_by_wait_by_latency.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/schema_table_statistics_with_buffer.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/schema_table_statistics_with_buffer.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024io_global_by_wait_by_latency.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024io_global_by_wait_by_latency.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/host_summary_by_file_io.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/host_summary_by_file_io.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/memory_by_user_by_current_bytes.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/memory_by_user_by_current_bytes.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/schema_table_lock_waits.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/schema_table_lock_waits.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024memory_by_user_by_current_bytes.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024memory_by_user_by_current_bytes.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024host_summary_by_file_io.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024host_summary_by_file_io.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/memory_by_host_by_current_bytes.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/memory_by_host_by_current_bytes.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024schema_table_lock_waits.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024schema_table_lock_waits.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024memory_by_host_by_current_bytes.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024memory_by_host_by_current_bytes.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/statement_analysis.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/statement_analysis.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/memory_by_thread_by_current_bytes.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/memory_by_thread_by_current_bytes.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024statement_analysis.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024statement_analysis.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024memory_by_thread_by_current_bytes.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024memory_by_thread_by_current_bytes.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/host_summary_by_statement_type.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/host_summary_by_statement_type.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/memory_global_by_current_bytes.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/memory_global_by_current_bytes.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/statements_with_errors_or_warnings.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/statements_with_errors_or_warnings.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024memory_global_by_current_bytes.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024memory_global_by_current_bytes.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/metrics.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/metrics.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/memory_global_total.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/memory_global_total.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/host_summary_by_stages.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/host_summary_by_stages.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024memory_global_total.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024memory_global_total.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/session.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/session.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024schema_table_statistics_with_buffer.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024schema_table_statistics_with_buffer.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024statements_with_errors_or_warnings.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024statements_with_errors_or_warnings.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/schema_tables_with_full_table_scans.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/schema_tables_with_full_table_scans.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/schema_unused_indexes.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/schema_unused_indexes.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024schema_tables_with_full_table_scans.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024schema_tables_with_full_table_scans.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024host_summary_by_stages.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024host_summary_by_stages.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024statements_with_full_table_scans.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024statements_with_full_table_scans.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024ps_digest_avg_latency_distribution.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024ps_digest_avg_latency_distribution.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024ps_digest_95th_percentile_by_avg_us.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024ps_digest_95th_percentile_by_avg_us.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/statements_with_runtimes_in_95th_percentile.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/statements_with_runtimes_in_95th_percentile.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024statements_with_runtimes_in_95th_percentile.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024statements_with_runtimes_in_95th_percentile.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024statements_with_temp_tables.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024statements_with_temp_tables.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024user_summary_by_file_io_type.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024user_summary_by_file_io_type.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024user_summary_by_statement_type.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024user_summary_by_statement_type.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/user_summary_by_statement_latency.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/user_summary_by_statement_latency.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024user_summary_by_statement_latency.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024user_summary_by_statement_latency.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024host_summary_by_file_io_type.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024host_summary_by_file_io_type.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024host_summary_by_statement_type.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024host_summary_by_statement_type.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/host_summary_by_statement_latency.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/host_summary_by_statement_latency.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024host_summary_by_statement_latency.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024host_summary_by_statement_latency.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/wait_classes_global_by_avg_latency.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/wait_classes_global_by_avg_latency.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024wait_classes_global_by_avg_latency.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024wait_classes_global_by_avg_latency.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/wait_classes_global_by_latency.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/wait_classes_global_by_latency.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024wait_classes_global_by_latency.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024wait_classes_global_by_latency.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024waits_by_user_by_latency.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024waits_by_user_by_latency.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024waits_by_host_by_latency.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024waits_by_host_by_latency.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024waits_global_by_latency.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024waits_global_by_latency.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024processlist.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024processlist.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/x@0024session.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/x@0024session.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./sys/session_ssl_status.frm to /home/mysql_backup/full/2021-08-23_03-25-18/sys/session_ssl_status.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./db_book/db.opt to /home/mysql_backup/full/2021-08-23_03-25-18/db_book/db.opt
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./db_book/t_xi.frm to /home/mysql_backup/full/2021-08-23_03-25-18/db_book/t_xi.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./db_book/t_hong.frm to /home/mysql_backup/full/2021-08-23_03-25-18/db_book/t_hong.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./db_book/t_shui.frm to /home/mysql_backup/full/2021-08-23_03-25-18/db_book/t_shui.frm
210823 03:25:20 [01] ...done
210823 03:25:20 [01] Copying ./db_book/t_san.frm to /home/mysql_backup/full/2021-08-23_03-25-18/db_book/t_san.frm
210823 03:25:20 [01] ...done
210823 03:25:20 Finished backing up non-InnoDB tables and files
210823 03:25:20 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
xtrabackup: The latest check point (for incremental): '2782081'
xtrabackup: Stopping log copying thread.
.210823 03:25:20 >> log scanned up to (2782090)
210823 03:25:20 Executing UNLOCK TABLES
210823 03:25:20 All tables unlocked
210823 03:25:20 [00] Copying ib_buffer_pool to /home/mysql_backup/full/2021-08-23_03-25-18/ib_buffer_pool
210823 03:25:20 [00] ...done
210823 03:25:20 Backup created in directory '/home/mysql_backup/full/2021-08-23_03-25-18/'
210823 03:25:20 [00] Writing /home/mysql_backup/full/2021-08-23_03-25-18/backup-my.cnf
210823 03:25:20 [00] ...done
210823 03:25:20 [00] Writing /home/mysql_backup/full/2021-08-23_03-25-18/xtrabackup_info
210823 03:25:20 [00] ...done
xtrabackup: Transaction log of lsn (2782081) to (2782090) was copied.
210823 03:25:21 completed OK!
使用 --no-timestamp 参数则不建立时间相关的目录，就是下面full目录下的时间目录
[root@node3 ~]# innobackupex --defaults-file=/etc/my.cnf --user=xtrabackuser --password='Aa7788**' /home/mysql_backup/full --no-timestamp
查看备份
[root@node3 ~]# ll /home/mysql_backup/full/2021-08-23_03-25-18/
-rw-r----- 1 root root 487 Aug 23 03:25 backup-my.cnf
drwxr-x--- 2 root root 158 Aug 23 03:25 db_book
-rw-r----- 1 root root 350 Aug 23 03:25 ib_buffer_pool
-rw-r----- 1 root root 12582912 Aug 23 03:25 ibdata1
drwxr-x--- 2 root root 4096 Aug 23 03:25 mysql
drwxr-x--- 2 root root 8192 Aug 23 03:25 performance_schema
drwxr-x--- 2 root root 8192 Aug 23 03:25 sys
-rw-r----- 1 root root 135 Aug 23 03:25 xtrabackup_checkpoints
-rw-r----- 1 root root 505 Aug 23 03:25 xtrabackup_info
-rw-r----- 1 root root 2560 Aug 23 03:25 xtrabackup_logfile
在备份完成后，数据尚且不能用于恢复操作，因为备份的数据中可能会包含尚未提交的事务或者已经提交但尚未同步至数据文件中的事务。因此，此时数据文件仍处于不一致状态。"准备"的主要作用正是通过回滚未提交的事务及同步已经提交的事务至数据文件也使用得数据文件处于一致性状态。
innobackupex命令的--apply-log选项可用于实现上述功能，如下
[root@node3 ~]# innobackupex --apply-log /home/mysql_backup/full/2021-08-23_03-25-18/
....
....
xtrabackup: starting shutdown with innodb_fast_shutdown = 1
InnoDB: FTS optimize thread exiting.
InnoDB: Starting shutdown...
InnoDB: Shutdown completed; log sequence number 2782109
InnoDB: Number of pools: 1
xtrabackup: using the following InnoDB configuration for recovery:
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: PUNCH HOLE support available
InnoDB: Mutexes and rw_locks use GCC atomic builtins
InnoDB: Uses event mutexes
InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
InnoDB: Compressed tables use zlib 1.2.7
InnoDB: Number of pools: 1
InnoDB: Using CPU crc32 instructions
InnoDB: Initializing buffer pool, total size = 100M, instances = 1, chunk size = 100M
InnoDB: Completed initialization of buffer pool
InnoDB: page_cleaner coordinator priority: -20
InnoDB: Setting log file ./ib_logfile101 size to 48 MB
InnoDB: Setting log file ./ib_logfile1 size to 48 MB
InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
InnoDB: New log files created, LSN=2782109
InnoDB: Highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 2782220
InnoDB: Doing recovery: scanned up to log sequence number 2782229 (0%)
InnoDB: Database was not shutdown normally!
InnoDB: Starting crash recovery.
InnoDB: Removed temporary tablespace data file: "ibtmp1"
InnoDB: Creating shared tablespace for temporary tables
InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
InnoDB: File './ibtmp1' size is now 12 MB.
InnoDB: 96 redo rollback segment(s) found. 1 redo rollback segment(s) are active.
InnoDB: 32 non-redo rollback segment(s) are active.
InnoDB: 5.7.34 started; log sequence number 2782229
xtrabackup: starting shutdown with innodb_fast_shutdown = 1
InnoDB: FTS optimize thread exiting.
InnoDB: Starting shutdown...
InnoDB: Shutdown completed; log sequence number 2782248
210823 03:29:39 completed OK!
从一个完全备份中恢复数据
注意：恢复时需要关闭MySQL
先删除相应的表
注：这里需要注意的是没有删除库，因为删除库后恢复时会报错，因为它找不到相应的库，要新建出来相应名字的库再恢复
[root@node3 ~]# mysql -uroot -p
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| db_book |
| mysql |
| performance_schema |
| sys |
+--------------------+
5 rows in set (0.01 sec)
mysql> use db_book;
mysql> show tables;
+-------------------+
| Tables_in_db_book |
+-------------------+
| t_hong |
| t_san |
| t_shui |
| t_xi |
+-------------------+
4 rows in set (0.00 sec)
mysql> select * from t_san;
mysql> select * from t_xi;
# 将有数据的2个表删除
mysql> drop table t_xi;
mysql> drop table t_san;
mysql> show tables;
+-------------------+
| Tables_in_db_book |
+-------------------+
| t_hong |
| t_shui |
+-------------------+
2 rows in set (0.00 sec)
mysql> exit
全量恢复
[root@node3 ~]# rm -rf /var/lib/mysql/*
[root@node3 ~]# ll /var/lib/mysql/
total 0
[root@node3 ~]# innobackupex --defaults-file=/etc/my.cnf --copy-back /home/mysql_backup/full/2021-08-23_03-25-18/
xtrabackup: recognized server arguments: --datadir=/var/lib/mysql
xtrabackup: recognized client arguments:
210823 03:40:03 innobackupex: Starting the copy-back operation
IMPORTANT: Please check that the copy-back run completes successfully.
At the end of a successful copy-back run innobackupex
prints "completed OK!".
innobackupex version 2.4.23 based on MySQL server 5.7.34 Linux (x86_64) (revision id: 3320f39)
210823 03:40:03 [01] Copying ib_logfile0 to /var/lib/mysql/ib_logfile0
210823 03:40:03 [01] ...done
210823 03:40:03 [01] Copying ib_logfile1 to /var/lib/mysql/ib_logfile1
210823 03:40:03 [01] ...done
210823 03:40:03 [01] Copying ibdata1 to /var/lib/mysql/ibdata1
210823 03:40:03 [01] ...done
210823 03:40:03 [01] Copying ./mysql/plugin.ibd to /var/lib/mysql/mysql/plugin.ibd
210823 03:40:03 [01] ...done
210823 03:40:03 [01] Copying ./mysql/servers.ibd to /var/lib/mysql/mysql/servers.ibd
210823 03:40:03 [01] ...done
210823 03:40:03 [01] Copying ./mysql/help_topic.ibd to /var/lib/mysql/mysql/help_topic.ibd
210823 03:40:03 [01] ...done
210823 03:40:04 [01] Copying ./mysql/help_category.ibd to /var/lib/mysql/mysql/help_category.ibd
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/help_relation.ibd to /var/lib/mysql/mysql/help_relation.ibd
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/help_keyword.ibd to /var/lib/mysql/mysql/help_keyword.ibd
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/time_zone_name.ibd to /var/lib/mysql/mysql/time_zone_name.ibd
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/time_zone.ibd to /var/lib/mysql/mysql/time_zone.ibd
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/time_zone_transition.ibd to /var/lib/mysql/mysql/time_zone_transition.ibd
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/time_zone_transition_type.ibd to /var/lib/mysql/mysql/time_zone_transition_type.ibd
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/time_zone_leap_second.ibd to /var/lib/mysql/mysql/time_zone_leap_second.ibd
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/innodb_table_stats.ibd to /var/lib/mysql/mysql/innodb_table_stats.ibd
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/innodb_index_stats.ibd to /var/lib/mysql/mysql/innodb_index_stats.ibd
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/slave_relay_log_info.ibd to /var/lib/mysql/mysql/slave_relay_log_info.ibd
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/slave_master_info.ibd to /var/lib/mysql/mysql/slave_master_info.ibd
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/slave_worker_info.ibd to /var/lib/mysql/mysql/slave_worker_info.ibd
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/gtid_executed.ibd to /var/lib/mysql/mysql/gtid_executed.ibd
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/server_cost.ibd to /var/lib/mysql/mysql/server_cost.ibd
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/engine_cost.ibd to /var/lib/mysql/mysql/engine_cost.ibd
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/db.opt to /var/lib/mysql/mysql/db.opt
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/db.frm to /var/lib/mysql/mysql/db.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/db.MYI to /var/lib/mysql/mysql/db.MYI
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/db.MYD to /var/lib/mysql/mysql/db.MYD
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/user.frm to /var/lib/mysql/mysql/user.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/user.MYI to /var/lib/mysql/mysql/user.MYI
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/user.MYD to /var/lib/mysql/mysql/user.MYD
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/func.frm to /var/lib/mysql/mysql/func.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/func.MYI to /var/lib/mysql/mysql/func.MYI
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/func.MYD to /var/lib/mysql/mysql/func.MYD
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/plugin.frm to /var/lib/mysql/mysql/plugin.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/servers.frm to /var/lib/mysql/mysql/servers.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/tables_priv.frm to /var/lib/mysql/mysql/tables_priv.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/tables_priv.MYI to /var/lib/mysql/mysql/tables_priv.MYI
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/tables_priv.MYD to /var/lib/mysql/mysql/tables_priv.MYD
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/columns_priv.frm to /var/lib/mysql/mysql/columns_priv.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/columns_priv.MYI to /var/lib/mysql/mysql/columns_priv.MYI
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/columns_priv.MYD to /var/lib/mysql/mysql/columns_priv.MYD
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/help_topic.frm to /var/lib/mysql/mysql/help_topic.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/help_category.frm to /var/lib/mysql/mysql/help_category.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/help_relation.frm to /var/lib/mysql/mysql/help_relation.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/help_keyword.frm to /var/lib/mysql/mysql/help_keyword.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/time_zone_name.frm to /var/lib/mysql/mysql/time_zone_name.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/time_zone.frm to /var/lib/mysql/mysql/time_zone.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/time_zone_transition.frm to /var/lib/mysql/mysql/time_zone_transition.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/time_zone_transition_type.frm to /var/lib/mysql/mysql/time_zone_transition_type.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/time_zone_leap_second.frm to /var/lib/mysql/mysql/time_zone_leap_second.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/proc.frm to /var/lib/mysql/mysql/proc.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/proc.MYI to /var/lib/mysql/mysql/proc.MYI
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/proc.MYD to /var/lib/mysql/mysql/proc.MYD
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/procs_priv.frm to /var/lib/mysql/mysql/procs_priv.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/procs_priv.MYI to /var/lib/mysql/mysql/procs_priv.MYI
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/procs_priv.MYD to /var/lib/mysql/mysql/procs_priv.MYD
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/general_log.frm to /var/lib/mysql/mysql/general_log.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/general_log.CSM to /var/lib/mysql/mysql/general_log.CSM
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/general_log.CSV to /var/lib/mysql/mysql/general_log.CSV
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/slow_log.frm to /var/lib/mysql/mysql/slow_log.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/slow_log.CSM to /var/lib/mysql/mysql/slow_log.CSM
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/slow_log.CSV to /var/lib/mysql/mysql/slow_log.CSV
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/event.frm to /var/lib/mysql/mysql/event.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/event.MYI to /var/lib/mysql/mysql/event.MYI
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/event.MYD to /var/lib/mysql/mysql/event.MYD
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/ndb_binlog_index.frm to /var/lib/mysql/mysql/ndb_binlog_index.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/ndb_binlog_index.MYI to /var/lib/mysql/mysql/ndb_binlog_index.MYI
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/ndb_binlog_index.MYD to /var/lib/mysql/mysql/ndb_binlog_index.MYD
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/innodb_table_stats.frm to /var/lib/mysql/mysql/innodb_table_stats.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/innodb_index_stats.frm to /var/lib/mysql/mysql/innodb_index_stats.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/slave_relay_log_info.frm to /var/lib/mysql/mysql/slave_relay_log_info.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/slave_master_info.frm to /var/lib/mysql/mysql/slave_master_info.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/slave_worker_info.frm to /var/lib/mysql/mysql/slave_worker_info.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/gtid_executed.frm to /var/lib/mysql/mysql/gtid_executed.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/server_cost.frm to /var/lib/mysql/mysql/server_cost.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/engine_cost.frm to /var/lib/mysql/mysql/engine_cost.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/proxies_priv.frm to /var/lib/mysql/mysql/proxies_priv.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/proxies_priv.MYI to /var/lib/mysql/mysql/proxies_priv.MYI
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./mysql/proxies_priv.MYD to /var/lib/mysql/mysql/proxies_priv.MYD
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/sys_config.ibd to /var/lib/mysql/sys/sys_config.ibd
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/db.opt to /var/lib/mysql/sys/db.opt
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/version.frm to /var/lib/mysql/sys/version.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/sys_config.frm to /var/lib/mysql/sys/sys_config.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/statements_with_full_table_scans.frm to /var/lib/mysql/sys/statements_with_full_table_scans.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/sys_config_insert_set_user.TRN to /var/lib/mysql/sys/sys_config_insert_set_user.TRN
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/processlist.frm to /var/lib/mysql/sys/processlist.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/sys_config.TRG to /var/lib/mysql/sys/sys_config.TRG
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/statements_with_sorting.frm to /var/lib/mysql/sys/statements_with_sorting.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/sys_config_update_set_user.TRN to /var/lib/mysql/sys/sys_config_update_set_user.TRN
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024statements_with_sorting.frm to /var/lib/mysql/sys/x@0024statements_with_sorting.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/innodb_buffer_stats_by_schema.frm to /var/lib/mysql/sys/innodb_buffer_stats_by_schema.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/schema_index_statistics.frm to /var/lib/mysql/sys/schema_index_statistics.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024innodb_buffer_stats_by_schema.frm to /var/lib/mysql/sys/x@0024innodb_buffer_stats_by_schema.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/statements_with_temp_tables.frm to /var/lib/mysql/sys/statements_with_temp_tables.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/innodb_buffer_stats_by_table.frm to /var/lib/mysql/sys/innodb_buffer_stats_by_table.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024ps_schema_table_statistics_io.frm to /var/lib/mysql/sys/x@0024ps_schema_table_statistics_io.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024innodb_buffer_stats_by_table.frm to /var/lib/mysql/sys/x@0024innodb_buffer_stats_by_table.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/host_summary.frm to /var/lib/mysql/sys/host_summary.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/innodb_lock_waits.frm to /var/lib/mysql/sys/innodb_lock_waits.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024host_summary.frm to /var/lib/mysql/sys/x@0024host_summary.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024innodb_lock_waits.frm to /var/lib/mysql/sys/x@0024innodb_lock_waits.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/waits_by_user_by_latency.frm to /var/lib/mysql/sys/waits_by_user_by_latency.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/schema_object_overview.frm to /var/lib/mysql/sys/schema_object_overview.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/user_summary_by_file_io_type.frm to /var/lib/mysql/sys/user_summary_by_file_io_type.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/schema_auto_increment_columns.frm to /var/lib/mysql/sys/schema_auto_increment_columns.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/user_summary_by_file_io.frm to /var/lib/mysql/sys/user_summary_by_file_io.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024schema_flattened_keys.frm to /var/lib/mysql/sys/x@0024schema_flattened_keys.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024user_summary_by_file_io.frm to /var/lib/mysql/sys/x@0024user_summary_by_file_io.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/schema_redundant_indexes.frm to /var/lib/mysql/sys/schema_redundant_indexes.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/user_summary_by_statement_type.frm to /var/lib/mysql/sys/user_summary_by_statement_type.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/ps_check_lost_instrumentation.frm to /var/lib/mysql/sys/ps_check_lost_instrumentation.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/latest_file_io.frm to /var/lib/mysql/sys/latest_file_io.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/waits_by_host_by_latency.frm to /var/lib/mysql/sys/waits_by_host_by_latency.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024latest_file_io.frm to /var/lib/mysql/sys/x@0024latest_file_io.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/waits_global_by_latency.frm to /var/lib/mysql/sys/waits_global_by_latency.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/io_by_thread_by_latency.frm to /var/lib/mysql/sys/io_by_thread_by_latency.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/user_summary_by_stages.frm to /var/lib/mysql/sys/user_summary_by_stages.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024io_by_thread_by_latency.frm to /var/lib/mysql/sys/x@0024io_by_thread_by_latency.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024user_summary_by_stages.frm to /var/lib/mysql/sys/x@0024user_summary_by_stages.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/io_global_by_file_by_bytes.frm to /var/lib/mysql/sys/io_global_by_file_by_bytes.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024schema_index_statistics.frm to /var/lib/mysql/sys/x@0024schema_index_statistics.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024io_global_by_file_by_bytes.frm to /var/lib/mysql/sys/x@0024io_global_by_file_by_bytes.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/user_summary.frm to /var/lib/mysql/sys/user_summary.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/io_global_by_file_by_latency.frm to /var/lib/mysql/sys/io_global_by_file_by_latency.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/schema_table_statistics.frm to /var/lib/mysql/sys/schema_table_statistics.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024io_global_by_file_by_latency.frm to /var/lib/mysql/sys/x@0024io_global_by_file_by_latency.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024user_summary.frm to /var/lib/mysql/sys/x@0024user_summary.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/io_global_by_wait_by_bytes.frm to /var/lib/mysql/sys/io_global_by_wait_by_bytes.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024schema_table_statistics.frm to /var/lib/mysql/sys/x@0024schema_table_statistics.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024io_global_by_wait_by_bytes.frm to /var/lib/mysql/sys/x@0024io_global_by_wait_by_bytes.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/host_summary_by_file_io_type.frm to /var/lib/mysql/sys/host_summary_by_file_io_type.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/io_global_by_wait_by_latency.frm to /var/lib/mysql/sys/io_global_by_wait_by_latency.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/schema_table_statistics_with_buffer.frm to /var/lib/mysql/sys/schema_table_statistics_with_buffer.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024io_global_by_wait_by_latency.frm to /var/lib/mysql/sys/x@0024io_global_by_wait_by_latency.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/host_summary_by_file_io.frm to /var/lib/mysql/sys/host_summary_by_file_io.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/memory_by_user_by_current_bytes.frm to /var/lib/mysql/sys/memory_by_user_by_current_bytes.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/schema_table_lock_waits.frm to /var/lib/mysql/sys/schema_table_lock_waits.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024memory_by_user_by_current_bytes.frm to /var/lib/mysql/sys/x@0024memory_by_user_by_current_bytes.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024host_summary_by_file_io.frm to /var/lib/mysql/sys/x@0024host_summary_by_file_io.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/memory_by_host_by_current_bytes.frm to /var/lib/mysql/sys/memory_by_host_by_current_bytes.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024schema_table_lock_waits.frm to /var/lib/mysql/sys/x@0024schema_table_lock_waits.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024memory_by_host_by_current_bytes.frm to /var/lib/mysql/sys/x@0024memory_by_host_by_current_bytes.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/statement_analysis.frm to /var/lib/mysql/sys/statement_analysis.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/memory_by_thread_by_current_bytes.frm to /var/lib/mysql/sys/memory_by_thread_by_current_bytes.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024statement_analysis.frm to /var/lib/mysql/sys/x@0024statement_analysis.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024memory_by_thread_by_current_bytes.frm to /var/lib/mysql/sys/x@0024memory_by_thread_by_current_bytes.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/host_summary_by_statement_type.frm to /var/lib/mysql/sys/host_summary_by_statement_type.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/memory_global_by_current_bytes.frm to /var/lib/mysql/sys/memory_global_by_current_bytes.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/statements_with_errors_or_warnings.frm to /var/lib/mysql/sys/statements_with_errors_or_warnings.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024memory_global_by_current_bytes.frm to /var/lib/mysql/sys/x@0024memory_global_by_current_bytes.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/metrics.frm to /var/lib/mysql/sys/metrics.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/memory_global_total.frm to /var/lib/mysql/sys/memory_global_total.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/host_summary_by_stages.frm to /var/lib/mysql/sys/host_summary_by_stages.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024memory_global_total.frm to /var/lib/mysql/sys/x@0024memory_global_total.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/session.frm to /var/lib/mysql/sys/session.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024schema_table_statistics_with_buffer.frm to /var/lib/mysql/sys/x@0024schema_table_statistics_with_buffer.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024statements_with_errors_or_warnings.frm to /var/lib/mysql/sys/x@0024statements_with_errors_or_warnings.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/schema_tables_with_full_table_scans.frm to /var/lib/mysql/sys/schema_tables_with_full_table_scans.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/schema_unused_indexes.frm to /var/lib/mysql/sys/schema_unused_indexes.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024schema_tables_with_full_table_scans.frm to /var/lib/mysql/sys/x@0024schema_tables_with_full_table_scans.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024host_summary_by_stages.frm to /var/lib/mysql/sys/x@0024host_summary_by_stages.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024statements_with_full_table_scans.frm to /var/lib/mysql/sys/x@0024statements_with_full_table_scans.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024ps_digest_avg_latency_distribution.frm to /var/lib/mysql/sys/x@0024ps_digest_avg_latency_distribution.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024ps_digest_95th_percentile_by_avg_us.frm to /var/lib/mysql/sys/x@0024ps_digest_95th_percentile_by_avg_us.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/statements_with_runtimes_in_95th_percentile.frm to /var/lib/mysql/sys/statements_with_runtimes_in_95th_percentile.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024statements_with_runtimes_in_95th_percentile.frm to /var/lib/mysql/sys/x@0024statements_with_runtimes_in_95th_percentile.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024statements_with_temp_tables.frm to /var/lib/mysql/sys/x@0024statements_with_temp_tables.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024user_summary_by_file_io_type.frm to /var/lib/mysql/sys/x@0024user_summary_by_file_io_type.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024user_summary_by_statement_type.frm to /var/lib/mysql/sys/x@0024user_summary_by_statement_type.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/user_summary_by_statement_latency.frm to /var/lib/mysql/sys/user_summary_by_statement_latency.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024user_summary_by_statement_latency.frm to /var/lib/mysql/sys/x@0024user_summary_by_statement_latency.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024host_summary_by_file_io_type.frm to /var/lib/mysql/sys/x@0024host_summary_by_file_io_type.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024host_summary_by_statement_type.frm to /var/lib/mysql/sys/x@0024host_summary_by_statement_type.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/host_summary_by_statement_latency.frm to /var/lib/mysql/sys/host_summary_by_statement_latency.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024host_summary_by_statement_latency.frm to /var/lib/mysql/sys/x@0024host_summary_by_statement_latency.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/wait_classes_global_by_avg_latency.frm to /var/lib/mysql/sys/wait_classes_global_by_avg_latency.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024wait_classes_global_by_avg_latency.frm to /var/lib/mysql/sys/x@0024wait_classes_global_by_avg_latency.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/wait_classes_global_by_latency.frm to /var/lib/mysql/sys/wait_classes_global_by_latency.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024wait_classes_global_by_latency.frm to /var/lib/mysql/sys/x@0024wait_classes_global_by_latency.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024waits_by_user_by_latency.frm to /var/lib/mysql/sys/x@0024waits_by_user_by_latency.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024waits_by_host_by_latency.frm to /var/lib/mysql/sys/x@0024waits_by_host_by_latency.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024waits_global_by_latency.frm to /var/lib/mysql/sys/x@0024waits_global_by_latency.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024processlist.frm to /var/lib/mysql/sys/x@0024processlist.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/x@0024session.frm to /var/lib/mysql/sys/x@0024session.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./sys/session_ssl_status.frm to /var/lib/mysql/sys/session_ssl_status.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./db_book/t_xi.ibd to /var/lib/mysql/db_book/t_xi.ibd
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./db_book/t_hong.ibd to /var/lib/mysql/db_book/t_hong.ibd
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./db_book/t_shui.ibd to /var/lib/mysql/db_book/t_shui.ibd
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./db_book/t_san.ibd to /var/lib/mysql/db_book/t_san.ibd
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./db_book/db.opt to /var/lib/mysql/db_book/db.opt
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./db_book/t_xi.frm to /var/lib/mysql/db_book/t_xi.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./db_book/t_hong.frm to /var/lib/mysql/db_book/t_hong.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./db_book/t_shui.frm to /var/lib/mysql/db_book/t_shui.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./db_book/t_san.frm to /var/lib/mysql/db_book/t_san.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/db.opt to /var/lib/mysql/performance_schema/db.opt
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/cond_instances.frm to /var/lib/mysql/performance_schema/cond_instances.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/events_waits_current.frm to /var/lib/mysql/performance_schema/events_waits_current.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/events_waits_history.frm to /var/lib/mysql/performance_schema/events_waits_history.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/events_waits_history_long.frm to /var/lib/mysql/performance_schema/events_waits_history_long.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/events_waits_summary_by_instance.frm to /var/lib/mysql/performance_schema/events_waits_summary_by_instance.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/events_waits_summary_by_host_by_event_name.frm to /var/lib/mysql/performance_schema/events_waits_summary_by_host_by_event_name.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/events_waits_summary_by_user_by_event_name.frm to /var/lib/mysql/performance_schema/events_waits_summary_by_user_by_event_name.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/events_waits_summary_by_account_by_event_name.frm to /var/lib/mysql/performance_schema/events_waits_summary_by_account_by_event_name.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/events_waits_summary_by_thread_by_event_name.frm to /var/lib/mysql/performance_schema/events_waits_summary_by_thread_by_event_name.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/events_waits_summary_global_by_event_name.frm to /var/lib/mysql/performance_schema/events_waits_summary_global_by_event_name.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/file_instances.frm to /var/lib/mysql/performance_schema/file_instances.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/file_summary_by_event_name.frm to /var/lib/mysql/performance_schema/file_summary_by_event_name.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/file_summary_by_instance.frm to /var/lib/mysql/performance_schema/file_summary_by_instance.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/socket_instances.frm to /var/lib/mysql/performance_schema/socket_instances.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/socket_summary_by_instance.frm to /var/lib/mysql/performance_schema/socket_summary_by_instance.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/socket_summary_by_event_name.frm to /var/lib/mysql/performance_schema/socket_summary_by_event_name.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/host_cache.frm to /var/lib/mysql/performance_schema/host_cache.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/mutex_instances.frm to /var/lib/mysql/performance_schema/mutex_instances.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/objects_summary_global_by_type.frm to /var/lib/mysql/performance_schema/objects_summary_global_by_type.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/performance_timers.frm to /var/lib/mysql/performance_schema/performance_timers.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/rwlock_instances.frm to /var/lib/mysql/performance_schema/rwlock_instances.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/setup_actors.frm to /var/lib/mysql/performance_schema/setup_actors.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/setup_consumers.frm to /var/lib/mysql/performance_schema/setup_consumers.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/setup_instruments.frm to /var/lib/mysql/performance_schema/setup_instruments.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/setup_objects.frm to /var/lib/mysql/performance_schema/setup_objects.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/setup_timers.frm to /var/lib/mysql/performance_schema/setup_timers.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/table_io_waits_summary_by_index_usage.frm to /var/lib/mysql/performance_schema/table_io_waits_summary_by_index_usage.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/table_io_waits_summary_by_table.frm to /var/lib/mysql/performance_schema/table_io_waits_summary_by_table.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/table_lock_waits_summary_by_table.frm to /var/lib/mysql/performance_schema/table_lock_waits_summary_by_table.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/threads.frm to /var/lib/mysql/performance_schema/threads.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/events_stages_current.frm to /var/lib/mysql/performance_schema/events_stages_current.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/events_stages_history.frm to /var/lib/mysql/performance_schema/events_stages_history.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/events_stages_history_long.frm to /var/lib/mysql/performance_schema/events_stages_history_long.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/events_stages_summary_by_thread_by_event_name.frm to /var/lib/mysql/performance_schema/events_stages_summary_by_thread_by_event_name.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/events_stages_summary_by_host_by_event_name.frm to /var/lib/mysql/performance_schema/events_stages_summary_by_host_by_event_name.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/events_stages_summary_by_user_by_event_name.frm to /var/lib/mysql/performance_schema/events_stages_summary_by_user_by_event_name.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/events_stages_summary_by_account_by_event_name.frm to /var/lib/mysql/performance_schema/events_stages_summary_by_account_by_event_name.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/events_stages_summary_global_by_event_name.frm to /var/lib/mysql/performance_schema/events_stages_summary_global_by_event_name.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/events_statements_current.frm to /var/lib/mysql/performance_schema/events_statements_current.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/events_statements_history.frm to /var/lib/mysql/performance_schema/events_statements_history.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/events_statements_history_long.frm to /var/lib/mysql/performance_schema/events_statements_history_long.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/events_statements_summary_by_thread_by_event_name.frm to /var/lib/mysql/performance_schema/events_statements_summary_by_thread_by_event_name.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/events_statements_summary_by_host_by_event_name.frm to /var/lib/mysql/performance_schema/events_statements_summary_by_host_by_event_name.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/events_statements_summary_by_user_by_event_name.frm to /var/lib/mysql/performance_schema/events_statements_summary_by_user_by_event_name.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/events_statements_summary_by_account_by_event_name.frm to /var/lib/mysql/performance_schema/events_statements_summary_by_account_by_event_name.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/events_statements_summary_global_by_event_name.frm to /var/lib/mysql/performance_schema/events_statements_summary_global_by_event_name.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/events_transactions_current.frm to /var/lib/mysql/performance_schema/events_transactions_current.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/events_transactions_history.frm to /var/lib/mysql/performance_schema/events_transactions_history.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/events_transactions_history_long.frm to /var/lib/mysql/performance_schema/events_transactions_history_long.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/events_transactions_summary_by_thread_by_event_name.frm to /var/lib/mysql/performance_schema/events_transactions_summary_by_thread_by_event_name.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/events_transactions_summary_by_host_by_event_name.frm to /var/lib/mysql/performance_schema/events_transactions_summary_by_host_by_event_name.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/events_transactions_summary_by_user_by_event_name.frm to /var/lib/mysql/performance_schema/events_transactions_summary_by_user_by_event_name.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/events_transactions_summary_by_account_by_event_name.frm to /var/lib/mysql/performance_schema/events_transactions_summary_by_account_by_event_name.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/events_transactions_summary_global_by_event_name.frm to /var/lib/mysql/performance_schema/events_transactions_summary_global_by_event_name.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/hosts.frm to /var/lib/mysql/performance_schema/hosts.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/users.frm to /var/lib/mysql/performance_schema/users.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/accounts.frm to /var/lib/mysql/performance_schema/accounts.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/memory_summary_global_by_event_name.frm to /var/lib/mysql/performance_schema/memory_summary_global_by_event_name.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/memory_summary_by_thread_by_event_name.frm to /var/lib/mysql/performance_schema/memory_summary_by_thread_by_event_name.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/memory_summary_by_account_by_event_name.frm to /var/lib/mysql/performance_schema/memory_summary_by_account_by_event_name.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/memory_summary_by_host_by_event_name.frm to /var/lib/mysql/performance_schema/memory_summary_by_host_by_event_name.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/memory_summary_by_user_by_event_name.frm to /var/lib/mysql/performance_schema/memory_summary_by_user_by_event_name.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/events_statements_summary_by_digest.frm to /var/lib/mysql/performance_schema/events_statements_summary_by_digest.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/events_statements_summary_by_program.frm to /var/lib/mysql/performance_schema/events_statements_summary_by_program.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/prepared_statements_instances.frm to /var/lib/mysql/performance_schema/prepared_statements_instances.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/replication_connection_configuration.frm to /var/lib/mysql/performance_schema/replication_connection_configuration.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/replication_group_member_stats.frm to /var/lib/mysql/performance_schema/replication_group_member_stats.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/replication_group_members.frm to /var/lib/mysql/performance_schema/replication_group_members.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/replication_connection_status.frm to /var/lib/mysql/performance_schema/replication_connection_status.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/replication_applier_configuration.frm to /var/lib/mysql/performance_schema/replication_applier_configuration.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/replication_applier_status.frm to /var/lib/mysql/performance_schema/replication_applier_status.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/replication_applier_status_by_coordinator.frm to /var/lib/mysql/performance_schema/replication_applier_status_by_coordinator.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/replication_applier_status_by_worker.frm to /var/lib/mysql/performance_schema/replication_applier_status_by_worker.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/session_connect_attrs.frm to /var/lib/mysql/performance_schema/session_connect_attrs.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/session_account_connect_attrs.frm to /var/lib/mysql/performance_schema/session_account_connect_attrs.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/table_handles.frm to /var/lib/mysql/performance_schema/table_handles.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/metadata_locks.frm to /var/lib/mysql/performance_schema/metadata_locks.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/user_variables_by_thread.frm to /var/lib/mysql/performance_schema/user_variables_by_thread.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/variables_by_thread.frm to /var/lib/mysql/performance_schema/variables_by_thread.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/global_variables.frm to /var/lib/mysql/performance_schema/global_variables.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/session_variables.frm to /var/lib/mysql/performance_schema/session_variables.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/status_by_thread.frm to /var/lib/mysql/performance_schema/status_by_thread.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/status_by_user.frm to /var/lib/mysql/performance_schema/status_by_user.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/status_by_host.frm to /var/lib/mysql/performance_schema/status_by_host.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/status_by_account.frm to /var/lib/mysql/performance_schema/status_by_account.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/global_status.frm to /var/lib/mysql/performance_schema/global_status.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./performance_schema/session_status.frm to /var/lib/mysql/performance_schema/session_status.frm
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./ib_buffer_pool to /var/lib/mysql/ib_buffer_pool
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./xtrabackup_info to /var/lib/mysql/xtrabackup_info
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./xtrabackup_master_key_id to /var/lib/mysql/xtrabackup_master_key_id
210823 03:40:04 [01] ...done
210823 03:40:04 [01] Copying ./ibtmp1 to /var/lib/mysql/ibtmp1
210823 03:40:04 [01] ...done
210823 03:40:04 completed OK!
修改数据的属主和属组
[root@node3 ~]# ll /var/lib/mysql
total 122920
drwxr-x--- 2 root root 158 Aug 23 03:40 db_book
-rw-r----- 1 root root 350 Aug 23 03:40 ib_buffer_pool
-rw-r----- 1 root root 12582912 Aug 23 03:40 ibdata1
-rw-r----- 1 root root 50331648 Aug 23 03:40 ib_logfile0
-rw-r----- 1 root root 50331648 Aug 23 03:40 ib_logfile1
-rw-r----- 1 root root 12582912 Aug 23 03:40 ibtmp1
drwxr-x--- 2 root root 4096 Aug 23 03:40 mysql
drwxr-x--- 2 root root 8192 Aug 23 03:40 performance_schema
drwxr-x--- 2 root root 8192 Aug 23 03:40 sys
-rw-r----- 1 root root 505 Aug 23 03:40 xtrabackup_info
-rw-r----- 1 root root 1 Aug 23 03:40 xtrabackup_master_key_id
[root@node3 ~]# chown -R mysql.mysql /var/lib/mysql/*
[root@node3 ~]# ll /var/lib/mysql
total 122920
drwxr-x--- 2 mysql mysql 158 Aug 23 03:40 db_book
-rw-r----- 1 mysql mysql 350 Aug 23 03:40 ib_buffer_pool
-rw-r----- 1 mysql mysql 12582912 Aug 23 03:40 ibdata1
-rw-r----- 1 mysql mysql 50331648 Aug 23 03:40 ib_logfile0
-rw-r----- 1 mysql mysql 50331648 Aug 23 03:40 ib_logfile1
-rw-r----- 1 mysql mysql 12582912 Aug 23 03:40 ibtmp1
drwxr-x--- 2 mysql mysql 4096 Aug 23 03:40 mysql
drwxr-x--- 2 mysql mysql 8192 Aug 23 03:40 performance_schema
drwxr-x--- 2 mysql mysql 8192 Aug 23 03:40 sys
-rw-r----- 1 mysql mysql 505 Aug 23 03:40 xtrabackup_info
-rw-r----- 1 mysql mysql 1 Aug 23 03:40 xtrabackup_master_key_id
[root@node3 ~]# systemctl restart mysqld
[root@node3 ~]# mysql -uroot -p
Enter password:
mysql> use db_book;
mysql> show tables;
+-------------------+
| Tables_in_db_book |
+-------------------+
| t_hong |
| t_san |
| t_shui |
| t_xi |
+-------------------+
4 rows in set (0.00 sec)
mysql> select * from t_san;
+----+----------+--------------------------+--------------+------+--------+---------------------------------------------------+------+
| id | username | nickname | address | age | gender | intro | seat |
+----+----------+--------------------------+--------------+------+--------+---------------------------------------------------+------+
| 1 | 刘备 | 蜀汉的开国皇帝 | 蜀汉 | NULL | 男 | 汉最帝之子中山靖王刘胜的后代 | NULL |
| 2 | 张飞 | 五虎大将中第二位 | 涿邵 | NULL | 男 | 少时即与关羽共事刘备 | NULL |
| 3 | 关羽 | 五虎大将中第一位 | 河东解县 | NULL | 男 | 其后与张飞一起追随刘备。曾在汜水关前斩华雄 | NULL |
| 4 | 赵云 | 五虎大将中第三位 | 常山真定 | NULL | 男 | 以勇敢善战著称。原为公孙瓒的部下 | NULL |
| 5 | 黄忠 | 五虎大将 | 蜀汉 | NULL | 男 | 原为韩玄手下..年近六句有万夫不当之勇 | NULL |
| 6 | 马超 | 五虎大将 | 后汉 | NULL | 男 | 后汉征西将军马腾长子。年十七，随父腾、韩遂袭长安 | NULL |
+----+----------+-------------------------+---------------+------+--------+----------------------------------------------------+------+
6 rows in set (0.00 sec)
mysql> select * from t_xi;
+----+-----------+-----------+---------+------+--------+-----------+------+
| id | username | nickname | address | age | gender | intro | seat |
+----+-----------+-----------+---------+------+--------+-----------+------+
| 5 | 小白龙 | 白龙马 | 东海 | 18 | 男 | 能奔驰 | 5 |
| 6 | 小黑 | 黑龙马 | 南海 | 22 | 女 | 广汽 | 22 |
+----+-----------+-----------+---------+------+--------+-----------+------+
2 rows in set (0.00 sec)
本文章为转载内容，我们尊重原作者对文章享有的著作权。如有内容错误或侵权问题，欢迎原作者联系我们进行内容更正或删除文章。
