################ Donor
-- clone plugin and required user

INSTALL PLUGIN clone SONAME 'mysql_clone.so';
CREATE USER clone_user IDENTIFIED BY "clone_password";
GRANT BACKUP_ADMIN ON *.* to clone_user;
GRANT SELECT ON performance_schema.* TO clone_user;
GRANT EXECUTE ON *.* to clone_user;

-- schema

create database if not exists test;
use test;


drop table if exists none_employees;
CREATE TABLE none_employees (
    emp_no      INT             NOT NULL,
    birth_date  DATE            NOT NULL,
    first_name  VARCHAR(14)     NOT NULL,
    last_name   VARCHAR(16)     NOT NULL,
    gender      ENUM ('M','F')  NOT NULL,
    hire_date   DATE            NOT NULL,
    PRIMARY KEY (emp_no)
) COMPRESSION="none";

set @id:=0;

 insert into `none_employees` values 
  (@id:=@id+1, curdate(), SUBSTRING(MD5(RAND()) FROM 1 FOR 10),SUBSTRING(MD5(RAND()) FROM 1 FOR 10),'M',curdate())
, (@id:=@id+1, curdate(), SUBSTRING(MD5(RAND()) FROM 1 FOR 10),SUBSTRING(MD5(RAND()) FROM 1 FOR 10),'F',curdate())
, (@id:=@id+1, curdate(), SUBSTRING(MD5(RAND()) FROM 1 FOR 10),SUBSTRING(MD5(RAND()) FROM 1 FOR 10),'M',curdate())
, (@id:=@id+1, curdate(), SUBSTRING(MD5(RAND()) FROM 1 FOR 10),SUBSTRING(MD5(RAND()) FROM 1 FOR 10),'F',curdate());
 insert into `none_employees`(`emp_no`,birth_date,first_name,last_name,gender, hire_date)
   select  @id:=@id+1, curdate(), SUBSTRING(MD5(RAND()) FROM 1 FOR 10),SUBSTRING(MD5(RAND()) FROM 1 FOR 10),'M',curdate() from
    `none_employees` k1, `none_employees` k2, `none_employees` k3, `none_employees` k4,`none_employees` k5,`none_employees` k6, `none_employees` k7, `none_employees` k8, `none_employees` k9,
`none_employees` k0,`none_employees` ka, `none_employees` kb, `none_employees` kc, `none_employees` kd limit  10000000;  


drop table if exists zlib_employees;
CREATE TABLE zlib_employees (
    emp_no      INT             NOT NULL,
    birth_date  DATE            NOT NULL,
    first_name  VARCHAR(14)     NOT NULL,
    last_name   VARCHAR(16)     NOT NULL,
    gender      ENUM ('M','F')  NOT NULL,
    hire_date   DATE            NOT NULL,
    PRIMARY KEY (emp_no)
) COMPRESSION="zlib";

set @id:=0;

 insert into `zlib_employees` values 
  (@id:=@id+1, curdate(), SUBSTRING(MD5(RAND()) FROM 1 FOR 10),SUBSTRING(MD5(RAND()) FROM 1 FOR 10),'M',curdate())
, (@id:=@id+1, curdate(), SUBSTRING(MD5(RAND()) FROM 1 FOR 10),SUBSTRING(MD5(RAND()) FROM 1 FOR 10),'F',curdate())
, (@id:=@id+1, curdate(), SUBSTRING(MD5(RAND()) FROM 1 FOR 10),SUBSTRING(MD5(RAND()) FROM 1 FOR 10),'M',curdate())
, (@id:=@id+1, curdate(), SUBSTRING(MD5(RAND()) FROM 1 FOR 10),SUBSTRING(MD5(RAND()) FROM 1 FOR 10),'F',curdate());
 insert into `zlib_employees`(`emp_no`,birth_date,first_name,last_name,gender, hire_date)
   select  @id:=@id+1, curdate(), SUBSTRING(MD5(RAND()) FROM 1 FOR 10),SUBSTRING(MD5(RAND()) FROM 1 FOR 10),'M',curdate() from
    `zlib_employees` k1, `zlib_employees` k2, `zlib_employees` k3, `zlib_employees` k4,`zlib_employees` k5,`zlib_employees` k6, `zlib_employees` k7, `zlib_employees` k8, `zlib_employees` k9,
`zlib_employees` k0,`zlib_employees` ka, `zlib_employees` kb, `zlib_employees` kc, `zlib_employees` kd limit  10000000;  



drop table if exists lz4_employees;
CREATE TABLE lz4_employees (
    emp_no      INT             NOT NULL,
    birth_date  DATE            NOT NULL,
    first_name  VARCHAR(14)     NOT NULL,
    last_name   VARCHAR(16)     NOT NULL,
    gender      ENUM ('M','F')  NOT NULL,
    hire_date   DATE            NOT NULL,
    PRIMARY KEY (emp_no)
) COMPRESSION="lz4";

set @id:=0;

 insert into `lz4_employees` values 
  (@id:=@id+1, curdate(), SUBSTRING(MD5(RAND()) FROM 1 FOR 10),SUBSTRING(MD5(RAND()) FROM 1 FOR 10),'M',curdate())
, (@id:=@id+1, curdate(), SUBSTRING(MD5(RAND()) FROM 1 FOR 10),SUBSTRING(MD5(RAND()) FROM 1 FOR 10),'F',curdate())
, (@id:=@id+1, curdate(), SUBSTRING(MD5(RAND()) FROM 1 FOR 10),SUBSTRING(MD5(RAND()) FROM 1 FOR 10),'M',curdate())
, (@id:=@id+1, curdate(), SUBSTRING(MD5(RAND()) FROM 1 FOR 10),SUBSTRING(MD5(RAND()) FROM 1 FOR 10),'F',curdate());
 insert into `lz4_employees`(`emp_no`,birth_date,first_name,last_name,gender, hire_date)
   select  @id:=@id+1, curdate(), SUBSTRING(MD5(RAND()) FROM 1 FOR 10),SUBSTRING(MD5(RAND()) FROM 1 FOR 10),'M',curdate() from
    `lz4_employees` k1, `lz4_employees` k2, `lz4_employees` k3, `lz4_employees` k4,`lz4_employees` k5,`lz4_employees` k6, `lz4_employees` k7, `lz4_employees` k8, `lz4_employees` k9,
`lz4_employees` k0,`lz4_employees` ka, `lz4_employees` kb, `lz4_employees` kc, `lz4_employees` kd limit  10000000;  


################ Recipient

INSTALL PLUGIN clone SONAME 'mysql_clone.so';
CREATE USER clone_user IDENTIFIED BY "clone_password";
GRANT BACKUP_ADMIN ON *.* to clone_user;
GRANT SELECT ON performance_schema.* TO clone_user;
GRANT EXECUTE ON *.* to clone_user;
SHOW VARIABLES LIKE 'clone_valid_donor_list';
SET GLOBAL clone_valid_donor_list = "10.172.160.252";
SHOW VARIABLES LIKE 'clone_valid_donor_list';

CLONE INSTANCE FROM clone_user@10.172.160.252 IDENTIFIED BY 'clone_password';


-- MySQL version: 8.0.21 (community RPM as published by Oracle)


################  Donor

[ushastry@ctos8 Downloads]$ rpm -qa|grep -i mysql
mysql-community-common-8.0.21-1.el8.x86_64
mysql80-community-release-el8-1.noarch
mysql-community-server-8.0.21-1.el8.x86_64
mysql-community-libs-8.0.21-1.el8.x86_64
mysql-community-client-8.0.21-1.el8.x86_64

[ushastry@ctos8 Downloads]$ cat /etc/*release
CentOS Linux release 8.2.2004 (Core) 
NAME="CentOS Linux"
VERSION="8 (Core)"
ID="centos"
ID_LIKE="rhel fedora"
VERSION_ID="8"
PLATFORM_ID="platform:el8"
PRETTY_NAME="CentOS Linux 8 (Core)"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:centos:centos:8"
HOME_URL="https://www.centos.org/"
BUG_REPORT_URL="https://bugs.centos.org/"

CENTOS_MANTISBT_PROJECT="CentOS-8"
CENTOS_MANTISBT_PROJECT_VERSION="8"
REDHAT_SUPPORT_PRODUCT="centos"
REDHAT_SUPPORT_PRODUCT_VERSION="8"

CentOS Linux release 8.2.2004 (Core) 
CentOS Linux release 8.2.2004 (Core) 


[ushastry@ctos8 Downloads]$ uname -r; lsb_release -r
4.18.0-193.6.3.el8_2.x86_64
Release:	8.2.2004
[ushastry@ctos8 Downloads]$ 

[ushastry@ctos8 Downloads]$ df -Th /var/lib/mysql
Filesystem         Type  Size  Used Avail Use% Mounted on
/dev/mapper/cl-var xfs    20G  1.7G   19G   9% /var

ushastry@ctos8 Downloads]$ sudo grep PUNCH\ HOLE /var/log/mysqld.log
2020-07-28T05:50:01.522505Z 1 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available


################  Recipient

[ushastry@ctos7 Downloads]$ rpm -qa|grep -i mysql
mysql-community-server-8.0.21-1.el7.x86_64
mysql80-community-release-el7-3.noarch
mysql-community-libs-8.0.21-1.el7.x86_64
mysql-community-common-8.0.21-1.el7.x86_64
mysql-community-client-8.0.21-1.el7.x86_64
mysql-community-libs-compat-8.0.21-1.el7.x86_64
[ushastry@ctos7 Downloads]$ 
[ushastry@ctos7 Downloads]$ 
[ushastry@ctos7 Downloads]$ cat /etc/*release
CentOS Linux release 7.8.2003 (Core)
NAME="CentOS Linux"
VERSION="7 (Core)"
ID="centos"
ID_LIKE="rhel fedora"
VERSION_ID="7"
PRETTY_NAME="CentOS Linux 7 (Core)"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:centos:centos:7"
HOME_URL="https://www.centos.org/"
BUG_REPORT_URL="https://bugs.centos.org/"

CENTOS_MANTISBT_PROJECT="CentOS-7"
CENTOS_MANTISBT_PROJECT_VERSION="7"
REDHAT_SUPPORT_PRODUCT="centos"
REDHAT_SUPPORT_PRODUCT_VERSION="7"

CentOS Linux release 7.8.2003 (Core)
CentOS Linux release 7.8.2003 (Core)
[ushastry@ctos7 Downloads]$ sudo uname -r; lsb_release -r
3.10.0-1127.13.1.el7.x86_64
Release:	7.8.2003
[ushastry@ctos7 Downloads]$ 


[ushastry@ctos7 Downloads]$ sudo grep PUNCH\ HOLE /var/log/mysqld.log
2020-07-28T05:52:04.859741Z 1 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available

[ushastry@ctos7 Downloads]$ df -Th /var/lib/mysql
Filesystem              Type  Size  Used Avail Use% Mounted on
/dev/mapper/centos-root xfs    44G  8.6G   36G  20% /


################  Donor (Had to disable iptables, selinux in order for guest VMs to interact with each other)

-- CLI session

[ushastry@ctos7 Downloads]$ mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 8.0.21 MySQL Community Server - GPL

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> INSTALL PLUGIN clone SONAME 'mysql_clone.so';
Query OK, 0 rows affected (0.02 sec)

mysql> CREATE USER clone_user IDENTIFIED BY "clone_password";
Query OK, 0 rows affected (0.02 sec)

mysql> GRANT BACKUP_ADMIN ON *.* to clone_user;
Query OK, 0 rows affected (0.01 sec)

mysql> GRANT SELECT ON performance_schema.* TO clone_user;
Query OK, 0 rows affected (0.01 sec)

mysql> GRANT EXECUTE ON *.* to clone_user;
Query OK, 0 rows affected (0.01 sec)

mysql> create database if not exists test;
Query OK, 1 row affected (0.01 sec)

mysql> use test;
Database changed
mysql> 
mysql> 
mysql> drop table if exists none_employees;
Query OK, 0 rows affected, 1 warning (0.01 sec)

mysql> CREATE TABLE none_employees (
    ->     emp_no      INT             NOT NULL,
    ->     birth_date  DATE            NOT NULL,
    ->     first_name  VARCHAR(14)     NOT NULL,
    ->     last_name   VARCHAR(16)     NOT NULL,
    ->     gender      ENUM ('M','F')  NOT NULL,
    ->     hire_date   DATE            NOT NULL,
    ->     PRIMARY KEY (emp_no)
    -> ) COMPRESSION="none";
Query OK, 0 rows affected (0.10 sec)

mysql> 
mysql> set @id:=0;
Query OK, 0 rows affected (0.00 sec)

mysql> 
mysql>  insert into `none_employees` values 
    ->   (@id:=@id+1, curdate(), SUBSTRING(MD5(RAND()) FROM 1 FOR 10),SUBSTRING(MD5(RAND()) FROM 1 FOR 10),'M',curdate())
    -> , (@id:=@id+1, curdate(), SUBSTRING(MD5(RAND()) FROM 1 FOR 10),SUBSTRING(MD5(RAND()) FROM 1 FOR 10),'F',curdate())
    -> , (@id:=@id+1, curdate(), SUBSTRING(MD5(RAND()) FROM 1 FOR 10),SUBSTRING(MD5(RAND()) FROM 1 FOR 10),'M',curdate())
    -> , (@id:=@id+1, curdate(), SUBSTRING(MD5(RAND()) FROM 1 FOR 10),SUBSTRING(MD5(RAND()) FROM 1 FOR 10),'F',curdate());
Query OK, 4 rows affected, 4 warnings (0.03 sec)
Records: 4  Duplicates: 0  Warnings: 4

mysql>  insert into `none_employees`(`emp_no`,birth_date,first_name,last_name,gender, hire_date)
    ->    select  @id:=@id+1, curdate(), SUBSTRING(MD5(RAND()) FROM 1 FOR 10),SUBSTRING(MD5(RAND()) FROM 1 FOR 10),'M',curdate() from
    ->     `none_employees` k1, `none_employees` k2, `none_employees` k3, `none_employees` k4,`none_employees` k5,`none_employees` k6, `none_employees` k7, `none_employees` k8, `none_employees` k9,
    -> `none_employees` k0,`none_employees` ka, `none_employees` kb, `none_employees` kc, `none_employees` kd limit  10000000;  
Query OK, 10000000 rows affected, 1 warning (4 min 28.10 sec)
Records: 10000000  Duplicates: 0  Warnings: 1

mysql> 
mysql> drop table if exists zlib_employees;
Query OK, 0 rows affected, 1 warning (0.01 sec)

mysql> CREATE TABLE zlib_employees (
    ->     emp_no      INT             NOT NULL,
    ->     birth_date  DATE            NOT NULL,
    ->     first_name  VARCHAR(14)     NOT NULL,
    ->     last_name   VARCHAR(16)     NOT NULL,
    ->     gender      ENUM ('M','F')  NOT NULL,
    ->     hire_date   DATE            NOT NULL,
    ->     PRIMARY KEY (emp_no)
    -> ) COMPRESSION="zlib";
Query OK, 0 rows affected (0.10 sec)

mysql> 
mysql> set @id:=0;
Query OK, 0 rows affected (0.00 sec)

mysql> 
mysql>  insert into `zlib_employees` values 
    ->   (@id:=@id+1, curdate(), SUBSTRING(MD5(RAND()) FROM 1 FOR 10),SUBSTRING(MD5(RAND()) FROM 1 FOR 10),'M',curdate())
    -> , (@id:=@id+1, curdate(), SUBSTRING(MD5(RAND()) FROM 1 FOR 10),SUBSTRING(MD5(RAND()) FROM 1 FOR 10),'F',curdate())
    -> , (@id:=@id+1, curdate(), SUBSTRING(MD5(RAND()) FROM 1 FOR 10),SUBSTRING(MD5(RAND()) FROM 1 FOR 10),'M',curdate())
    -> , (@id:=@id+1, curdate(), SUBSTRING(MD5(RAND()) FROM 1 FOR 10),SUBSTRING(MD5(RAND()) FROM 1 FOR 10),'F',curdate());
Query OK, 4 rows affected, 4 warnings (0.02 sec)
Records: 4  Duplicates: 0  Warnings: 4

mysql>  insert into `zlib_employees`(`emp_no`,birth_date,first_name,last_name,gender, hire_date)
    ->    select  @id:=@id+1, curdate(), SUBSTRING(MD5(RAND()) FROM 1 FOR 10),SUBSTRING(MD5(RAND()) FROM 1 FOR 10),'M',curdate() from
    ->     `zlib_employees` k1, `zlib_employees` k2, `zlib_employees` k3, `zlib_employees` k4,`zlib_employees` k5,`zlib_employees` k6, `zlib_employees` k7, `zlib_employees` k8, `zlib_employees` k9,
    -> `zlib_employees` k0,`zlib_employees` ka, `zlib_employees` kb, `zlib_employees` kc, `zlib_employees` kd limit  10000000;  
Query OK, 10000000 rows affected, 1 warning (4 min 32.98 sec)
Records: 10000000  Duplicates: 0  Warnings: 1

mysql> 
mysql> drop table if exists lz4_employees;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> CREATE TABLE lz4_employees (
    ->     emp_no      INT             NOT NULL,
    ->     birth_date  DATE            NOT NULL,
    ->     first_name  VARCHAR(14)     NOT NULL,
    ->     last_name   VARCHAR(16)     NOT NULL,
    ->     gender      ENUM ('M','F')  NOT NULL,
    ->     hire_date   DATE            NOT NULL,
    ->     PRIMARY KEY (emp_no)
    -> ) COMPRESSION="lz4";
Query OK, 0 rows affected (0.13 sec)

mysql> 
mysql> set @id:=0;
Query OK, 0 rows affected (0.00 sec)

mysql> 
mysql>  insert into `lz4_employees` values 
    ->   (@id:=@id+1, curdate(), SUBSTRING(MD5(RAND()) FROM 1 FOR 10),SUBSTRING(MD5(RAND()) FROM 1 FOR 10),'M',curdate())
    -> , (@id:=@id+1, curdate(), SUBSTRING(MD5(RAND()) FROM 1 FOR 10),SUBSTRING(MD5(RAND()) FROM 1 FOR 10),'F',curdate())
    -> , (@id:=@id+1, curdate(), SUBSTRING(MD5(RAND()) FROM 1 FOR 10),SUBSTRING(MD5(RAND()) FROM 1 FOR 10),'M',curdate())
    -> , (@id:=@id+1, curdate(), SUBSTRING(MD5(RAND()) FROM 1 FOR 10),SUBSTRING(MD5(RAND()) FROM 1 FOR 10),'F',curdate());
Query OK, 4 rows affected, 4 warnings (0.02 sec)
Records: 4  Duplicates: 0  Warnings: 4

mysql>  insert into `lz4_employees`(`emp_no`,birth_date,first_name,last_name,gender, hire_date)
    ->    select  @id:=@id+1, curdate(), SUBSTRING(MD5(RAND()) FROM 1 FOR 10),SUBSTRING(MD5(RAND()) FROM 1 FOR 10),'M',curdate() from
    ->     `lz4_employees` k1, `lz4_employees` k2, `lz4_employees` k3, `lz4_employees` k4,`lz4_employees` k5,`lz4_employees` k6, `lz4_employees` k7, `lz4_employees` k8, `lz4_employees` k9,
    -> `lz4_employees` k0,`lz4_employees` ka, `lz4_employees` kb, `lz4_employees` kc, `lz4_employees` kd limit  10000000;  
Query OK, 10000000 rows affected, 1 warning (4 min 28.89 sec)
Records: 10000000  Duplicates: 0  Warnings: 1

mysql> SELECT SPACE, NAME, FS_BLOCK_SIZE, FILE_SIZE, ALLOCATED_SIZE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME LIKE 'test%';
+-------+---------------------+---------------+-----------+----------------+
| SPACE | NAME                | FS_BLOCK_SIZE | FILE_SIZE | ALLOCATED_SIZE |
+-------+---------------------+---------------+-----------+----------------+
|     2 | test/none_employees |          4096 | 570425344 |      570425344 |
|     3 | test/zlib_employees |          4096 | 570425344 |      293072896 |
|     4 | test/lz4_employees  |          4096 | 570425344 |      432037888 |
+-------+---------------------+---------------+-----------+----------------+
3 rows in set (0.15 sec)

- file system

sudo ls -lh /var/lib/mysql/test
[sudo] password for ushastry: 
total 1.3G
412M -rw-r-----. 1 mysql mysql 544M Jul 28 02:15 lz4_employees.ibd
544M -rw-r-----. 1 mysql mysql 544M Jul 28 02:04 none_employees.ibd
280M -rw-r-----. 1 mysql mysql 544M Jul 28 02:10 zlib_employees.ibd




################  Recipient (Had to disable iptables, selinux in order for guest VMs to interact with each other)

[ushastry@ctos7 ~]$ mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 8.0.21 MySQL Community Server - GPL

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> 

mysql>  SHOW VARIABLES LIKE 'clone_valid_donor_list';
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| clone_valid_donor_list |       |
+------------------------+-------+
1 row in set (0.01 sec)

mysql> 
mysql> SET GLOBAL clone_valid_donor_list = "10.172.160.252:3306";
Query OK, 0 rows affected (0.00 sec)

mysql> SHOW VARIABLES LIKE 'clone_valid_donor_list';
+------------------------+---------------------+
| Variable_name          | Value               |
+------------------------+---------------------+
| clone_valid_donor_list | 10.172.160.252:3306 |
+------------------------+---------------------+
1 row in set (0.00 sec)

mysql> CLONE INSTANCE FROM clone_user@10.172.160.252:3306 IDENTIFIED BY 'clone_password';
Query OK, 0 rows affected (34.43 sec)


mysql> SELECT SPACE, NAME, FS_BLOCK_SIZE, FILE_SIZE, ALLOCATED_SIZE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME LIKE 'test%';
+-------+---------------------+---------------+-----------+----------------+
| SPACE | NAME                | FS_BLOCK_SIZE | FILE_SIZE | ALLOCATED_SIZE |
+-------+---------------------+---------------+-----------+----------------+
|     2 | test/none_employees |          4096 | 570425344 |      570425344 |
|     3 | test/zlib_employees |          4096 | 570425344 |      570425344 |
|     4 | test/lz4_employees  |          4096 | 570425344 |      570425344 |
+-------+---------------------+---------------+-----------+----------------+
3 rows in set (0.00 sec)

- file system

[ushastry@ctos8 ~]$ sudo ls -lh /var/lib/mysql/test
total 1.6G
544M -rw-r----- 1 mysql mysql 544M Jul 28 02:41 lz4_employees.ibd
544M -rw-r----- 1 mysql mysql 544M Jul 28 02:41 none_employees.ibd
-rw-r----- 1 mysql mysql 544M Jul 28 02:41 zlib_employees.ibd

- excerpt from Recipient's error log

2020-07-28T06:29:08.886041Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.21'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server - GPL.
2020-07-28T06:41:08.800376Z 9 [Note] [MY-013272] [Clone] Plugin Clone reported: 'Client: Task Connect.'
2020-07-28T06:41:08.832326Z 9 [Note] [MY-013272] [Clone] Plugin Clone reported: 'Client: Master ACK Connect.'
2020-07-28T06:41:08.832580Z 9 [Note] [MY-013457] [InnoDB] Clone Apply Begin Master Version Check
2020-07-28T06:41:08.841366Z 9 [Note] [MY-013457] [InnoDB] Clone Apply Version End Master Task ID: 0 Passed, code: 0: 
2020-07-28T06:41:08.915243Z 9 [Note] [MY-013457] [InnoDB] Clone Apply Begin Master Task
2020-07-28T06:41:08.915598Z 9 [Warning] [MY-013460] [InnoDB] Clone removing all user data for provisioning: Started
2020-07-28T06:41:08.915620Z 9 [Note] [MY-011977] [InnoDB] Clone Drop all user data
2020-07-28T06:41:09.077749Z 9 [Note] [MY-011977] [InnoDB] Clone: Fix Object count: 173 task: 0
2020-07-28T06:41:09.087078Z 9 [Note] [MY-011977] [InnoDB] Clone Drop User schemas
2020-07-28T06:41:09.087249Z 9 [Note] [MY-011977] [InnoDB] Clone: Fix Object count: 4 task: 0
2020-07-28T06:41:09.087326Z 9 [Note] [MY-011977] [InnoDB] Clone Drop User tablespaces
2020-07-28T06:41:09.088691Z 9 [Note] [MY-011977] [InnoDB] Clone: Fix Object count: 6 task: 0
2020-07-28T06:41:09.119956Z 9 [Note] [MY-011977] [InnoDB] Clone Drop: finished successfully
2020-07-28T06:41:09.120016Z 9 [Warning] [MY-013460] [InnoDB] Clone removing all user data for provisioning: Finished
2020-07-28T06:41:09.125593Z 9 [Note] [MY-013272] [Clone] Plugin Clone reported: 'Client: Command COM_INIT.'
2020-07-28T06:41:09.230699Z 9 [Note] [MY-013458] [InnoDB] Clone Apply State Change : Number of tasks = 1
2020-07-28T06:41:09.230953Z 9 [Note] [MY-013458] [InnoDB] Clone Apply State FILE COPY: 
2020-07-28T06:41:09.231044Z 9 [Note] [MY-011978] [InnoDB] Clone estimated size: 1.66 GiB Available space: 18.40 GiB
2020-07-28T06:41:14.254985Z 9 [Note] [MY-013272] [Clone] Plugin Clone reported: 'Client: Tune Threads from: 1 to: 2 prev: 1 target: 2.'
2020-07-28T06:41:14.334490Z 0 [Note] [MY-013272] [Clone] Plugin Clone reported: 'Client: Task Connect.'
2020-07-28T06:41:14.336404Z 0 [Note] [MY-013457] [InnoDB] Clone Apply Begin Task ID: 1
2020-07-28T06:41:14.336522Z 0 [Note] [MY-013272] [Clone] Plugin Clone reported: 'Client: Command COM_ATTACH.'
2020-07-28T06:41:19.343546Z 9 [Note] [MY-013272] [Clone] Plugin Clone reported: 'Client: Tune stop, Data: 44 MiB/sec, Target: 76 MiB/sec..'
2020-07-28T06:41:38.415919Z 9 [Note] [MY-013272] [Clone] Plugin Clone reported: 'Client: Total Data: 1996 MiB @ 68 MiB/sec, Network: 1996 MiB @ 68 MiB/sec.'
2020-07-28T06:41:38.591751Z 9 [Note] [MY-013458] [InnoDB] Clone Apply State Change : Number of tasks = 2
2020-07-28T06:41:38.591828Z 9 [Note] [MY-013458] [InnoDB] Clone Apply State PAGE COPY: 
2020-07-28T06:41:38.692936Z 9 [Note] [MY-013272] [Clone] Plugin Clone reported: 'Client: Total Data: 1996 MiB @ 67 MiB/sec, Network: 1996 MiB @ 67 MiB/sec.'
2020-07-28T06:41:38.893832Z 9 [Note] [MY-013458] [InnoDB] Clone Apply State Change : Number of tasks = 2
2020-07-28T06:41:38.893938Z 9 [Note] [MY-013458] [InnoDB] Clone Apply State REDO COPY: 
2020-07-28T06:41:39.003997Z 9 [Note] [MY-013272] [Clone] Plugin Clone reported: 'Client: Total Data: 1996 MiB @ 67 MiB/sec, Network: 1996 MiB @ 67 MiB/sec.'
2020-07-28T06:41:39.106966Z 9 [Note] [MY-013458] [InnoDB] Clone Apply State Change : Number of tasks = 2
2020-07-28T06:41:39.107034Z 9 [Note] [MY-013458] [InnoDB] Clone Apply State FLUSH DATA: 
2020-07-28T06:41:42.714910Z 9 [Note] [MY-013458] [InnoDB] Clone Apply State FLUSH REDO: 
2020-07-28T06:41:43.095308Z 9 [Note] [MY-013458] [InnoDB] Clone Apply State DONE
2020-07-28T06:41:43.095409Z 9 [Note] [MY-013272] [Clone] Plugin Clone reported: 'Client: Command COM_EXECUTE.'
2020-07-28T06:41:43.096355Z 9 [Note] [MY-013272] [Clone] Plugin Clone reported: 'Client: Master ACK COM_EXIT.'
2020-07-28T06:41:43.099186Z 9 [Note] [MY-013272] [Clone] Plugin Clone reported: 'Client: Master ACK Disconnect : abort: false.'
2020-07-28T06:41:43.147099Z 0 [Note] [MY-013272] [Clone] Plugin Clone reported: 'Client: Command COM_EXECUTE.'
2020-07-28T06:41:43.147966Z 0 [Note] [MY-013272] [Clone] Plugin Clone reported: 'Client: Task COM_EXIT.'
2020-07-28T06:41:43.151108Z 0 [Note] [MY-013272] [Clone] Plugin Clone reported: 'Client: Task Disconnect : abort: false.'
2020-07-28T06:41:43.151166Z 0 [Note] [MY-013457] [InnoDB] Clone Apply End Task ID: 1 Passed, code: 0: 
2020-07-28T06:41:43.200666Z 9 [Note] [MY-013272] [Clone] Plugin Clone reported: 'Client: Task COM_EXIT.'
2020-07-28T06:41:43.203733Z 9 [Note] [MY-013272] [Clone] Plugin Clone reported: 'Client: Task Disconnect : abort: false.'
2020-07-28T06:41:43.203940Z 9 [Note] [MY-013457] [InnoDB] Clone Apply End Master Task ID: 0 Passed, code: 0: 
2020-07-28T06:41:43.885071Z 0 [Note] [MY-010067] [Server] Giving 2 client threads a chance to die gracefully
2020-07-28T06:41:43.885319Z 0 [Note] [MY-010117] [Server] Shutting down slave threads
2020-07-28T06:41:43.885362Z 0 [Note] [MY-010054] [Server] Event Scheduler: Killing the scheduler thread, thread id 5
2020-07-28T06:41:43.885382Z 0 [Note] [MY-010050] [Server] Event Scheduler: Waiting for the scheduler thread to reply
2020-07-28T06:41:43.885521Z 0 [Note] [MY-010048] [Server] Event Scheduler: Stopped
2020-07-28T06:41:45.888859Z 0 [Note] [MY-010118] [Server] Forcefully disconnecting 1 remaining clients
2020-07-28T06:41:45.888963Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 9  user: 'root'.
2020-07-28T06:41:45.889811Z 0 [Note] [MY-010043] [Server] Event Scheduler: Purging the queue. 0 events
2020-07-28T06:41:45.892951Z 0 [Note] [MY-012330] [InnoDB] FTS optimize thread exiting.
2020-07-28T06:41:46.296251Z 0 [Note] [MY-010120] [Server] Binlog end
2020-07-28T06:41:46.302225Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'clone'
2020-07-28T06:41:46.302377Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysqlx'
2020-07-28T06:41:46.302632Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysqlx_cache_cleaner'
2020-07-28T06:41:46.302662Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'ngram'
2020-07-28T06:41:46.302673Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'BLACKHOLE'
2020-07-28T06:41:46.302686Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'ARCHIVE'
2020-07-28T06:41:46.302696Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'TempTable'
2020-07-28T06:41:46.302706Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-07-28T06:41:46.302743Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'MRG_MYISAM'
2020-07-28T06:41:46.302755Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'MyISAM'
2020-07-28T06:41:46.302776Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_SESSION_TEMP_TABLESPACES'
2020-07-28T06:41:46.302787Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CACHED_INDEXES'
2020-07-28T06:41:46.302797Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_VIRTUAL'
2020-07-28T06:41:46.302807Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_COLUMNS'
2020-07-28T06:41:46.302818Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLESPACES'
2020-07-28T06:41:46.302828Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_INDEXES'
2020-07-28T06:41:46.302838Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLESTATS'
2020-07-28T06:41:46.302847Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLES'
2020-07-28T06:41:46.302858Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-07-28T06:41:46.302868Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-07-28T06:41:46.302877Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_CONFIG'
2020-07-28T06:41:46.302948Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-07-28T06:41:46.302966Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_DELETED'
2020-07-28T06:41:46.302977Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-07-28T06:41:46.302988Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_METRICS'
2020-07-28T06:41:46.302998Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2020-07-28T06:41:46.303009Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-07-28T06:41:46.303032Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-07-28T06:41:46.303044Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-07-28T06:41:46.303054Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-07-28T06:41:46.303069Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-07-28T06:41:46.303079Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-07-28T06:41:46.303089Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMPMEM'
2020-07-28T06:41:46.303099Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_RESET'
2020-07-28T06:41:46.303109Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP'
2020-07-28T06:41:46.303119Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TRX'
2020-07-28T06:41:46.303129Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'InnoDB'
2020-07-28T06:41:46.303165Z 0 [Note] [MY-013072] [InnoDB] Starting shutdown...
2020-07-28T06:41:46.303315Z 0 [Note] [MY-011944] [InnoDB] Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-07-28T06:41:46.303759Z 0 [Note] [MY-011944] [InnoDB] Buffer pool(s) dump completed at 200728  2:41:46
2020-07-28T06:41:46.407494Z 0 [Note] [MY-013084] [InnoDB] Log background threads are being closed...
2020-07-28T06:41:46.870243Z 0 [Note] [MY-012980] [InnoDB] Shutdown completed; log sequence number 17814886
2020-07-28T06:41:46.871472Z 0 [Note] [MY-012255] [InnoDB] Removed temporary tablespace data file: "ibtmp1"
2020-07-28T06:41:46.871507Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'MEMORY'
2020-07-28T06:41:46.871524Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'CSV'
2020-07-28T06:41:46.871536Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'sha2_cache_cleaner'
2020-07-28T06:41:46.871548Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'caching_sha2_password'
2020-07-28T06:41:46.871563Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'sha256_password'
2020-07-28T06:41:46.871573Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysql_native_password'
2020-07-28T06:41:46.872374Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'binlog'
2020-07-28T06:41:46.873353Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21)  MySQL Community Server - GPL.
2020-07-28T06:41:49.991769Z 0 [Note] [MY-010949] [Server] Basedir set to /usr/.
2020-07-28T06:41:49.991794Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21) starting as process 3685
2020-07-28T06:41:50.005745Z 0 [Note] [MY-012366] [InnoDB] Using Linux native AIO
2020-07-28T06:41:50.006374Z 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled.
2020-07-28T06:41:50.008829Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2020-07-28T06:41:50.008968Z 1 [Note] [MY-013546] [InnoDB] Atomic write enabled
2020-07-28T06:41:50.009068Z 1 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available
2020-07-28T06:41:50.009140Z 1 [Note] [MY-012943] [InnoDB] Mutexes and rw_locks use GCC atomic builtins
2020-07-28T06:41:50.009198Z 1 [Note] [MY-012944] [InnoDB] Uses event mutexes
2020-07-28T06:41:50.009254Z 1 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier
2020-07-28T06:41:50.009320Z 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.11
2020-07-28T06:41:50.013343Z 1 [Note] [MY-013251] [InnoDB] Number of pools: 1
2020-07-28T06:41:50.013772Z 1 [Note] [MY-012951] [InnoDB] Using CPU crc32 instructions
2020-07-28T06:41:50.014673Z 1 [Note] [MY-012203] [InnoDB] Directories to scan './'
2020-07-28T06:41:50.015030Z 1 [Note] [MY-011976] [InnoDB] Clone Old File Roll Forward: Skipped cloned file ./ib_logfile0 state: 101
2020-07-28T06:41:50.015169Z 1 [Note] [MY-011976] [InnoDB] Clone Old File Roll Forward: Skipped cloned file ./ib_logfile1 state: 101
2020-07-28T06:41:50.015385Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Save data file /var/lib/mysql/ib_buffer_pool state: 101
2020-07-28T06:41:50.015598Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Rename clone to data file /var/lib/mysql/ib_buffer_pool state: 101
2020-07-28T06:41:50.015802Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Save data file ibdata1 state: 101
2020-07-28T06:41:50.015948Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Rename clone to data file ibdata1 state: 101
2020-07-28T06:41:50.016150Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Save data file sys/sys_config.ibd state: 101
2020-07-28T06:41:50.016276Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Rename clone to data file sys/sys_config.ibd state: 101
2020-07-28T06:41:50.016440Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Save data file mysql.ibd state: 101
2020-07-28T06:41:50.016640Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Rename clone to data file mysql.ibd state: 101
2020-07-28T06:41:50.016829Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Save data file ./undo_002 state: 101
2020-07-28T06:41:50.017025Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Rename clone to data file ./undo_002 state: 101
2020-07-28T06:41:50.017197Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Save data file ./undo_001 state: 101
2020-07-28T06:41:50.017351Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Rename clone to data file ./undo_001 state: 101
2020-07-28T06:41:50.017579Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Save data file ./ib_logfile0 state: 101
2020-07-28T06:41:50.017767Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Rename clone to data file ./ib_logfile0 state: 101
2020-07-28T06:41:50.017955Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Save data file ./ib_logfile1 state: 101
2020-07-28T06:41:50.018130Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Rename clone to data file ./ib_logfile1 state: 101
2020-07-28T06:41:50.018389Z 1 [Note] [MY-012204] [InnoDB] Scanning './'
2020-07-28T06:41:50.019248Z 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 7 files.
2020-07-28T06:41:50.020531Z 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 128.000000M, instances = 1, chunk size =128.000000M 
2020-07-28T06:41:50.035006Z 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool
2020-07-28T06:41:50.039493Z 0 [Note] [MY-011952] [InnoDB] If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-07-28T06:41:50.039921Z 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite
2020-07-28T06:41:50.040865Z 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite
2020-07-28T06:41:50.117901Z 1 [Note] [MY-013566] [InnoDB] Double write buffer files: 2
2020-07-28T06:41:50.118294Z 1 [Note] [MY-013565] [InnoDB] Double write buffer pages per instance: 4
2020-07-28T06:41:50.118531Z 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite
2020-07-28T06:41:50.118721Z 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite
2020-07-28T06:41:50.119593Z 1 [Note] [MY-012556] [InnoDB] Opening cloned database
2020-07-28T06:41:50.119765Z 1 [Note] [MY-012560] [InnoDB] The log sequence number 2738220120 in the system tablespace does not match the log sequence number 2738267967 in the ib_logfiles!
2020-07-28T06:41:50.119933Z 1 [Note] [MY-012551] [InnoDB] Database was not shutdown normally!
2020-07-28T06:41:50.120177Z 1 [Note] [MY-012552] [InnoDB] Starting crash recovery.
2020-07-28T06:41:50.120598Z 1 [Note] [MY-013086] [InnoDB] Starting to parse redo log at lsn = 2738267672, whereas checkpoint_lsn = 2738267967
2020-07-28T06:41:50.120784Z 1 [Note] [MY-012550] [InnoDB] Doing recovery: scanned up to log sequence number 2738268014
2020-07-28T06:41:50.141134Z 1 [Note] [MY-013083] [InnoDB] Log background threads are being started...
2020-07-28T06:41:50.142724Z 1 [Note] [MY-012532] [InnoDB] Applying a batch of 1 redo log records ...
2020-07-28T06:41:50.143021Z 1 [Note] [MY-012533] [InnoDB] 100%
2020-07-28T06:41:50.153884Z 1 [Note] [MY-012535] [InnoDB] Apply batch completed!
2020-07-28T06:41:50.257103Z 1 [Note] [MY-013084] [InnoDB] Log background threads are being closed...
2020-07-28T06:41:50.259621Z 1 [Note] [MY-013083] [InnoDB] Log background threads are being started...
2020-07-28T06:41:50.260756Z 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_001'.
2020-07-28T06:41:50.265382Z 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_002'.
2020-07-28T06:41:50.272829Z 1 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces.
2020-07-28T06:41:50.273081Z 1 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 2571
2020-07-28T06:41:50.288446Z 1 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables
2020-07-28T06:41:50.288858Z 1 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-28T06:41:50.360202Z 1 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB.
2020-07-28T06:41:50.360774Z 1 [Note] [MY-013627] [InnoDB] Scanning temp tablespace dir:'./#innodb_temp/'
2020-07-28T06:41:50.501460Z 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
2020-07-28T06:41:50.502918Z 1 [Note] [MY-011976] [InnoDB] Clone Old File Roll Forward: Skipped cloned file ./ib_logfile0 state: 11
2020-07-28T06:41:50.503205Z 1 [Note] [MY-011976] [InnoDB] Clone Old File Roll Forward: Skipped cloned file ./ib_logfile1 state: 11
2020-07-28T06:41:50.503608Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Remove saved data file /var/lib/mysql/ib_buffer_pool state: 11
2020-07-28T06:41:50.504089Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Remove saved data file ibdata1 state: 11
2020-07-28T06:41:50.504424Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Remove saved data file sys/sys_config.ibd state: 11
2020-07-28T06:41:50.506069Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Remove saved data file mysql.ibd state: 11
2020-07-28T06:41:50.507163Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Remove saved data file ./undo_002 state: 11
2020-07-28T06:41:50.508265Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Remove saved data file ./undo_001 state: 11
2020-07-28T06:41:50.508614Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Remove saved data file ./ib_logfile0 state: 11
2020-07-28T06:41:50.508978Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Remove saved data file ./ib_logfile1 state: 11
2020-07-28T06:41:50.509353Z 1 [Note] [MY-012976] [InnoDB] 8.0.21 started; log sequence number 2738268014
2020-07-28T06:41:50.515461Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2020-07-28T06:41:50.523270Z 1 [Note] [MY-011089] [Server] Data dictionary restarting version '80021'.
2020-07-28T06:41:50.666126Z 1 [Note] [MY-012357] [InnoDB] Reading DD tablespace files
2020-07-28T06:41:50.695951Z 1 [Note] [MY-012356] [InnoDB] Validated 9/9  tablespaces
2020-07-28T06:41:50.696480Z 1 [Note] [MY-011977] [InnoDB] Clone Fixup: check and create schema directory
2020-07-28T06:41:50.697100Z 1 [Note] [MY-011977] [InnoDB] Clone: Fix Object count: 5 task: 0
2020-07-28T06:41:50.697578Z 1 [Note] [MY-011977] [InnoDB] Clone Fixup: create empty MyIsam and CSV tables
2020-07-28T06:41:50.844764Z 1 [Note] [MY-011977] [InnoDB] Clone: Fix Object count: 0 task: 1
2020-07-28T06:41:50.845334Z 0 [Note] [MY-011977] [InnoDB] Clone: Fix Object count: 176 task: 0
2020-07-28T06:41:50.857245Z 1 [Note] [MY-011977] [InnoDB] Clone Fixup: replication configuration tables
2020-07-28T06:41:50.857757Z 1 [Note] [MY-011977] [InnoDB] Clone Fixup: finished successfully
2020-07-28T06:41:50.887661Z 1 [Note] [MY-010006] [Server] Using data dictionary with version '80021'.
2020-07-28T06:41:50.899011Z 0 [Note] [MY-011332] [Server] Plugin mysqlx reported: 'IPv6 is available'
2020-07-28T06:41:50.899662Z 0 [Note] [MY-011323] [Server] Plugin mysqlx reported: 'X Plugin ready for connections. bind-address: '::' port: 33060'
2020-07-28T06:41:50.899999Z 0 [Note] [MY-011323] [Server] Plugin mysqlx reported: 'X Plugin ready for connections. socket: '/var/run/mysqld/mysqlx.sock''
2020-07-28T06:41:50.900423Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2020-07-28T06:41:50.948582Z 0 [Note] [MY-010902] [Server] Thread priority attribute setting in Resource Group SQL shall be ignored due to unsupported platform or insufficient privilege.
2020-07-28T06:41:50.977530Z 0 [Note] [MY-012487] [InnoDB] DDL log recovery : begin
2020-07-28T06:41:50.978086Z 0 [Note] [MY-012488] [InnoDB] DDL log recovery : end
2020-07-28T06:41:50.978802Z 0 [Note] [MY-011946] [InnoDB] Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-07-28T06:41:50.990697Z 0 [Note] [MY-012922] [InnoDB] Waiting for purge to start
2020-07-28T06:41:51.022036Z 0 [Note] [MY-011946] [InnoDB] Buffer pool(s) load completed at 200728  2:41:51
2020-07-28T06:41:51.078873Z 0 [Note] [MY-010913] [Server] You have not provided a mandatory server-id. Servers in a replication topology must have unique server-ids. Please refer to the proper server start-up parameters documentation.
2020-07-28T06:41:51.084411Z 0 [Note] [MY-010182] [Server] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-07-28T06:41:51.085037Z 0 [Note] [MY-010304] [Server] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-07-28T06:41:51.086907Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-07-28T06:41:51.087320Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2020-07-28T06:41:51.087826Z 0 [Note] [MY-010308] [Server] Skipping generation of RSA key pair through --sha256_password_auto_generate_rsa_keys as key files are present in data directory.
2020-07-28T06:41:51.088238Z 0 [Note] [MY-010308] [Server] Skipping generation of RSA key pair through --caching_sha2_password_auto_generate_rsa_keys as key files are present in data directory.
2020-07-28T06:41:51.088931Z 0 [Note] [MY-010252] [Server] Server hostname (bind-address): '*'; port: 3306
2020-07-28T06:41:51.089401Z 0 [Note] [MY-010253] [Server] IPv6 is available.
2020-07-28T06:41:51.089917Z 0 [Note] [MY-010264] [Server]   - '::' resolves to '::';
2020-07-28T06:41:51.090349Z 0 [Note] [MY-010251] [Server] Server socket created on IP: '::'.
2020-07-28T06:41:51.122169Z 0 [Note] [MY-011025] [Repl] Failed to start slave threads for channel ''.
2020-07-28T06:41:51.125376Z 5 [Note] [MY-010051] [Server] Event Scheduler: scheduler thread started with id 5
2020-07-28T06:41:51.126520Z 0 [Note] [MY-011240] [Server] Plugin mysqlx reported: 'Using SSL configuration from MySQL Server'
2020-07-28T06:41:51.127681Z 0 [Note] [MY-011243] [Server] Plugin mysqlx reported: 'Using OpenSSL for TLS connections'
2020-07-28T06:41:51.128221Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.21'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server - GPL.
2020-07-28T06:43:20.940299Z 8 [Note] [MY-010926] [Server] Access denied for user 'root'@'localhost' (using password: YES)
2020-07-28T06:43:34.406860Z 9 [Note] [MY-010926] [Server] Access denied for user 'root'@'localhost' (using password: YES)