percona-xtrabackup 全备和增备脚本-备份策略参考(13)

全备和增备，定时任务设置。
xtrabackup下载地址：https://www.percona.com/software/mysql-database/percona-xtrabackup

备份阶段：

Last login: Fri Dec 30 11:24:46 2022 from 10.168.20.66
[root@mysql2 ~]# crontab -l
0 8 * * 5 /root/mysql_full_backup.sh        ##周5的8点做一次全备
0 8 * * 1-4,6-7 /root/mysql_incr_backup.sh      ##增备

[root@mysql2 backup]# cat /root/mysql_full_backup.sh
#!/bin/bash

date=`date +%F`
backupDir=/data/backup
target_dir=/data/backup/$date
xtrDir=/usr/bin/xtrabackup
mysqlDir=/mysql/bin/mysql
backupLog=/data/backuplog
mysql_host=192.168.207.132
mysql_port=3306
mysql_root=root
mysql_password=abcd1234
mysql_socket=/mysql/mysql.sock
mysql_cnf=/etc/my.cnf

$xtrDir --defaults-file=$mysql_cnf --user=$mysql_user --password=$mysql_password --no-server-version-check --socket=$mysql_socket --compress --compress-threads=2 --backup --target-dir=$target_dir >>$backupLog/backup_full_success.log 2>&1

find $backupDir -maxdepth 1 -type d -mtime +8 -exec rm -Rf {} \; >>$backupLog/deleted_record.log  2>&1          ##删除8天前的备份文件

[root@mysql2 backup]# 
[root@mysql2 backup]# 
[root@mysql2 backup]# cat /root/mysql_incr_backup.sh
#!/bin/bash

date=`date +%F`
datenum=`date -d "1 days ago" +%F`
cur_dateTime=$(date "+%Y-%m-%d %H:%M:%S")
backupDir=/data/backup
target_dir=/data/backup/$date
xtrDir=/usr/bin/xtrabackup
mysqlDir=/mysql/bin/mysql
backupLog=/data/backuplog
mysql_host=192.168.207.132
mysql_port=3306
mysql_root=root
mysql_password=abcd1234
mysql_socket=/mysql/mysql.sock
mysql_cnf=/etc/my.cnf

$xtrDir --defaults-file=$mysql_cnf --port=$mysql_port --user=$mysql_user --password=$mysql_password --no-server-version-check --socket=$mysql_socket --compress --compress-threads=2 --backup --target-dir=$target_dir --incremental-basedir=$backupDir/$datenum >> $backupLog/backup_incr_success.log 2>&1

find $backupDir -maxdepth 1 -type d -mtime +8 -exec rm -Rf {} \; >>$backupLog/deleted_record.log  2>&1            ##删除8天前的备份文件


[root@mysql2 ~]# cd /data/backup/
[root@mysql2 backup]# ll
total 16
drwxr-x---. 8 root root 4096 Dec 30 12:21 2022-12-30
drwxr-x---. 8 root root 4096 Dec 31 08:00 2022-12-31
drwxr-x---. 8 root root 4096 Jan  1 08:00 2023-01-01
drwxr-x---. 8 root root 4096 Jan  2 08:00 2023-01-02
drwxr-xr-x. 2 root root   94 Dec 31 08:00 backuplog
[root@mysql2 backup]# date
Mon Jan  2 17:44:35 CST 2023
[root@mysql2 backup]# ls -lt
total 16
drwxr-x---. 8 root root 4096 Jan  2 08:00 2023-01-02
drwxr-x---. 8 root root 4096 Jan  1 08:00 2023-01-01
drwxr-x---. 8 root root 4096 Dec 31 08:00 2022-12-31
drwxr-xr-x. 2 root root   94 Dec 31 08:00 backuplog
drwxr-x---. 8 root root 4096 Dec 30 12:21 2022-12-30
[root@mysql2 backup]# cat 2023-01-02/xtrabackup_checkpoints 
backup_type = incremental
from_lsn = 20070978
to_lsn = 20070998
last_lsn = 20070998
flushed_lsn = 20070998
redo_memory = 360
redo_frames = 1
[root@mysql2 backup]# cat 2023-01-01/xtrabackup_checkpoints 
backup_type = incremental
from_lsn = 20070958
to_lsn = 20070978
last_lsn = 20070978
flushed_lsn = 20070978
redo_memory = 360
redo_frames = 1
[root@mysql2 backup]# cat 2022-12-31/xtrabackup_checkpoints 
backup_type = incremental
from_lsn = 20070938
to_lsn = 20070958
last_lsn = 20070958
flushed_lsn = 20070958
redo_memory = 360
redo_frames = 1
[root@mysql2 backup]# cat 2022-12-30/xtrabackup_checkpoints 
backup_type = full-backuped
from_lsn = 0
to_lsn = 20070938
last_lsn = 20070938
flushed_lsn = 20070938
redo_memory = 360
redo_frames = 1
[root@mysql2 backup]# 
[root@mysql2 backup]# 


[root@mysql2 backup]# cd backuplog
[root@mysql2 backuplog]# ll
total 48
-rw-r--r--. 1 root root 11864 Dec 30 12:21 backup_full_success.log
-rw-r--r--. 1 root root 36720 Jan  2 08:00 backup_incr_success.log
-rw-r--r--. 1 root root     0 Dec 30 12:21 deleted_record.log
[root@mysql2 backuplog]# more backup_incr_success.log
2022-12-31T08:00:01.457264+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized server arguments: --datadir=/mysql/data --innodb_buffer_pool_size=2G --innodb_flush_log_at_trx_commit=2 --log_bin=/mysql/data
/mysql-bin --server-id=2 
2022-12-31T08:00:01.457714+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized client arguments: --port=3306 --socket=/mysql/mysql.sock --port=3306 --user= --password=* --no-server-version-check=1 --socke
t=/mysql/mysql.sock --compress --compress-threads=2 --backup=1 --target-dir=/data/backup/2022-12-31 --incremental-basedir=/data/backup/2022-12-30 
/usr/bin/xtrabackup version 8.0.30-23 based on MySQL server 8.0.30 Linux (x86_64) (revision id: 873b467185c)
221231 08:00:01  version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;port=3306;mysql_socket=/mysql/mysql.sock' (using password: YES).
221231 08:00:01  version_check Connected to MySQL server
221231 08:00:01  version_check Executing a version check against the server...
221231 08:00:01  version_check Done.
2022-12-31T08:00:01.573258+08:00 0 [Note] [MY-011825] [Xtrabackup] Connecting to MySQL server host: localhost, user: , password: set, port: 3306, socket: /mysql/mysql.sock
2022-12-31T08:00:01.582994+08:00 0 [Note] [MY-011825] [Xtrabackup] Using server version 8.0.31
2022-12-31T08:00:01.588140+08:00 0 [Note] [MY-011825] [Xtrabackup] Executing LOCK INSTANCE FOR BACKUP ...
2022-12-31T08:00:01.589113+08:00 0 [Note] [MY-011825] [Xtrabackup] incremental backup from 20070938 is enabled.
2022-12-31T08:00:01.591172+08:00 0 [Note] [MY-011825] [Xtrabackup] uses posix_fadvise().
2022-12-31T08:00:01.591248+08:00 0 [Note] [MY-011825] [Xtrabackup] cd to /mysql/data
2022-12-31T08:00:01.591282+08:00 0 [Note] [MY-011825] [Xtrabackup] open files limit requested 0, set to 1024
2022-12-31T08:00:01.591395+08:00 0 [Note] [MY-011825] [Xtrabackup] using the following InnoDB configuration:
2022-12-31T08:00:01.591416+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_home_dir = .
2022-12-31T08:00:01.591431+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_file_path = ibdata1:12M:autoextend
2022-12-31T08:00:01.591514+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_group_home_dir = ./
2022-12-31T08:00:01.591533+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_files_in_group = 2
2022-12-31T08:00:01.591554+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_file_size = 50331648
2022-12-31T08:00:01.592983+08:00 0 [Note] [MY-013251] [InnoDB] Number of pools: 1
2022-12-31T08:00:01.594728+08:00 0 [Note] [MY-011825] [Xtrabackup] inititialize_service_handles suceeded
2022-12-31T08:00:01.876131+08:00 0 [Note] [MY-011825] [Xtrabackup] Connecting to MySQL server host: localhost, user: , password: set, port: 3306, socket: /mysql/mysql.sock
2022-12-31T08:00:01.883556+08:00 0 [Note] [MY-011825] [Xtrabackup] Redo Log Archiving is not set up.
2022-12-31T08:00:01.988792+08:00 1 [Note] [MY-011825] [Xtrabackup] >> log scanned up to (20070958)
2022-12-31T08:00:02.198202+08:00 0 [Note] [MY-011825] [Xtrabackup] Generating a list of tablespaces
2022-12-31T08:00:02.198324+08:00 0 [Note] [MY-011825] [Xtrabackup] Generating a list of tablespaces
2022-12-31T08:00:02.198357+08:00 0 [Note] [MY-012204] [InnoDB] Scanning './'
2022-12-31T08:00:02.201629+08:00 0 [Note] [MY-012208] [InnoDB] Completed space ID check of 2 files.
2022-12-31T08:00:02.204579+08:00 0 [Warning] [MY-012091] [InnoDB] Allocated tablespace ID 6 for test/t, old maximum was 0
2022-12-31T08:00:02.208053+08:00 0 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_001'.
2022-12-31T08:00:02.209139+08:00 0 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_002'.
2022-12-31T08:00:02.213414+08:00 0 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces.
2022-12-31T08:00:02.213475+08:00 0 [Note] [MY-011825] [Xtrabackup] using the full scan for incremental backup
2022-12-31T08:00:02.345654+08:00 2 [Note] [MY-011825] [Xtrabackup] Compressing ./ibdata1 to /data/backup/2022-12-31/ibdata1.delta.qp
2022-12-31T08:00:02.390826+08:00 2 [Note] [MY-011825] [Xtrabackup] Done: Compressing ./ibdata1 to /data/backup/2022-12-31/ibdata1.delta.qp
2022-12-31T08:00:02.411264+08:00 2 [Note] [MY-011825] [Xtrabackup] Compressing ./sys/sys_config.ibd to /data/backup/2022-12-31/sys/sys_config.ibd.delta.qp
2022-12-31T08:00:02.411678+08:00 2 [Note] [MY-011825] [Xtrabackup] Done: Compressing ./sys/sys_config.ibd to /data/backup/2022-12-31/sys/sys_config.ibd.delta.qp
2022-12-31T08:00:02.433352+08:00 2 [Note] [MY-011825] [Xtrabackup] Compressing ./jycdb/test.ibd to /data/backup/2022-12-31/jycdb/test.ibd.delta.qp
2022-12-31T08:00:02.433823+08:00 2 [Note] [MY-011825] [Xtrabackup] Done: Compressing ./jycdb/test.ibd to /data/backup/2022-12-31/jycdb/test.ibd.delta.qp
2022-12-31T08:00:02.452545+08:00 2 [Note] [MY-011825] [Xtrabackup] Compressing ./jyc/t.ibd to /data/backup/2022-12-31/jyc/t.ibd.delta.qp
2022-12-31T08:00:02.452945+08:00 2 [Note] [MY-011825] [Xtrabackup] Done: Compressing ./jyc/t.ibd to /data/backup/2022-12-31/jyc/t.ibd.delta.qp
2022-12-31T08:00:02.472294+08:00 2 [Note] [MY-011825] [Xtrabackup] Compressing ./test/t.ibd to /data/backup/2022-12-31/test/t.ibd.delta.qp
2022-12-31T08:00:02.472815+08:00 2 [Note] [MY-011825] [Xtrabackup] Done: Compressing ./test/t.ibd to /data/backup/2022-12-31/test/t.ibd.delta.qp
2022-12-31T08:00:02.492656+08:00 2 [Note] [MY-011825] [Xtrabackup] Compressing ./mysql.ibd to /data/backup/2022-12-31/mysql.ibd.delta.qp
2022-12-31T08:00:02.581407+08:00 2 [Note] [MY-011825] [Xtrabackup] Done: Compressing ./mysql.ibd to /data/backup/2022-12-31/mysql.ibd.delta.qp
2022-12-31T08:00:02.601242+08:00 2 [Note] [MY-011825] [Xtrabackup] Compressing ./undo_002 to /data/backup/2022-12-31/undo_002.delta.qp
2022-12-31T08:00:02.652878+08:00 2 [Note] [MY-011825] [Xtrabackup] Done: Compressing ./undo_002 to /data/backup/2022-12-31/undo_002.delta.qp
2022-12-31T08:00:02.672771+08:00 2 [Note] [MY-011825] [Xtrabackup] Compressing ./undo_001 to /data/backup/2022-12-31/undo_001.delta.qp
2022-12-31T08:00:02.720421+08:00 2 [Note] [MY-011825] [Xtrabackup] Done: Compressing ./undo_001 to /data/backup/2022-12-31/undo_001.delta.qp
2022-12-31T08:00:02.989127+08:00 1 [Note] [MY-011825] [Xtrabackup] >> log scanned up to (20070958)
2022-12-31T08:00:03.213794+08:00 0 [Note] [MY-011825] [Xtrabackup] Starting to backup non-InnoDB tables and files
2022-12-31T08:00:03.214982+08:00 3 [Note] [MY-011825] [Xtrabackup] Compressing mysql/slow_log.CSM to /data/backup/2022-12-31/mysql/slow_log.CSM.qp
2022-12-31T08:00:03.215544+08:00 3 [Note] [MY-011825] [Xtrabackup] Done: Compressing mysql/slow_log.CSM to /data/backup/2022-12-31/mysql/slow_log.CSM.qp
2022-12-31T08:00:03.217648+08:00 3 [Note] [MY-011825] [Xtrabackup] Compressing mysql/slow_log.CSV to /data/backup/2022-12-31/mysql/slow_log.CSV.qp
2022-12-31T08:00:03.217687+08:00 3 [Note] [MY-011825] [Xtrabackup] Done: Compressing mysql/slow_log.CSV to /data/backup/2022-12-31/mysql/slow_log.CSV.qp
2022-12-31T08:00:03.220449+08:00 3 [Note] [MY-011825] [Xtrabackup] Compressing mysql/general_log.CSV to /data/backup/2022-12-31/mysql/general_log.CSV.qp
2022-12-31T08:00:03.220486+08:00 3 [Note] [MY-011825] [Xtrabackup] Done: Compressing mysql/general_log.CSV to /data/backup/2022-12-31/mysql/general_log.CSV.qp
2022-12-31T08:00:03.221403+08:00 3 [Note] [MY-011825] [Xtrabackup] Compressing mysql/general_log.CSM to /data/backup/2022-12-31/mysql/general_log.CSM.qp
2022-12-31T08:00:03.221751+08:00 3 [Note] [MY-011825] [Xtrabackup] Done: Compressing mysql/general_log.CSM to /data/backup/2022-12-31/mysql/general_log.CSM.qp
2022-12-31T08:00:03.223928+08:00 3 [Note] [MY-011825] [Xtrabackup] Compressing mysql/general_log_496.sdi to /data/backup/2022-12-31/mysql/general_log_496.sdi.qp
2022-12-31T08:00:03.224452+08:00 3 [Note] [MY-011825] [Xtrabackup] Done: Compressing mysql/general_log_496.sdi to /data/backup/2022-12-31/mysql/general_log_496.sdi.qp
2022-12-31T08:00:03.226532+08:00 3 [Note] [MY-011825] [Xtrabackup] Compressing mysql/slow_log_498.sdi to /data/backup/2022-12-31/mysql/slow_log_498.sdi.qp
2022-12-31T08:00:03.227086+08:00 3 [Note] [MY-011825] [Xtrabackup] Done: Compressing mysql/slow_log_498.sdi to /data/backup/2022-12-31/mysql/slow_log_498.sdi.qp
2022-12-31T08:00:03.229269+08:00 3 [Note] [MY-011825] [Xtrabackup] Compressing performance_schema/clone_status_381.sdi to /data/backup/2022-12-31/performance_schema/clone_status_381.sdi.qp
2022-12-31T08:00:03.230044+08:00 3 [Note] [MY-011825] [Xtrabackup] Done: Compressing performance_schema/clone_status_381.sdi to /data/backup/2022-12-31/performance_schema/clone_status_381.sdi.qp
2022-12-31T08:00:03.231252+08:00 3 [Note] [MY-011825] [Xtrabackup] Compressing performance_schema/clone_progress_382.sdi to /data/backup/2022-12-31/performance_schema/clone_progress_382.sdi.qp
2022-12-31T08:00:03.231801+08:00 3 [Note] [MY-011825] [Xtrabackup] Done: Compressing performance_schema/clone_progress_382.sdi to /data/backup/2022-12-31/performance_schema/clone_progress_382.sdi.qp
2022-12-31T08:00:03.315127+08:00 0 [Note] [MY-011825] [Xtrabackup] Finished backing up non-InnoDB tables and files
2022-12-31T08:00:03.315199+08:00 0 [Note] [MY-011825] [Xtrabackup] Executing FLUSH NO_WRITE_TO_BINLOG BINARY LOGS
2022-12-31T08:00:03.325911+08:00 0 [Note] [MY-011825] [Xtrabackup] Selecting LSN and binary log position from p_s.log_status
2022-12-31T08:00:03.329863+08:00 0 [Note] [MY-011825] [Xtrabackup] Compressing /mysql/data/mysql-bin.000008 to /data/backup/2022-12-31/mysql-bin.000008.qp up to position 237
2022-12-31T08:00:03.330019+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Compressing /mysql/data/mysql-bin.000008 to /data/backup/2022-12-31/mysql-bin.000008.qp
2022-12-31T08:00:03.332170+08:00 0 [Note] [MY-011825] [Xtrabackup] Compressing /data/backup/2022-12-31/mysql-bin.index.qp
2022-12-31T08:00:03.332354+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Compressing file /data/backup/2022-12-31/mysql-bin.index.qp
2022-12-31T08:00:03.337433+08:00 0 [Note] [MY-011825] [Xtrabackup] Compressing /data/backup/2022-12-31/xtrabackup_binlog_info.qp
2022-12-31T08:00:03.337521+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Compressing file /data/backup/2022-12-31/xtrabackup_binlog_info.qp
2022-12-31T08:00:03.338519+08:00 0 [Note] [MY-011825] [Xtrabackup] Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
2022-12-31T08:00:03.342768+08:00 0 [Note] [MY-011825] [Xtrabackup] The latest check point (for incremental): '20070958'
2022-12-31T08:00:03.342810+08:00 0 [Note] [MY-011825] [Xtrabackup] Stopping log copying thread at LSN 20070958
2022-12-31T08:00:03.342953+08:00 1 [Note] [MY-011825] [Xtrabackup] Starting to parse redo log at lsn = 20070928
2022-12-31T08:00:03.349083+08:00 0 [Note] [MY-011825] [Xtrabackup] Executing UNLOCK INSTANCE
2022-12-31T08:00:03.349286+08:00 0 [Note] [MY-011825] [Xtrabackup] All tables unlocked
2022-12-31T08:00:03.349471+08:00 0 [Note] [MY-011825] [Xtrabackup] Compressing ib_buffer_pool to /data/backup/2022-12-31/ib_buffer_pool.qp
2022-12-31T08:00:03.350176+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Compressing ib_buffer_pool to /data/backup/2022-12-31/ib_buffer_pool.qp
2022-12-31T08:00:03.353333+08:00 0 [Note] [MY-011825] [Xtrabackup] Backup created in directory '/data/backup/2022-12-31/'
2022-12-31T08:00:03.353372+08:00 0 [Note] [MY-011825] [Xtrabackup] MySQL binlog position: filename 'mysql-bin.000008', position '237', GTID of the last change '0489844a-85ae-11ed-97ee-d67f35a9de29:1-6,d0
271cef-7782-11ed-828a-d67f35a9de29:1-5'
2022-12-31T08:00:03.353547+08:00 0 [Note] [MY-011825] [Xtrabackup] Compressing /data/backup/2022-12-31/backup-my.cnf.qp
2022-12-31T08:00:03.353669+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Compressing file /data/backup/2022-12-31/backup-my.cnf.qp
2022-12-31T08:00:03.356735+08:00 0 [Note] [MY-011825] [Xtrabackup] Compressing /data/backup/2022-12-31/xtrabackup_info.qp
2022-12-31T08:00:03.356826+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Compressing file /data/backup/2022-12-31/xtrabackup_info.qp
2022-12-31T08:00:04.363430+08:00 0 [Note] [MY-011825] [Xtrabackup] Transaction log of lsn (20070958) to (20070968) was copied.
2022-12-31T08:00:04.573901+08:00 0 [Note] [MY-011825] [Xtrabackup] completed OK!
2023-01-01T08:00:01.269759+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized server arguments: --datadir=/mysql/data --innodb_buffer_pool_size=2G --innodb_flush_log_at_trx_commit=2 --log_bin=/mysql/data
/mysql-bin --server-id=2 
2023-01-01T08:00:01.270238+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized client arguments: --port=3306 --socket=/mysql/mysql.sock --port=3306 --user= --password=* --no-server-version-check=1 --socke
t=/mysql/mysql.sock --compress --compress-threads=2 --backup=1 --target-dir=/data/backup/2023-01-01 --incremental-basedir=/data/backup/2022-12-31 
/usr/bin/xtrabackup version 8.0.30-23 based on MySQL server 8.0.30 Linux (x86_64) (revision id: 873b467185c)
230101 08:00:01  version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;port=3306;mysql_socket=/mysql/mysql.sock' (using password: YES).
230101 08:00:01  version_check Connected to MySQL server
230101 08:00:01  version_check Executing a version check against the server...
230101 08:00:01  version_check Done.
2023-01-01T08:00:01.390398+08:00 0 [Note] [MY-011825] [Xtrabackup] Connecting to MySQL server host: localhost, user: , password: set, port: 3306, socket: /mysql/mysql.sock
2023-01-01T08:00:01.399022+08:00 0 [Note] [MY-011825] [Xtrabackup] Using server version 8.0.31
2023-01-01T08:00:01.404497+08:00 0 [Note] [MY-011825] [Xtrabackup] Executing LOCK INSTANCE FOR BACKUP ...
2023-01-01T08:00:01.405720+08:00 0 [Note] [MY-011825] [Xtrabackup] incremental backup from 20070958 is enabled.
2023-01-01T08:00:01.407684+08:00 0 [Note] [MY-011825] [Xtrabackup] uses posix_fadvise().
2023-01-01T08:00:01.407767+08:00 0 [Note] [MY-011825] [Xtrabackup] cd to /mysql/data
2023-01-01T08:00:01.407801+08:00 0 [Note] [MY-011825] [Xtrabackup] open files limit requested 0, set to 1024
2023-01-01T08:00:01.407914+08:00 0 [Note] [MY-011825] [Xtrabackup] using the following InnoDB configuration:
2023-01-01T08:00:01.407935+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_home_dir = .
2023-01-01T08:00:01.407950+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_file_path = ibdata1:12M:autoextend
2023-01-01T08:00:01.408033+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_group_home_dir = ./
2023-01-01T08:00:01.408091+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_files_in_group = 2
2023-01-01T08:00:01.408120+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_file_size = 50331648
2023-01-01T08:00:01.409253+08:00 0 [Note] [MY-013251] [InnoDB] Number of pools: 1
2023-01-01T08:00:01.411097+08:00 0 [Note] [MY-011825] [Xtrabackup] inititialize_service_handles suceeded
2023-01-01T08:00:01.690129+08:00 0 [Note] [MY-011825] [Xtrabackup] Connecting to MySQL server host: localhost, user: , password: set, port: 3306, socket: /mysql/mysql.sock
2023-01-01T08:00:01.699266+08:00 0 [Note] [MY-011825] [Xtrabackup] Redo Log Archiving is not set up.
2023-01-01T08:00:01.813858+08:00 1 [Note] [MY-011825] [Xtrabackup] >> log scanned up to (20070978)
2023-01-01T08:00:02.019105+08:00 0 [Note] [MY-011825] [Xtrabackup] Generating a list of tablespaces
2023-01-01T08:00:02.019248+08:00 0 [Note] [MY-011825] [Xtrabackup] Generating a list of tablespaces
2023-01-01T08:00:02.019283+08:00 0 [Note] [MY-012204] [InnoDB] Scanning './'
2023-01-01T08:00:02.022564+08:00 0 [Note] [MY-012208] [InnoDB] Completed space ID check of 2 files.
2023-01-01T08:00:02.025985+08:00 0 [Warning] [MY-012091] [InnoDB] Allocated tablespace ID 6 for test/t, old maximum was 0
2023-01-01T08:00:02.029276+08:00 0 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_001'.
2023-01-01T08:00:02.030223+08:00 0 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_002'.
2023-01-01T08:00:02.034654+08:00 0 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces.
2023-01-01T08:00:02.034709+08:00 0 [Note] [MY-011825] [Xtrabackup] using the full scan for incremental backup
2023-01-01T08:00:02.174894+08:00 2 [Note] [MY-011825] [Xtrabackup] Compressing ./ibdata1 to /data/backup/2023-01-01/ibdata1.delta.qp
2023-01-01T08:00:02.215372+08:00 2 [Note] [MY-011825] [Xtrabackup] Done: Compressing ./ibdata1 to /data/backup/2023-01-01/ibdata1.delta.qp
2023-01-01T08:00:02.238742+08:00 2 [Note] [MY-011825] [Xtrabackup] Compressing ./sys/sys_config.ibd to /data/backup/2023-01-01/sys/sys_config.ibd.delta.qp
2023-01-01T08:00:02.239186+08:00 2 [Note] [MY-011825] [Xtrabackup] Done: Compressing ./sys/sys_config.ibd to /data/backup/2023-01-01/sys/sys_config.ibd.delta.qp
2023-01-01T08:00:02.260615+08:00 2 [Note] [MY-011825] [Xtrabackup] Compressing ./jycdb/test.ibd to /data/backup/2023-01-01/jycdb/test.ibd.delta.qp
2023-01-01T08:00:02.261031+08:00 2 [Note] [MY-011825] [Xtrabackup] Done: Compressing ./jycdb/test.ibd to /data/backup/2023-01-01/jycdb/test.ibd.delta.qp
2023-01-01T08:00:02.281130+08:00 2 [Note] [MY-011825] [Xtrabackup] Compressing ./jyc/t.ibd to /data/backup/2023-01-01/jyc/t.ibd.delta.qp
2023-01-01T08:00:02.281516+08:00 2 [Note] [MY-011825] [Xtrabackup] Done: Compressing ./jyc/t.ibd to /data/backup/2023-01-01/jyc/t.ibd.delta.qp
2023-01-01T08:00:02.303654+08:00 2 [Note] [MY-011825] [Xtrabackup] Compressing ./test/t.ibd to /data/backup/2023-01-01/test/t.ibd.delta.qp
2023-01-01T08:00:02.304016+08:00 2 [Note] [MY-011825] [Xtrabackup] Done: Compressing ./test/t.ibd to /data/backup/2023-01-01/test/t.ibd.delta.qp
2023-01-01T08:00:02.327589+08:00 2 [Note] [MY-011825] [Xtrabackup] Compressing ./mysql.ibd to /data/backup/2023-01-01/mysql.ibd.delta.qp
2023-01-01T08:00:02.418375+08:00 2 [Note] [MY-011825] [Xtrabackup] Done: Compressing ./mysql.ibd to /data/backup/2023-01-01/mysql.ibd.delta.qp
2023-01-01T08:00:02.437326+08:00 2 [Note] [MY-011825] [Xtrabackup] Compressing ./undo_002 to /data/backup/2023-01-01/undo_002.delta.qp
2023-01-01T08:00:02.490366+08:00 2 [Note] [MY-011825] [Xtrabackup] Done: Compressing ./undo_002 to /data/backup/2023-01-01/undo_002.delta.qp
2023-01-01T08:00:02.511682+08:00 2 [Note] [MY-011825] [Xtrabackup] Compressing ./undo_001 to /data/backup/2023-01-01/undo_001.delta.qp
2023-01-01T08:00:02.558802+08:00 2 [Note] [MY-011825] [Xtrabackup] Done: Compressing ./undo_001 to /data/backup/2023-01-01/undo_001.delta.qp
2023-01-01T08:00:02.814165+08:00 1 [Note] [MY-011825] [Xtrabackup] >> log scanned up to (20070978)
2023-01-01T08:00:03.039290+08:00 0 [Note] [MY-011825] [Xtrabackup] Starting to backup non-InnoDB tables and files
2023-01-01T08:00:03.040422+08:00 3 [Note] [MY-011825] [Xtrabackup] Compressing mysql/slow_log.CSM to /data/backup/2023-01-01/mysql/slow_log.CSM.qp
2023-01-01T08:00:03.041000+08:00 3 [Note] [MY-011825] [Xtrabackup] Done: Compressing mysql/slow_log.CSM to /data/backup/2023-01-01/mysql/slow_log.CSM.qp
2023-01-01T08:00:03.044338+08:00 3 [Note] [MY-011825] [Xtrabackup] Compressing mysql/slow_log.CSV to /data/backup/2023-01-01/mysql/slow_log.CSV.qp
2023-01-01T08:00:03.044382+08:00 3 [Note] [MY-011825] [Xtrabackup] Done: Compressing mysql/slow_log.CSV to /data/backup/2023-01-01/mysql/slow_log.CSV.qp
2023-01-01T08:00:03.045502+08:00 3 [Note] [MY-011825] [Xtrabackup] Compressing mysql/general_log.CSV to /data/backup/2023-01-01/mysql/general_log.CSV.qp
2023-01-01T08:00:03.045548+08:00 3 [Note] [MY-011825] [Xtrabackup] Done: Compressing mysql/general_log.CSV to /data/backup/2023-01-01/mysql/general_log.CSV.qp
2023-01-01T08:00:03.048696+08:00 3 [Note] [MY-011825] [Xtrabackup] Compressing mysql/general_log.CSM to /data/backup/2023-01-01/mysql/general_log.CSM.qp
2023-01-01T08:00:03.049204+08:00 3 [Note] [MY-011825] [Xtrabackup] Done: Compressing mysql/general_log.CSM to /data/backup/2023-01-01/mysql/general_log.CSM.qp
2023-01-01T08:00:03.052686+08:00 3 [Note] [MY-011825] [Xtrabackup] Compressing mysql/general_log_496.sdi to /data/backup/2023-01-01/mysql/general_log_496.sdi.qp
2023-01-01T08:00:03.053244+08:00 3 [Note] [MY-011825] [Xtrabackup] Done: Compressing mysql/general_log_496.sdi to /data/backup/2023-01-01/mysql/general_log_496.sdi.qp
2023-01-01T08:00:03.056418+08:00 3 [Note] [MY-011825] [Xtrabackup] Compressing mysql/slow_log_498.sdi to /data/backup/2023-01-01/mysql/slow_log_498.sdi.qp
2023-01-01T08:00:03.057100+08:00 3 [Note] [MY-011825] [Xtrabackup] Done: Compressing mysql/slow_log_498.sdi to /data/backup/2023-01-01/mysql/slow_log_498.sdi.qp
2023-01-01T08:00:03.058346+08:00 3 [Note] [MY-011825] [Xtrabackup] Compressing performance_schema/clone_status_381.sdi to /data/backup/2023-01-01/performance_schema/clone_status_381.sdi.qp
2023-01-01T08:00:03.059125+08:00 3 [Note] [MY-011825] [Xtrabackup] Done: Compressing performance_schema/clone_status_381.sdi to /data/backup/2023-01-01/performance_schema/clone_status_381.sdi.qp
2023-01-01T08:00:03.062698+08:00 3 [Note] [MY-011825] [Xtrabackup] Compressing performance_schema/clone_progress_382.sdi to /data/backup/2023-01-01/performance_schema/clone_progress_382.sdi.qp
2023-01-01T08:00:03.063365+08:00 3 [Note] [MY-011825] [Xtrabackup] Done: Compressing performance_schema/clone_progress_382.sdi to /data/backup/2023-01-01/performance_schema/clone_progress_382.sdi.qp
2023-01-01T08:00:03.140593+08:00 0 [Note] [MY-011825] [Xtrabackup] Finished backing up non-InnoDB tables and files
2023-01-01T08:00:03.140661+08:00 0 [Note] [MY-011825] [Xtrabackup] Executing FLUSH NO_WRITE_TO_BINLOG BINARY LOGS
2023-01-01T08:00:03.157153+08:00 0 [Note] [MY-011825] [Xtrabackup] Selecting LSN and binary log position from p_s.log_status
2023-01-01T08:00:03.161303+08:00 0 [Note] [MY-011825] [Xtrabackup] Compressing /mysql/data/mysql-bin.000009 to /data/backup/2023-01-01/mysql-bin.000009.qp up to position 237
2023-01-01T08:00:03.161562+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Compressing /mysql/data/mysql-bin.000009 to /data/backup/2023-01-01/mysql-bin.000009.qp
2023-01-01T08:00:03.165203+08:00 0 [Note] [MY-011825] [Xtrabackup] Compressing /data/backup/2023-01-01/mysql-bin.index.qp
2023-01-01T08:00:03.165372+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Compressing file /data/backup/2023-01-01/mysql-bin.index.qp
2023-01-01T08:00:03.171828+08:00 0 [Note] [MY-011825] [Xtrabackup] Compressing /data/backup/2023-01-01/xtrabackup_binlog_info.qp
2023-01-01T08:00:03.171963+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Compressing file /data/backup/2023-01-01/xtrabackup_binlog_info.qp
2023-01-01T08:00:03.173161+08:00 0 [Note] [MY-011825] [Xtrabackup] Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
2023-01-01T08:00:03.177022+08:00 0 [Note] [MY-011825] [Xtrabackup] The latest check point (for incremental): '20070978'
2023-01-01T08:00:03.177098+08:00 0 [Note] [MY-011825] [Xtrabackup] Stopping log copying thread at LSN 20070978
2023-01-01T08:00:03.177208+08:00 1 [Note] [MY-011825] [Xtrabackup] Starting to parse redo log at lsn = 20070928
2023-01-01T08:00:03.183305+08:00 0 [Note] [MY-011825] [Xtrabackup] Executing UNLOCK INSTANCE
2023-01-01T08:00:03.183484+08:00 0 [Note] [MY-011825] [Xtrabackup] All tables unlocked
2023-01-01T08:00:03.183705+08:00 0 [Note] [MY-011825] [Xtrabackup] Compressing ib_buffer_pool to /data/backup/2023-01-01/ib_buffer_pool.qp
2023-01-01T08:00:03.184540+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Compressing ib_buffer_pool to /data/backup/2023-01-01/ib_buffer_pool.qp
2023-01-01T08:00:03.186986+08:00 0 [Note] [MY-011825] [Xtrabackup] Backup created in directory '/data/backup/2023-01-01/'
2023-01-01T08:00:03.187028+08:00 0 [Note] [MY-011825] [Xtrabackup] MySQL binlog position: filename 'mysql-bin.000009', position '237', GTID of the last change '0489844a-85ae-11ed-97ee-d67f35a9de29:1-6,d0
271cef-7782-11ed-828a-d67f35a9de29:1-5'
2023-01-01T08:00:03.187225+08:00 0 [Note] [MY-011825] [Xtrabackup] Compressing /data/backup/2023-01-01/backup-my.cnf.qp
2023-01-01T08:00:03.187363+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Compressing file /data/backup/2023-01-01/backup-my.cnf.qp
2023-01-01T08:00:03.188733+08:00 0 [Note] [MY-011825] [Xtrabackup] Compressing /data/backup/2023-01-01/xtrabackup_info.qp
2023-01-01T08:00:03.188868+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Compressing file /data/backup/2023-01-01/xtrabackup_info.qp
2023-01-01T08:00:04.196413+08:00 0 [Note] [MY-011825] [Xtrabackup] Transaction log of lsn (20070978) to (20070988) was copied.
2023-01-01T08:00:04.406656+08:00 0 [Note] [MY-011825] [Xtrabackup] completed OK!
2023-01-02T08:00:01.123113+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized server arguments: --datadir=/mysql/data --innodb_buffer_pool_size=2G --innodb_flush_log_at_trx_commit=2 --log_bin=/mysql/data
/mysql-bin --server-id=2 
2023-01-02T08:00:01.123542+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized client arguments: --port=3306 --socket=/mysql/mysql.sock --port=3306 --user= --password=* --no-server-version-check=1 --socke
t=/mysql/mysql.sock --compress --compress-threads=2 --backup=1 --target-dir=/data/backup/2023-01-02 --incremental-basedir=/data/backup/2023-01-01 
/usr/bin/xtrabackup version 8.0.30-23 based on MySQL server 8.0.30 Linux (x86_64) (revision id: 873b467185c)
230102 08:00:01  version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;port=3306;mysql_socket=/mysql/mysql.sock' (using password: YES).
230102 08:00:01  version_check Connected to MySQL server
230102 08:00:01  version_check Executing a version check against the server...
230102 08:00:01  version_check Done.
2023-01-02T08:00:01.245820+08:00 0 [Note] [MY-011825] [Xtrabackup] Connecting to MySQL server host: localhost, user: , password: set, port: 3306, socket: /mysql/mysql.sock
2023-01-02T08:00:01.256005+08:00 0 [Note] [MY-011825] [Xtrabackup] Using server version 8.0.31
2023-01-02T08:00:01.261555+08:00 0 [Note] [MY-011825] [Xtrabackup] Executing LOCK INSTANCE FOR BACKUP ...
2023-01-02T08:00:01.263007+08:00 0 [Note] [MY-011825] [Xtrabackup] incremental backup from 20070978 is enabled.
2023-01-02T08:00:01.264936+08:00 0 [Note] [MY-011825] [Xtrabackup] uses posix_fadvise().
2023-01-02T08:00:01.265019+08:00 0 [Note] [MY-011825] [Xtrabackup] cd to /mysql/data
2023-01-02T08:00:01.265053+08:00 0 [Note] [MY-011825] [Xtrabackup] open files limit requested 0, set to 1024
2023-01-02T08:00:01.265212+08:00 0 [Note] [MY-011825] [Xtrabackup] using the following InnoDB configuration:
2023-01-02T08:00:01.265233+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_home_dir = .
2023-01-02T08:00:01.265249+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_file_path = ibdata1:12M:autoextend
2023-01-02T08:00:01.265335+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_group_home_dir = ./
2023-01-02T08:00:01.265353+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_files_in_group = 2
2023-01-02T08:00:01.265374+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_file_size = 50331648
2023-01-02T08:00:01.266442+08:00 0 [Note] [MY-013251] [InnoDB] Number of pools: 1
2023-01-02T08:00:01.268255+08:00 0 [Note] [MY-011825] [Xtrabackup] inititialize_service_handles suceeded
2023-01-02T08:00:01.554135+08:00 0 [Note] [MY-011825] [Xtrabackup] Connecting to MySQL server host: localhost, user: , password: set, port: 3306, socket: /mysql/mysql.sock
2023-01-02T08:00:01.561558+08:00 0 [Note] [MY-011825] [Xtrabackup] Redo Log Archiving is not set up.
2023-01-02T08:00:01.666838+08:00 1 [Note] [MY-011825] [Xtrabackup] >> log scanned up to (20070998)
2023-01-02T08:00:01.876227+08:00 0 [Note] [MY-011825] [Xtrabackup] Generating a list of tablespaces
2023-01-02T08:00:01.876367+08:00 0 [Note] [MY-011825] [Xtrabackup] Generating a list of tablespaces
2023-01-02T08:00:01.876400+08:00 0 [Note] [MY-012204] [InnoDB] Scanning './'
2023-01-02T08:00:01.879784+08:00 0 [Note] [MY-012208] [InnoDB] Completed space ID check of 2 files.
2023-01-02T08:00:01.882783+08:00 0 [Warning] [MY-012091] [InnoDB] Allocated tablespace ID 6 for test/t, old maximum was 0
2023-01-02T08:00:01.886415+08:00 0 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_001'.
2023-01-02T08:00:01.887444+08:00 0 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_002'.
2023-01-02T08:00:01.892149+08:00 0 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces.
2023-01-02T08:00:01.892209+08:00 0 [Note] [MY-011825] [Xtrabackup] using the full scan for incremental backup
2023-01-02T08:00:02.026441+08:00 2 [Note] [MY-011825] [Xtrabackup] Compressing ./ibdata1 to /data/backup/2023-01-02/ibdata1.delta.qp
2023-01-02T08:00:02.078176+08:00 2 [Note] [MY-011825] [Xtrabackup] Done: Compressing ./ibdata1 to /data/backup/2023-01-02/ibdata1.delta.qp
2023-01-02T08:00:02.098248+08:00 2 [Note] [MY-011825] [Xtrabackup] Compressing ./sys/sys_config.ibd to /data/backup/2023-01-02/sys/sys_config.ibd.delta.qp
2023-01-02T08:00:02.098673+08:00 2 [Note] [MY-011825] [Xtrabackup] Done: Compressing ./sys/sys_config.ibd to /data/backup/2023-01-02/sys/sys_config.ibd.delta.qp
2023-01-02T08:00:02.119615+08:00 2 [Note] [MY-011825] [Xtrabackup] Compressing ./jycdb/test.ibd to /data/backup/2023-01-02/jycdb/test.ibd.delta.qp
2023-01-02T08:00:02.120103+08:00 2 [Note] [MY-011825] [Xtrabackup] Done: Compressing ./jycdb/test.ibd to /data/backup/2023-01-02/jycdb/test.ibd.delta.qp
2023-01-02T08:00:02.140468+08:00 2 [Note] [MY-011825] [Xtrabackup] Compressing ./jyc/t.ibd to /data/backup/2023-01-02/jyc/t.ibd.delta.qp
2023-01-02T08:00:02.140860+08:00 2 [Note] [MY-011825] [Xtrabackup] Done: Compressing ./jyc/t.ibd to /data/backup/2023-01-02/jyc/t.ibd.delta.qp
2023-01-02T08:00:02.159494+08:00 2 [Note] [MY-011825] [Xtrabackup] Compressing ./test/t.ibd to /data/backup/2023-01-02/test/t.ibd.delta.qp
2023-01-02T08:00:02.159920+08:00 2 [Note] [MY-011825] [Xtrabackup] Done: Compressing ./test/t.ibd to /data/backup/2023-01-02/test/t.ibd.delta.qp
2023-01-02T08:00:02.183290+08:00 2 [Note] [MY-011825] [Xtrabackup] Compressing ./mysql.ibd to /data/backup/2023-01-02/mysql.ibd.delta.qp
2023-01-02T08:00:02.267477+08:00 2 [Note] [MY-011825] [Xtrabackup] Done: Compressing ./mysql.ibd to /data/backup/2023-01-02/mysql.ibd.delta.qp
2023-01-02T08:00:02.287821+08:00 2 [Note] [MY-011825] [Xtrabackup] Compressing ./undo_002 to /data/backup/2023-01-02/undo_002.delta.qp
2023-01-02T08:00:02.342019+08:00 2 [Note] [MY-011825] [Xtrabackup] Done: Compressing ./undo_002 to /data/backup/2023-01-02/undo_002.delta.qp
2023-01-02T08:00:02.361342+08:00 2 [Note] [MY-011825] [Xtrabackup] Compressing ./undo_001 to /data/backup/2023-01-02/undo_001.delta.qp
2023-01-02T08:00:02.408373+08:00 2 [Note] [MY-011825] [Xtrabackup] Done: Compressing ./undo_001 to /data/backup/2023-01-02/undo_001.delta.qp
2023-01-02T08:00:02.667173+08:00 1 [Note] [MY-011825] [Xtrabackup] >> log scanned up to (20070998)
2023-01-02T08:00:02.892572+08:00 0 [Note] [MY-011825] [Xtrabackup] Starting to backup non-InnoDB tables and files
2023-01-02T08:00:02.893729+08:00 3 [Note] [MY-011825] [Xtrabackup] Compressing mysql/slow_log.CSM to /data/backup/2023-01-02/mysql/slow_log.CSM.qp
2023-01-02T08:00:02.894329+08:00 3 [Note] [MY-011825] [Xtrabackup] Done: Compressing mysql/slow_log.CSM to /data/backup/2023-01-02/mysql/slow_log.CSM.qp
2023-01-02T08:00:02.895507+08:00 3 [Note] [MY-011825] [Xtrabackup] Compressing mysql/slow_log.CSV to /data/backup/2023-01-02/mysql/slow_log.CSV.qp
2023-01-02T08:00:02.895559+08:00 3 [Note] [MY-011825] [Xtrabackup] Done: Compressing mysql/slow_log.CSV to /data/backup/2023-01-02/mysql/slow_log.CSV.qp
2023-01-02T08:00:02.897683+08:00 3 [Note] [MY-011825] [Xtrabackup] Compressing mysql/general_log.CSV to /data/backup/2023-01-02/mysql/general_log.CSV.qp
2023-01-02T08:00:02.897725+08:00 3 [Note] [MY-011825] [Xtrabackup] Done: Compressing mysql/general_log.CSV to /data/backup/2023-01-02/mysql/general_log.CSV.qp
2023-01-02T08:00:02.899834+08:00 3 [Note] [MY-011825] [Xtrabackup] Compressing mysql/general_log.CSM to /data/backup/2023-01-02/mysql/general_log.CSM.qp
2023-01-02T08:00:02.900228+08:00 3 [Note] [MY-011825] [Xtrabackup] Done: Compressing mysql/general_log.CSM to /data/backup/2023-01-02/mysql/general_log.CSM.qp
2023-01-02T08:00:02.902298+08:00 3 [Note] [MY-011825] [Xtrabackup] Compressing mysql/general_log_496.sdi to /data/backup/2023-01-02/mysql/general_log_496.sdi.qp
2023-01-02T08:00:02.902862+08:00 3 [Note] [MY-011825] [Xtrabackup] Done: Compressing mysql/general_log_496.sdi to /data/backup/2023-01-02/mysql/general_log_496.sdi.qp
2023-01-02T08:00:02.904882+08:00 3 [Note] [MY-011825] [Xtrabackup] Compressing mysql/slow_log_498.sdi to /data/backup/2023-01-02/mysql/slow_log_498.sdi.qp
2023-01-02T08:00:02.905436+08:00 3 [Note] [MY-011825] [Xtrabackup] Done: Compressing mysql/slow_log_498.sdi to /data/backup/2023-01-02/mysql/slow_log_498.sdi.qp
2023-01-02T08:00:02.906672+08:00 3 [Note] [MY-011825] [Xtrabackup] Compressing performance_schema/clone_status_381.sdi to /data/backup/2023-01-02/performance_schema/clone_status_381.sdi.qp
2023-01-02T08:00:02.907472+08:00 3 [Note] [MY-011825] [Xtrabackup] Done: Compressing performance_schema/clone_status_381.sdi to /data/backup/2023-01-02/performance_schema/clone_status_381.sdi.qp
2023-01-02T08:00:02.909615+08:00 3 [Note] [MY-011825] [Xtrabackup] Compressing performance_schema/clone_progress_382.sdi to /data/backup/2023-01-02/performance_schema/clone_progress_382.sdi.qp
2023-01-02T08:00:02.910227+08:00 3 [Note] [MY-011825] [Xtrabackup] Done: Compressing performance_schema/clone_progress_382.sdi to /data/backup/2023-01-02/performance_schema/clone_progress_382.sdi.qp
2023-01-02T08:00:02.993896+08:00 0 [Note] [MY-011825] [Xtrabackup] Finished backing up non-InnoDB tables and files
2023-01-02T08:00:02.993971+08:00 0 [Note] [MY-011825] [Xtrabackup] Executing FLUSH NO_WRITE_TO_BINLOG BINARY LOGS
2023-01-02T08:00:03.005147+08:00 0 [Note] [MY-011825] [Xtrabackup] Selecting LSN and binary log position from p_s.log_status
2023-01-02T08:00:03.009920+08:00 0 [Note] [MY-011825] [Xtrabackup] Compressing /mysql/data/mysql-bin.000010 to /data/backup/2023-01-02/mysql-bin.000010.qp up to position 237
2023-01-02T08:00:03.010150+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Compressing /mysql/data/mysql-bin.000010 to /data/backup/2023-01-02/mysql-bin.000010.qp
2023-01-02T08:00:03.013186+08:00 0 [Note] [MY-011825] [Xtrabackup] Compressing /data/backup/2023-01-02/mysql-bin.index.qp
2023-01-02T08:00:03.013321+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Compressing file /data/backup/2023-01-02/mysql-bin.index.qp
2023-01-02T08:00:03.019110+08:00 0 [Note] [MY-011825] [Xtrabackup] Compressing /data/backup/2023-01-02/xtrabackup_binlog_info.qp
2023-01-02T08:00:03.019240+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Compressing file /data/backup/2023-01-02/xtrabackup_binlog_info.qp
2023-01-02T08:00:03.022241+08:00 0 [Note] [MY-011825] [Xtrabackup] Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
2023-01-02T08:00:03.026731+08:00 0 [Note] [MY-011825] [Xtrabackup] The latest check point (for incremental): '20070998'
2023-01-02T08:00:03.026780+08:00 0 [Note] [MY-011825] [Xtrabackup] Stopping log copying thread at LSN 20070998
2023-01-02T08:00:03.026925+08:00 1 [Note] [MY-011825] [Xtrabackup] Starting to parse redo log at lsn = 20070928
2023-01-02T08:00:03.032872+08:00 0 [Note] [MY-011825] [Xtrabackup] Executing UNLOCK INSTANCE
2023-01-02T08:00:03.033085+08:00 0 [Note] [MY-011825] [Xtrabackup] All tables unlocked
2023-01-02T08:00:03.033552+08:00 0 [Note] [MY-011825] [Xtrabackup] Compressing ib_buffer_pool to /data/backup/2023-01-02/ib_buffer_pool.qp
2023-01-02T08:00:03.034222+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Compressing ib_buffer_pool to /data/backup/2023-01-02/ib_buffer_pool.qp
2023-01-02T08:00:03.035797+08:00 0 [Note] [MY-011825] [Xtrabackup] Backup created in directory '/data/backup/2023-01-02/'
2023-01-02T08:00:03.035835+08:00 0 [Note] [MY-011825] [Xtrabackup] MySQL binlog position: filename 'mysql-bin.000010', position '237', GTID of the last change '0489844a-85ae-11ed-97ee-d67f35a9de29:1-6,d0
271cef-7782-11ed-828a-d67f35a9de29:1-5'
2023-01-02T08:00:03.036322+08:00 0 [Note] [MY-011825] [Xtrabackup] Compressing /data/backup/2023-01-02/backup-my.cnf.qp
2023-01-02T08:00:03.036462+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Compressing file /data/backup/2023-01-02/backup-my.cnf.qp
2023-01-02T08:00:03.040209+08:00 0 [Note] [MY-011825] [Xtrabackup] Compressing /data/backup/2023-01-02/xtrabackup_info.qp
2023-01-02T08:00:03.040365+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Compressing file /data/backup/2023-01-02/xtrabackup_info.qp
2023-01-02T08:00:04.047643+08:00 0 [Note] [MY-011825] [Xtrabackup] Transaction log of lsn (20070998) to (20071008) was copied.
2023-01-02T08:00:04.258195+08:00 0 [Note] [MY-011825] [Xtrabackup] completed OK!
[root@mysql2 backuplog]#    
[root@mysql2 backuplog]# more backup_full_success.log
2022-12-30T12:21:31.353409+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized server arguments: --datadir=/mysql/data --innodb_buffer_pool_size=2G --innodb_flush_log_at_trx_commit=2 --log_bin=/mysql/data
/mysql-bin --server-id=2 
2022-12-30T12:21:31.353798+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized client arguments: --port=3306 --socket=/mysql/mysql.sock --user= --password=* --no-server-version-check=1 --socket=/mysql/mys
ql.sock --compress --compress-threads=2 --backup=1 --target-dir=/data/backup/2022-12-30 
/usr/bin/xtrabackup version 8.0.30-23 based on MySQL server 8.0.30 Linux (x86_64) (revision id: 873b467185c)
221230 12:21:31  version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;port=3306;mysql_socket=/mysql/mysql.sock' (using password: YES).
221230 12:21:31  version_check Connected to MySQL server
221230 12:21:31  version_check Executing a version check against the server...
221230 12:21:31  version_check Done.
2022-12-30T12:21:31.465808+08:00 0 [Note] [MY-011825] [Xtrabackup] Connecting to MySQL server host: localhost, user: , password: set, port: 3306, socket: /mysql/mysql.sock
2022-12-30T12:21:31.473800+08:00 0 [Note] [MY-011825] [Xtrabackup] Using server version 8.0.31
2022-12-30T12:21:31.477962+08:00 0 [Note] [MY-011825] [Xtrabackup] Executing LOCK INSTANCE FOR BACKUP ...
2022-12-30T12:21:31.480744+08:00 0 [Note] [MY-011825] [Xtrabackup] uses posix_fadvise().
2022-12-30T12:21:31.480820+08:00 0 [Note] [MY-011825] [Xtrabackup] cd to /mysql/data
2022-12-30T12:21:31.480866+08:00 0 [Note] [MY-011825] [Xtrabackup] open files limit requested 0, set to 1024
2022-12-30T12:21:31.480967+08:00 0 [Note] [MY-011825] [Xtrabackup] using the following InnoDB configuration:
2022-12-30T12:21:31.480987+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_home_dir = .
2022-12-30T12:21:31.481002+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_file_path = ibdata1:12M:autoextend
2022-12-30T12:21:31.481100+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_group_home_dir = ./
2022-12-30T12:21:31.481124+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_files_in_group = 2
2022-12-30T12:21:31.481145+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_file_size = 50331648
2022-12-30T12:21:31.482216+08:00 0 [Note] [MY-013251] [InnoDB] Number of pools: 1
2022-12-30T12:21:31.483737+08:00 0 [Note] [MY-011825] [Xtrabackup] inititialize_service_handles suceeded
2022-12-30T12:21:31.646150+08:00 0 [Note] [MY-011825] [Xtrabackup] Connecting to MySQL server host: localhost, user: , password: set, port: 3306, socket: /mysql/mysql.sock
2022-12-30T12:21:31.653483+08:00 0 [Note] [MY-011825] [Xtrabackup] Redo Log Archiving is not set up.
2022-12-30T12:21:31.758171+08:00 1 [Note] [MY-011825] [Xtrabackup] >> log scanned up to (20070938)
2022-12-30T12:21:31.963465+08:00 0 [Note] [MY-011825] [Xtrabackup] Generating a list of tablespaces
2022-12-30T12:21:31.963587+08:00 0 [Note] [MY-011825] [Xtrabackup] Generating a list of tablespaces
2022-12-30T12:21:31.963619+08:00 0 [Note] [MY-012204] [InnoDB] Scanning './'
2022-12-30T12:21:31.966760+08:00 0 [Note] [MY-012208] [InnoDB] Completed space ID check of 2 files.
2022-12-30T12:21:31.969616+08:00 0 [Warning] [MY-012091] [InnoDB] Allocated tablespace ID 6 for test/t, old maximum was 0
2022-12-30T12:21:31.972875+08:00 0 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_001'.
2022-12-30T12:21:31.973784+08:00 0 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_002'.
2022-12-30T12:21:31.978073+08:00 0 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces.
2022-12-30T12:21:31.978697+08:00 2 [Note] [MY-011825] [Xtrabackup] Compressing ./ibdata1 to /data/backup/2022-12-30/ibdata1.qp
2022-12-30T12:21:32.036537+08:00 2 [Note] [MY-011825] [Xtrabackup] Done: Compressing ./ibdata1 to /data/backup/2022-12-30/ibdata1.qp
2022-12-30T12:21:32.039594+08:00 2 [Note] [MY-011825] [Xtrabackup] Compressing ./sys/sys_config.ibd to /data/backup/2022-12-30/sys/sys_config.ibd.qp
2022-12-30T12:21:32.040214+08:00 2 [Note] [MY-011825] [Xtrabackup] Done: Compressing ./sys/sys_config.ibd to /data/backup/2022-12-30/sys/sys_config.ibd.qp
2022-12-30T12:21:32.042584+08:00 2 [Note] [MY-011825] [Xtrabackup] Compressing ./jycdb/test.ibd to /data/backup/2022-12-30/jycdb/test.ibd.qp
2022-12-30T12:21:32.043142+08:00 2 [Note] [MY-011825] [Xtrabackup] Done: Compressing ./jycdb/test.ibd to /data/backup/2022-12-30/jycdb/test.ibd.qp
2022-12-30T12:21:32.045534+08:00 2 [Note] [MY-011825] [Xtrabackup] Compressing ./jyc/t.ibd to /data/backup/2022-12-30/jyc/t.ibd.qp
2022-12-30T12:21:32.046102+08:00 2 [Note] [MY-011825] [Xtrabackup] Done: Compressing ./jyc/t.ibd to /data/backup/2022-12-30/jyc/t.ibd.qp
2022-12-30T12:21:32.048279+08:00 2 [Note] [MY-011825] [Xtrabackup] Compressing ./test/t.ibd to /data/backup/2022-12-30/test/t.ibd.qp
2022-12-30T12:21:32.048810+08:00 2 [Note] [MY-011825] [Xtrabackup] Done: Compressing ./test/t.ibd to /data/backup/2022-12-30/test/t.ibd.qp
2022-12-30T12:21:32.049776+08:00 2 [Note] [MY-011825] [Xtrabackup] Compressing ./mysql.ibd to /data/backup/2022-12-30/mysql.ibd.qp
2022-12-30T12:21:32.152348+08:00 2 [Note] [MY-011825] [Xtrabackup] Done: Compressing ./mysql.ibd to /data/backup/2022-12-30/mysql.ibd.qp
2022-12-30T12:21:32.161102+08:00 2 [Note] [MY-011825] [Xtrabackup] Compressing ./undo_002 to /data/backup/2022-12-30/undo_002.qp
2022-12-30T12:21:32.228259+08:00 2 [Note] [MY-011825] [Xtrabackup] Done: Compressing ./undo_002 to /data/backup/2022-12-30/undo_002.qp
2022-12-30T12:21:32.232033+08:00 2 [Note] [MY-011825] [Xtrabackup] Compressing ./undo_001 to /data/backup/2022-12-30/undo_001.qp
2022-12-30T12:21:32.292956+08:00 2 [Note] [MY-011825] [Xtrabackup] Done: Compressing ./undo_001 to /data/backup/2022-12-30/undo_001.qp
2022-12-30T12:21:32.758433+08:00 1 [Note] [MY-011825] [Xtrabackup] >> log scanned up to (20070938)
2022-12-30T12:21:32.978509+08:00 0 [Note] [MY-011825] [Xtrabackup] Starting to backup non-InnoDB tables and files
2022-12-30T12:21:32.979562+08:00 3 [Note] [MY-011825] [Xtrabackup] Compressing mysql/slow_log.CSM to /data/backup/2022-12-30/mysql/slow_log.CSM.qp
2022-12-30T12:21:32.981085+08:00 3 [Note] [MY-011825] [Xtrabackup] Done: Compressing mysql/slow_log.CSM to /data/backup/2022-12-30/mysql/slow_log.CSM.qp
2022-12-30T12:21:32.983815+08:00 3 [Note] [MY-011825] [Xtrabackup] Compressing mysql/slow_log.CSV to /data/backup/2022-12-30/mysql/slow_log.CSV.qp
2022-12-30T12:21:32.983859+08:00 3 [Note] [MY-011825] [Xtrabackup] Done: Compressing mysql/slow_log.CSV to /data/backup/2022-12-30/mysql/slow_log.CSV.qp
2022-12-30T12:21:32.985816+08:00 3 [Note] [MY-011825] [Xtrabackup] Compressing mysql/general_log.CSV to /data/backup/2022-12-30/mysql/general_log.CSV.qp
2022-12-30T12:21:32.985860+08:00 3 [Note] [MY-011825] [Xtrabackup] Done: Compressing mysql/general_log.CSV to /data/backup/2022-12-30/mysql/general_log.CSV.qp
2022-12-30T12:21:32.987789+08:00 3 [Note] [MY-011825] [Xtrabackup] Compressing mysql/general_log.CSM to /data/backup/2022-12-30/mysql/general_log.CSM.qp
2022-12-30T12:21:32.988273+08:00 3 [Note] [MY-011825] [Xtrabackup] Done: Compressing mysql/general_log.CSM to /data/backup/2022-12-30/mysql/general_log.CSM.qp
2022-12-30T12:21:32.990222+08:00 3 [Note] [MY-011825] [Xtrabackup] Compressing mysql/general_log_496.sdi to /data/backup/2022-12-30/mysql/general_log_496.sdi.qp
2022-12-30T12:21:32.990665+08:00 3 [Note] [MY-011825] [Xtrabackup] Done: Compressing mysql/general_log_496.sdi to /data/backup/2022-12-30/mysql/general_log_496.sdi.qp
2022-12-30T12:21:32.992667+08:00 3 [Note] [MY-011825] [Xtrabackup] Compressing mysql/slow_log_498.sdi to /data/backup/2022-12-30/mysql/slow_log_498.sdi.qp
2022-12-30T12:21:32.993229+08:00 3 [Note] [MY-011825] [Xtrabackup] Done: Compressing mysql/slow_log_498.sdi to /data/backup/2022-12-30/mysql/slow_log_498.sdi.qp
2022-12-30T12:21:32.995261+08:00 3 [Note] [MY-011825] [Xtrabackup] Compressing performance_schema/clone_status_381.sdi to /data/backup/2022-12-30/performance_schema/clone_status_381.sdi.qp
2022-12-30T12:21:32.995865+08:00 3 [Note] [MY-011825] [Xtrabackup] Done: Compressing performance_schema/clone_status_381.sdi to /data/backup/2022-12-30/performance_schema/clone_status_381.sdi.qp
2022-12-30T12:21:32.997787+08:00 3 [Note] [MY-011825] [Xtrabackup] Compressing performance_schema/clone_progress_382.sdi to /data/backup/2022-12-30/performance_schema/clone_progress_382.sdi.qp
2022-12-30T12:21:32.998251+08:00 3 [Note] [MY-011825] [Xtrabackup] Done: Compressing performance_schema/clone_progress_382.sdi to /data/backup/2022-12-30/performance_schema/clone_progress_382.sdi.qp
2022-12-30T12:21:33.079756+08:00 0 [Note] [MY-011825] [Xtrabackup] Finished backing up non-InnoDB tables and files
2022-12-30T12:21:33.079821+08:00 0 [Note] [MY-011825] [Xtrabackup] Executing FLUSH NO_WRITE_TO_BINLOG BINARY LOGS
2022-12-30T12:21:33.087465+08:00 0 [Note] [MY-011825] [Xtrabackup] Selecting LSN and binary log position from p_s.log_status
2022-12-30T12:21:33.091314+08:00 0 [Note] [MY-011825] [Xtrabackup] Compressing /mysql/data/mysql-bin.000007 to /data/backup/2022-12-30/mysql-bin.000007.qp up to position 237
2022-12-30T12:21:33.091531+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Compressing /mysql/data/mysql-bin.000007 to /data/backup/2022-12-30/mysql-bin.000007.qp
2022-12-30T12:21:33.093660+08:00 0 [Note] [MY-011825] [Xtrabackup] Compressing /data/backup/2022-12-30/mysql-bin.index.qp
2022-12-30T12:21:33.093832+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Compressing file /data/backup/2022-12-30/mysql-bin.index.qp
2022-12-30T12:21:33.099094+08:00 0 [Note] [MY-011825] [Xtrabackup] Compressing /data/backup/2022-12-30/xtrabackup_binlog_info.qp
2022-12-30T12:21:33.099224+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Compressing file /data/backup/2022-12-30/xtrabackup_binlog_info.qp
2022-12-30T12:21:33.101248+08:00 0 [Note] [MY-011825] [Xtrabackup] Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
2022-12-30T12:21:33.103671+08:00 0 [Note] [MY-011825] [Xtrabackup] The latest check point (for incremental): '20070938'
2022-12-30T12:21:33.103713+08:00 0 [Note] [MY-011825] [Xtrabackup] Stopping log copying thread at LSN 20070938
2022-12-30T12:21:33.103839+08:00 1 [Note] [MY-011825] [Xtrabackup] Starting to parse redo log at lsn = 20070928
2022-12-30T12:21:33.107282+08:00 0 [Note] [MY-011825] [Xtrabackup] Executing UNLOCK INSTANCE
2022-12-30T12:21:33.107443+08:00 0 [Note] [MY-011825] [Xtrabackup] All tables unlocked
2022-12-30T12:21:33.107643+08:00 0 [Note] [MY-011825] [Xtrabackup] Compressing ib_buffer_pool to /data/backup/2022-12-30/ib_buffer_pool.qp
2022-12-30T12:21:33.108204+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Compressing ib_buffer_pool to /data/backup/2022-12-30/ib_buffer_pool.qp
2022-12-30T12:21:33.111130+08:00 0 [Note] [MY-011825] [Xtrabackup] Backup created in directory '/data/backup/2022-12-30/'
2022-12-30T12:21:33.111169+08:00 0 [Note] [MY-011825] [Xtrabackup] MySQL binlog position: filename 'mysql-bin.000007', position '237', GTID of the last change '0489844a-85ae-11ed-97ee-d67f35a9de29:1-6,d0
271cef-7782-11ed-828a-d67f35a9de29:1-5'
2022-12-30T12:21:33.111334+08:00 0 [Note] [MY-011825] [Xtrabackup] Compressing /data/backup/2022-12-30/backup-my.cnf.qp
2022-12-30T12:21:33.111407+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Compressing file /data/backup/2022-12-30/backup-my.cnf.qp
2022-12-30T12:21:33.112718+08:00 0 [Note] [MY-011825] [Xtrabackup] Compressing /data/backup/2022-12-30/xtrabackup_info.qp
2022-12-30T12:21:33.112854+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Compressing file /data/backup/2022-12-30/xtrabackup_info.qp
2022-12-30T12:21:34.116780+08:00 0 [Note] [MY-011825] [Xtrabackup] Transaction log of lsn (20070938) to (20070948) was copied.
2022-12-30T12:21:34.327543+08:00 0 [Note] [MY-011825] [Xtrabackup] completed OK!
[root@mysql2 backuplog]#    

准备阶段：

[root@mysql2 backup]# xtrabackup --prepare --apply-log-only --target-dir=/data/backup/2022-12-30
2023-01-03T12:15:11.054723+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized client arguments: --prepare=1 --apply-log-only=1 --target-dir=/data/backup/2022-12-30 
xtrabackup version 8.0.30-23 based on MySQL server 8.0.30 Linux (x86_64) (revision id: 873b467185c)
2023-01-03T12:15:11.054974+08:00 0 [Note] [MY-011825] [Xtrabackup] cd to /data/backup/2022-12-30/
2023-01-03T12:15:11.055254+08:00 0 [Note] [MY-011825] [Xtrabackup] This target seems to be not prepared yet.
2023-01-03T12:15:11.056126+08:00 0 [Note] [MY-013251] [InnoDB] Number of pools: 1
2023-01-03T12:15:11.056347+08:00 0 [ERROR] [MY-012592] [InnoDB] Operating system error number 2 in a file operation.
2023-01-03T12:15:11.056375+08:00 0 [ERROR] [MY-012593] [InnoDB] The error means the system cannot find the path specified.
2023-01-03T12:15:11.056392+08:00 0 [Warning] [MY-011825] [Xtrabackup] cannot open ./xtrabackup_logfile will try to find.
2023-01-03T12:15:11.057147+08:00 0 [Note] [MY-011825] [Xtrabackup] using the following InnoDB configuration for recovery:
2023-01-03T12:15:11.057175+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_home_dir = .
2023-01-03T12:15:11.057191+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_file_path = ibdata1:10M:autoextend
2023-01-03T12:15:11.057263+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_group_home_dir = .
2023-01-03T12:15:11.057285+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_files_in_group = 2
2023-01-03T12:15:11.057305+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_file_size = 50331648
2023-01-03T12:15:11.057552+08:00 0 [Note] [MY-011825] [Xtrabackup] inititialize_service_handles suceeded
2023-01-03T12:15:11.057642+08:00 0 [ERROR] [MY-011825] [Xtrabackup] cannot open file './xtrabackup_tablespaces'
2023-01-03T12:15:11.057782+08:00 0 [Note] [MY-011825] [Xtrabackup] using the following InnoDB configuration for recovery:
2023-01-03T12:15:11.057804+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_home_dir = .
2023-01-03T12:15:11.057820+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_file_path = ibdata1:10M:autoextend
2023-01-03T12:15:11.057846+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_group_home_dir = .
2023-01-03T12:15:11.057862+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_files_in_group = 2
2023-01-03T12:15:11.057877+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_file_size = 50331648
2023-01-03T12:15:11.057902+08:00 0 [Note] [MY-011825] [Xtrabackup] Starting InnoDB instance for recovery.
2023-01-03T12:15:11.057924+08:00 0 [Note] [MY-011825] [Xtrabackup] Using 104857600 bytes for buffer pool (set by --use-memory parameter)
2023-01-03T12:15:11.057986+08:00 0 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available
2023-01-03T12:15:11.058043+08:00 0 [Note] [MY-012944] [InnoDB] Uses event mutexes
2023-01-03T12:15:11.058086+08:00 0 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier
2023-01-03T12:15:11.058115+08:00 0 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.12
2023-01-03T12:15:11.058352+08:00 0 [Note] [MY-013251] [InnoDB] Number of pools: 1
2023-01-03T12:15:11.058534+08:00 0 [Note] [MY-012951] [InnoDB] Using software crc32.
2023-01-03T12:15:11.059382+08:00 0 [Note] [MY-012203] [InnoDB] Directories to scan './'
2023-01-03T12:15:11.059467+08:00 0 [Note] [MY-012204] [InnoDB] Scanning './'
2023-01-03T12:15:11.060046+08:00 0 [Note] [MY-012208] [InnoDB] Completed space ID check of 0 files.
2023-01-03T12:15:11.061211+08:00 0 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 128.000000M, instances = 1, chunk size =128.000000M 
2023-01-03T12:15:11.075910+08:00 0 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool
2023-01-03T12:15:11.088396+08:00 0 [ERROR] [MY-012592] [InnoDB] Operating system error number 2 in a file operation.
2023-01-03T12:15:11.088437+08:00 0 [ERROR] [MY-012593] [InnoDB] The error means the system cannot find the path specified.
2023-01-03T12:15:11.088457+08:00 0 [ERROR] [MY-012594] [InnoDB] If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
2023-01-03T12:15:11.088476+08:00 0 [ERROR] [MY-012646] [InnoDB] File ./ibdata1: 'open' returned OS error 71. Cannot continue operation
2023-01-03T12:15:11.088494+08:00 0 [ERROR] [MY-012981] [InnoDB] Cannot continue operation.
[root@mysql2 backup]# find / -name ibdata1
/mysql/data.bak/ibdata1
/mysql/data/ibdata1
/backup/ibdata1
/bak/ibdata1
[root@mysql2 backup]# ll /backup
total 90148
-rw-r-----. 1 root root      447 Dec 27 14:09 backup-my.cnf
-rw-r-----. 1 root root     4138 Dec 27 14:09 ib_buffer_pool
-rw-r-----. 1 root root 12582912 Dec 27 14:12 ibdata1
-rw-r-----. 1 root root 12582912 Dec 27 14:12 ibtmp1
drwxr-x---. 2 root root        6 Dec 27 14:12 #innodb_redo
drwxr-x---. 2 root root       19 Dec 27 14:09 j
drwxr-x---. 2 root root       19 Dec 27 14:09 jyc
drwxr-x---. 2 root root       22 Dec 27 14:09 jycdb
drwxr-x---. 2 root root      143 Dec 27 14:09 mysql
-rw-r-----. 1 root root      197 Dec 27 14:09 mysql-bin.000002
-rw-r-----. 1 root root       29 Dec 27 14:09 mysql-bin.index
-rw-r-----. 1 root root 25165824 Dec 27 14:11 mysql.ibd
drwxr-x---. 2 root root       64 Dec 27 14:09 performance_schema
drwxr-x---. 2 root root       28 Dec 27 14:09 sys
drwxr-x---. 2 root root       19 Dec 27 14:09 t
-rw-r-----. 1 root root 16777216 Dec 27 14:11 undo_001
-rw-r-----. 1 root root 16777216 Dec 27 14:11 undo_002
-rw-r-----. 1 root root       62 Dec 27 14:09 xtrabackup_binlog_info
-rw-r-----. 1 root root      138 Dec 27 14:12 xtrabackup_checkpoints
-rw-r-----. 1 root root      570 Dec 27 14:09 xtrabackup_info
-rw-r-----. 1 root root  8388608 Dec 27 14:11 xtrabackup_logfile
-rw-r-----. 1 root root       39 Dec 27 14:12 xtrabackup_tablespaces
[root@mysql2 backup]# rpm -aq|grep press
perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64
perl-IO-Compress-2.061-2.el7.noarch
perl-Compress-Raw-Zlib-2.061-4.el7.x86_64
qpress-11-3.el7.x86_64
[root@mysql2 backup]# ll /data/backup/2022-12-30/
total 3108
-rw-r-----. 1 root root     445 Dec 30 12:21 backup-my.cnf.qp
-rw-r-----. 1 root root    1100 Dec 30 12:21 ib_buffer_pool.qp
-rw-r-----. 1 root root  167048 Dec 30 12:21 ibdata1.qp
drwxr-x---. 2 root root       6 Jan  3 12:12 #innodb_redo
drwxr-x---. 2 root root      22 Dec 30 12:21 jyc
drwxr-x---. 2 root root      25 Dec 30 12:21 jycdb
drwxr-x---. 2 root root     161 Dec 30 12:21 mysql
-rw-r-----. 1 root root     242 Dec 30 12:21 mysql-bin.000007.qp
-rw-r-----. 1 root root     106 Dec 30 12:21 mysql-bin.index.qp
-rw-r-----. 1 root root 2375083 Dec 30 12:21 mysql.ibd.qp
drwxr-x---. 2 root root      70 Dec 30 12:21 performance_schema
drwxr-x---. 2 root root      31 Dec 30 12:21 sys
drwxr-x---. 2 root root      22 Dec 30 12:21 test
-rw-r-----. 1 root root  302906 Dec 30 12:21 undo_001.qp
-rw-r-----. 1 root root  298824 Dec 30 12:21 undo_002.qp
-rw-r-----. 1 root root     186 Dec 30 12:21 xtrabackup_binlog_info.qp
-rw-r-----. 1 root root     136 Dec 30 12:21 xtrabackup_checkpoints
-rw-r-----. 1 root root     639 Dec 30 12:21 xtrabackup_info.qp
-rw-r-----. 1 root root     270 Dec 30 12:21 xtrabackup_logfile.qp
-rw-r-----. 1 root root     130 Dec 30 12:21 xtrabackup_tablespaces.qp
[root@mysql2 backup]# xtrabackup --decompress --prepare --target-dir=/data/backup/2022-12-30
2023-01-03T12:21:53.638572+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized client arguments: --decompress=1 --prepare=1 --target-dir=/data/backup/2022-12-30 
xtrabackup version 8.0.30-23 based on MySQL server 8.0.30 Linux (x86_64) (revision id: 873b467185c)
2023-01-03T12:21:53.638812+08:00 0 [ERROR] [MY-011825] [Xtrabackup] --decompress and --apply-log are mutually exclusive
[root@mysql2 backup]# xtrabackup --prepare --apply-log-only --decompress  --target-dir=/data/backup/2022-12-30
2023-01-03T12:22:21.151305+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized client arguments: --prepare=1 --apply-log-only=1 --decompress=1 --target-dir=/data/backup/2022-12-30 
xtrabackup version 8.0.30-23 based on MySQL server 8.0.30 Linux (x86_64) (revision id: 873b467185c)
2023-01-03T12:22:21.151548+08:00 0 [ERROR] [MY-011825] [Xtrabackup] --decompress and --apply-log are mutually exclusive
[root@mysql2 backup]# xtrabackup --prepare --apply-log --decompress  --target-dir=/data/backup/2022-12-30
2023-01-03T12:22:29.859678+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized client arguments: --prepare=1 --decompress=1 --target-dir=/data/backup/2022-12-30 
xtrabackup version 8.0.30-23 based on MySQL server 8.0.30 Linux (x86_64) (revision id: 873b467185c)
2023-01-03T12:22:29.859929+08:00 0 [ERROR] [MY-011825] [Xtrabackup] --decompress and --apply-log are mutually exclusive
[root@mysql2 backup]# xtrabackup --decompress --remove-original --target-dir=/data/backup/2022-12-30
2023-01-03T12:25:02.342604+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized server arguments: --datadir=/mysql/data --innodb_buffer_pool_size=2G --innodb_flush_log_at_trx_commit=2 --log_bin=/mysql/data/mysql-bin --server-id=2 
2023-01-03T12:25:02.342978+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized client arguments: --port=3306 --socket=/mysql/mysql.sock --decompress=1 --remove-original=1 --target-dir=/data/backup/2022-12-30 
xtrabackup version 8.0.30-23 based on MySQL server 8.0.30 Linux (x86_64) (revision id: 873b467185c)
2023-01-03T12:25:02.343996+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./xtrabackup_logfile.qp
2023-01-03T12:25:02.352096+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./xtrabackup_logfile.qp
2023-01-03T12:25:02.352277+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./ibdata1.qp
2023-01-03T12:25:02.379271+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./ibdata1.qp
2023-01-03T12:25:02.379530+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./sys/sys_config.ibd.qp
2023-01-03T12:25:02.386866+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./sys/sys_config.ibd.qp
2023-01-03T12:25:02.387023+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./jycdb/test.ibd.qp
2023-01-03T12:25:02.393651+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./jycdb/test.ibd.qp
2023-01-03T12:25:02.393810+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./jyc/t.ibd.qp
2023-01-03T12:25:02.400479+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./jyc/t.ibd.qp
2023-01-03T12:25:02.400638+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./test/t.ibd.qp
2023-01-03T12:25:02.407905+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./test/t.ibd.qp
2023-01-03T12:25:02.408095+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./mysql.ibd.qp
2023-01-03T12:25:02.480330+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./mysql.ibd.qp
2023-01-03T12:25:02.481540+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./undo_002.qp
2023-01-03T12:25:02.532678+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./undo_002.qp
2023-01-03T12:25:02.533034+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./undo_001.qp
2023-01-03T12:25:02.592272+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./undo_001.qp
2023-01-03T12:25:02.592590+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./mysql/slow_log.CSM.qp
2023-01-03T12:25:02.599739+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./mysql/slow_log.CSM.qp
2023-01-03T12:25:02.599936+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./mysql/slow_log.CSV.qp
2023-01-03T12:25:02.606687+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./mysql/slow_log.CSV.qp
2023-01-03T12:25:02.606883+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./mysql/general_log.CSV.qp
2023-01-03T12:25:02.613803+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./mysql/general_log.CSV.qp
2023-01-03T12:25:02.613961+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./mysql/general_log.CSM.qp
2023-01-03T12:25:02.622347+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./mysql/general_log.CSM.qp
2023-01-03T12:25:02.622514+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./mysql/general_log_496.sdi.qp
2023-01-03T12:25:02.628993+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./mysql/general_log_496.sdi.qp
2023-01-03T12:25:02.629202+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./mysql/slow_log_498.sdi.qp
2023-01-03T12:25:02.635740+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./mysql/slow_log_498.sdi.qp
2023-01-03T12:25:02.635899+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./performance_schema/clone_status_381.sdi.qp
2023-01-03T12:25:02.642614+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./performance_schema/clone_status_381.sdi.qp
2023-01-03T12:25:02.642774+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./performance_schema/clone_progress_382.sdi.qp
2023-01-03T12:25:02.649679+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./performance_schema/clone_progress_382.sdi.qp
2023-01-03T12:25:02.649842+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./mysql-bin.000007.qp
2023-01-03T12:25:02.656622+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./mysql-bin.000007.qp
2023-01-03T12:25:02.656785+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./mysql-bin.index.qp
2023-01-03T12:25:02.663213+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./mysql-bin.index.qp
2023-01-03T12:25:02.663373+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./xtrabackup_binlog_info.qp
2023-01-03T12:25:02.669703+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./xtrabackup_binlog_info.qp
2023-01-03T12:25:02.669884+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./ib_buffer_pool.qp
2023-01-03T12:25:02.676391+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./ib_buffer_pool.qp
2023-01-03T12:25:02.676555+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./backup-my.cnf.qp
2023-01-03T12:25:02.682891+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./backup-my.cnf.qp
2023-01-03T12:25:02.683048+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./xtrabackup_info.qp
2023-01-03T12:25:02.689505+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./xtrabackup_info.qp
2023-01-03T12:25:02.689666+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./xtrabackup_tablespaces.qp
2023-01-03T12:25:02.696074+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./xtrabackup_tablespaces.qp
2023-01-03T12:25:02.746210+08:00 0 [Note] [MY-011825] [Xtrabackup] completed OK!
[root@mysql2 backup]# ll /data/backup/2022-12-30/
total 69672
-rw-r--r--. 1 root root      447 Jan  3 12:25 backup-my.cnf
-rw-r--r--. 1 root root     4138 Jan  3 12:25 ib_buffer_pool
-rw-r--r--. 1 root root 12582912 Jan  3 12:25 ibdata1
drwxr-x---. 2 root root        6 Jan  3 12:12 #innodb_redo
drwxr-x---. 2 root root       19 Jan  3 12:25 jyc
drwxr-x---. 2 root root       22 Jan  3 12:25 jycdb
drwxr-x---. 2 root root      143 Jan  3 12:25 mysql
-rw-r--r--. 1 root root      237 Jan  3 12:25 mysql-bin.000007
-rw-r--r--. 1 root root       29 Jan  3 12:25 mysql-bin.index
-rw-r--r--. 1 root root 25165824 Jan  3 12:25 mysql.ibd
drwxr-x---. 2 root root       64 Jan  3 12:25 performance_schema
drwxr-x---. 2 root root       28 Jan  3 12:25 sys
drwxr-x---. 2 root root       19 Jan  3 12:25 test
-rw-r--r--. 1 root root 16777216 Jan  3 12:25 undo_001
-rw-r--r--. 1 root root 16777216 Jan  3 12:25 undo_002
-rw-r--r--. 1 root root      103 Jan  3 12:25 xtrabackup_binlog_info
-rw-r-----. 1 root root      136 Dec 30 12:21 xtrabackup_checkpoints
-rw-r--r--. 1 root root      719 Jan  3 12:25 xtrabackup_info
-rw-r--r--. 1 root root     2560 Jan  3 12:25 xtrabackup_logfile
-rw-r--r--. 1 root root       39 Jan  3 12:25 xtrabackup_tablespaces
[root@mysql2 backup]# xtrabackup --prepare --target-dir=/data/backup/2022-12-30
2023-01-03T12:25:32.206994+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized server arguments: --innodb_checksum_algorithm=crc32 --innodb_log_checksums=1 --innodb_data_file_path=ibdata1:12M:autoextend --innodb_log_file_size=50331648 --innodb_page_size=16384 --innodb_undo_directory=./ --innodb_undo_tablespaces=2 --server-id=2 --innodb_log_checksums=ON --innodb_redo_log_encrypt=0 --innodb_undo_log_encrypt=0 
2023-01-03T12:25:32.207327+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized client arguments: --prepare=1 --target-dir=/data/backup/2022-12-30 
xtrabackup version 8.0.30-23 based on MySQL server 8.0.30 Linux (x86_64) (revision id: 873b467185c)
2023-01-03T12:25:32.207402+08:00 0 [Note] [MY-011825] [Xtrabackup] cd to /data/backup/2022-12-30/
2023-01-03T12:25:32.207508+08:00 0 [Note] [MY-011825] [Xtrabackup] This target seems to be not prepared yet.
2023-01-03T12:25:32.208741+08:00 0 [Note] [MY-013251] [InnoDB] Number of pools: 1
2023-01-03T12:25:32.235943+08:00 0 [Note] [MY-011825] [Xtrabackup] xtrabackup_logfile detected: size=8388608, start_lsn=(20070938)
2023-01-03T12:25:32.237240+08:00 0 [Note] [MY-011825] [Xtrabackup] using the following InnoDB configuration for recovery:
2023-01-03T12:25:32.237294+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_home_dir = .
2023-01-03T12:25:32.237315+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_file_path = ibdata1:12M:autoextend
2023-01-03T12:25:32.237389+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_group_home_dir = .
2023-01-03T12:25:32.237408+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_files_in_group = 1
2023-01-03T12:25:32.237429+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_file_size = 8388608
2023-01-03T12:25:32.238026+08:00 0 [Note] [MY-011825] [Xtrabackup] inititialize_service_handles suceeded
2023-01-03T12:25:32.238427+08:00 0 [Note] [MY-011825] [Xtrabackup] using the following InnoDB configuration for recovery:
2023-01-03T12:25:32.238454+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_home_dir = .
2023-01-03T12:25:32.238471+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_file_path = ibdata1:12M:autoextend
2023-01-03T12:25:32.238498+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_group_home_dir = .
2023-01-03T12:25:32.238515+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_files_in_group = 1
2023-01-03T12:25:32.238531+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_file_size = 8388608
2023-01-03T12:25:32.238557+08:00 0 [Note] [MY-011825] [Xtrabackup] Starting InnoDB instance for recovery.
2023-01-03T12:25:32.238575+08:00 0 [Note] [MY-011825] [Xtrabackup] Using 104857600 bytes for buffer pool (set by --use-memory parameter)
2023-01-03T12:25:32.238649+08:00 0 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available
2023-01-03T12:25:32.238732+08:00 0 [Note] [MY-012944] [InnoDB] Uses event mutexes
2023-01-03T12:25:32.238750+08:00 0 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier
2023-01-03T12:25:32.238776+08:00 0 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.12
2023-01-03T12:25:32.239255+08:00 0 [Note] [MY-013251] [InnoDB] Number of pools: 1
2023-01-03T12:25:32.239499+08:00 0 [Note] [MY-012951] [InnoDB] Using software crc32.
2023-01-03T12:25:32.241457+08:00 0 [Note] [MY-012203] [InnoDB] Directories to scan './'
2023-01-03T12:25:32.241549+08:00 0 [Note] [MY-012204] [InnoDB] Scanning './'
2023-01-03T12:25:32.242691+08:00 0 [Note] [MY-012208] [InnoDB] Completed space ID check of 7 files.
2023-01-03T12:25:32.245131+08:00 0 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 128.000000M, instances = 1, chunk size =128.000000M 
2023-01-03T12:25:32.267788+08:00 0 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool
2023-01-03T12:25:32.278084+08:00 0 [Note] [MY-011951] [InnoDB] page_cleaner coordinator priority: -20
2023-01-03T12:25:32.279312+08:00 0 [Note] [MY-011954] [InnoDB] page_cleaner worker priority: -20
2023-01-03T12:25:32.307537+08:00 0 [Note] [MY-011954] [InnoDB] page_cleaner worker priority: -20
2023-01-03T12:25:32.326340+08:00 0 [Note] [MY-011954] [InnoDB] page_cleaner worker priority: -20
2023-01-03T12:25:32.457438+08:00 0 [Note] [MY-013883] [InnoDB] The latest found checkpoint is at lsn = 20070938 in redo log file ./#innodb_redo/#ib_redo0.
2023-01-03T12:25:32.457612+08:00 0 [Note] [MY-012560] [InnoDB] The log sequence number 19950102 in the system tablespace does not match the log sequence number 20070938 in the redo log files!
2023-01-03T12:25:32.457661+08:00 0 [Note] [MY-012551] [InnoDB] Database was not shutdown normally!
2023-01-03T12:25:32.457696+08:00 0 [Note] [MY-012552] [InnoDB] Starting crash recovery.
2023-01-03T12:25:32.457907+08:00 0 [Note] [MY-013086] [InnoDB] Starting to parse redo log at lsn = 20070928, whereas checkpoint_lsn = 20070938 and start_lsn = 20070912
2023-01-03T12:25:32.457967+08:00 0 [Note] [MY-012550] [InnoDB] Doing recovery: scanned up to log sequence number 20070938
2023-01-03T12:25:32.484611+08:00 0 [Note] [MY-013083] [InnoDB] Log background threads are being started...
2023-01-03T12:25:32.556488+08:00 0 [Note] [MY-012532] [InnoDB] Applying a batch of 0 redo log records ...
2023-01-03T12:25:32.556551+08:00 0 [Note] [MY-012535] [InnoDB] Apply batch completed!
2023-01-03T12:25:32.657017+08:00 0 [Note] [MY-013084] [InnoDB] Log background threads are being closed...
2023-01-03T12:25:32.663945+08:00 0 [Note] [MY-013041] [InnoDB] Resizing redo log from 8M to 1024M (LSN=20070938) synchronously. If this takes too long, consider starting the server with large --innodb_redo_log_capacity, and resizing the redo log online using SET.
2023-01-03T12:25:32.667439+08:00 0 [Note] [MY-012968] [InnoDB] Starting to delete and rewrite redo log files.
2023-01-03T12:25:32.667533+08:00 0 [Note] [MY-011825] [InnoDB] Removing redo log file: ./#innodb_redo/#ib_redo0
2023-01-03T12:25:32.793288+08:00 0 [Note] [MY-011825] [InnoDB] Creating redo log file at ./#innodb_redo/#ib_redo0_tmp with file_id 0 with size 33554432 bytes
2023-01-03T12:25:32.799776+08:00 0 [Note] [MY-011825] [InnoDB] Renaming redo log file from ./#innodb_redo/#ib_redo0_tmp to ./#innodb_redo/#ib_redo0
2023-01-03T12:25:32.802935+08:00 0 [Note] [MY-012893] [InnoDB] New redo log files created, LSN=20071436
2023-01-03T12:25:32.803025+08:00 0 [Note] [MY-013083] [InnoDB] Log background threads are being started...
2023-01-03T12:25:32.857838+08:00 0 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_001'.
2023-01-03T12:25:32.858628+08:00 0 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_002'.
2023-01-03T12:25:32.860434+08:00 0 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces.
2023-01-03T12:25:32.860537+08:00 0 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 5440
2023-01-03T12:25:32.891729+08:00 0 [Note] [MY-013776] [InnoDB] Parallel initialization of rseg complete
2023-01-03T12:25:32.891800+08:00 0 [Note] [MY-013777] [InnoDB] Time taken to initialize rseg using 2 thread: 31280 ms.
2023-01-03T12:25:32.891980+08:00 0 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables
2023-01-03T12:25:32.892183+08:00 0 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-01-03T12:25:32.941140+08:00 0 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB.
2023-01-03T12:25:32.941568+08:00 0 [Note] [MY-013627] [InnoDB] Scanning temp tablespace dir:'./#innodb_temp/'
2023-01-03T12:25:32.978788+08:00 0 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
2023-01-03T12:25:32.979315+08:00 0 [Note] [MY-012976] [InnoDB] 8.0.30 started; log sequence number 20071446
2023-01-03T12:25:32.979944+08:00 0 [Warning] [MY-012091] [InnoDB] Allocated tablespace ID 1 for sys/sys_config, old maximum was 0
2023-01-03T12:25:33.023567+08:00 0 [Note] [MY-011825] [Xtrabackup] starting shutdown with innodb_fast_shutdown = 1
2023-01-03T12:25:33.023733+08:00 0 [Note] [MY-012330] [InnoDB] FTS optimize thread exiting.
2023-01-03T12:25:34.019618+08:00 0 [Note] [MY-013072] [InnoDB] Starting shutdown...
2023-01-03T12:25:34.027785+08:00 0 [Note] [MY-013084] [InnoDB] Log background threads are being closed...
2023-01-03T12:25:34.055275+08:00 0 [Note] [MY-012980] [InnoDB] Shutdown completed; log sequence number 20071446
2023-01-03T12:25:34.055977+08:00 0 [Note] [MY-013251] [InnoDB] Number of pools: 1
2023-01-03T12:25:34.057470+08:00 0 [Note] [MY-011825] [Xtrabackup] completed OK!
[root@mysql2 backup]# ll /data/backup/2022-12-30/
total 114724
-rw-r--r--. 1 root root      447 Jan  3 12:25 backup-my.cnf
-rw-r--r--. 1 root root     4138 Jan  3 12:25 ib_buffer_pool
-rw-r--r--. 1 root root 12582912 Jan  3 12:25 ibdata1
-rw-r-----. 1 root root 12582912 Jan  3 12:25 ibtmp1
drwxr-x---. 2 root root        6 Jan  3 12:25 #innodb_redo
drwxr-x---. 2 root root       19 Jan  3 12:25 jyc
drwxr-x---. 2 root root       22 Jan  3 12:25 jycdb
drwxr-x---. 2 root root      143 Jan  3 12:25 mysql
-rw-r--r--. 1 root root      237 Jan  3 12:25 mysql-bin.000007
-rw-r--r--. 1 root root       29 Jan  3 12:25 mysql-bin.index
-rw-r--r--. 1 root root 25165824 Jan  3 12:25 mysql.ibd
drwxr-x---. 2 root root       64 Jan  3 12:25 performance_schema
drwxr-x---. 2 root root       28 Jan  3 12:25 sys
drwxr-x---. 2 root root       19 Jan  3 12:25 test
-rw-r--r--. 1 root root 16777216 Jan  3 12:25 undo_001
-rw-r--r--. 1 root root 16777216 Jan  3 12:25 undo_002
-rw-r--r--. 1 root root      103 Jan  3 12:25 xtrabackup_binlog_info
-rw-r-----. 1 root root      136 Jan  3 12:25 xtrabackup_checkpoints
-rw-r--r--. 1 root root      719 Jan  3 12:25 xtrabackup_info
-rw-r-----. 1 root root 33554432 Jan  3 12:25 xtrabackup_logfile
-rw-r--r--. 1 root root       39 Jan  3 12:25 xtrabackup_tablespaces
[root@mysql2 backup]# more /data/backup/2022-12-30/xtrabackup_checkpoints
backup_type = full-prepared
from_lsn = 0
to_lsn = 20070938
last_lsn = 20070938
flushed_lsn = 20070938
redo_memory = 360
redo_frames = 1
[root@mysql2 backup]# xtrabackup --decompress --remove-original --target-dir=/data/backup/2022-12-31
2023-01-03T12:26:22.689574+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized server arguments: --datadir=/mysql/data --innodb_buffer_pool_size=2G --innodb_flush_log_at_trx_commit=2 --log_bin=/mysql/data/mysql-bin --server-id=2 
2023-01-03T12:26:22.689938+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized client arguments: --port=3306 --socket=/mysql/mysql.sock --decompress=1 --remove-original=1 --target-dir=/data/backup/2022-12-31 
xtrabackup version 8.0.30-23 based on MySQL server 8.0.30 Linux (x86_64) (revision id: 873b467185c)
2023-01-03T12:26:22.690908+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./xtrabackup_logfile.qp
2023-01-03T12:26:22.698076+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./xtrabackup_logfile.qp
2023-01-03T12:26:22.698251+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./ibdata1.delta.qp
2023-01-03T12:26:22.704748+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./ibdata1.delta.qp
2023-01-03T12:26:22.704910+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./sys/sys_config.ibd.delta.qp
2023-01-03T12:26:22.711304+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./sys/sys_config.ibd.delta.qp
2023-01-03T12:26:22.711465+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./jycdb/test.ibd.delta.qp
2023-01-03T12:26:22.717931+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./jycdb/test.ibd.delta.qp
2023-01-03T12:26:22.718112+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./jyc/t.ibd.delta.qp
2023-01-03T12:26:22.724495+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./jyc/t.ibd.delta.qp
2023-01-03T12:26:22.724656+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./test/t.ibd.delta.qp
2023-01-03T12:26:22.731145+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./test/t.ibd.delta.qp
2023-01-03T12:26:22.731342+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./mysql.ibd.delta.qp
2023-01-03T12:26:22.737792+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./mysql.ibd.delta.qp
2023-01-03T12:26:22.737952+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./undo_002.delta.qp
2023-01-03T12:26:22.744378+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./undo_002.delta.qp
2023-01-03T12:26:22.744536+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./undo_001.delta.qp
2023-01-03T12:26:22.750977+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./undo_001.delta.qp
2023-01-03T12:26:22.751197+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./mysql/slow_log.CSM.qp
2023-01-03T12:26:22.757978+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./mysql/slow_log.CSM.qp
2023-01-03T12:26:22.758171+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./mysql/slow_log.CSV.qp
2023-01-03T12:26:22.764531+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./mysql/slow_log.CSV.qp
2023-01-03T12:26:22.764699+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./mysql/general_log.CSV.qp
2023-01-03T12:26:22.771120+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./mysql/general_log.CSV.qp
2023-01-03T12:26:22.771291+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./mysql/general_log.CSM.qp
2023-01-03T12:26:22.777926+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./mysql/general_log.CSM.qp
2023-01-03T12:26:22.778120+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./mysql/general_log_496.sdi.qp
2023-01-03T12:26:22.784729+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./mysql/general_log_496.sdi.qp
2023-01-03T12:26:22.784899+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./mysql/slow_log_498.sdi.qp
2023-01-03T12:26:22.791738+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./mysql/slow_log_498.sdi.qp
2023-01-03T12:26:22.791912+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./performance_schema/clone_status_381.sdi.qp
2023-01-03T12:26:22.798562+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./performance_schema/clone_status_381.sdi.qp
2023-01-03T12:26:22.798731+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./performance_schema/clone_progress_382.sdi.qp
2023-01-03T12:26:22.805621+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./performance_schema/clone_progress_382.sdi.qp
2023-01-03T12:26:22.805806+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./mysql-bin.000008.qp
2023-01-03T12:26:22.812585+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./mysql-bin.000008.qp
2023-01-03T12:26:22.812769+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./mysql-bin.index.qp
2023-01-03T12:26:22.819421+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./mysql-bin.index.qp
2023-01-03T12:26:22.819608+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./xtrabackup_binlog_info.qp
2023-01-03T12:26:22.827154+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./xtrabackup_binlog_info.qp
2023-01-03T12:26:22.827364+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./ib_buffer_pool.qp
2023-01-03T12:26:22.834245+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./ib_buffer_pool.qp
2023-01-03T12:26:22.834405+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./backup-my.cnf.qp
2023-01-03T12:26:22.840938+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./backup-my.cnf.qp
2023-01-03T12:26:22.841128+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./xtrabackup_info.qp
2023-01-03T12:26:22.847721+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./xtrabackup_info.qp
2023-01-03T12:26:22.847892+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./xtrabackup_tablespaces.qp
2023-01-03T12:26:22.854341+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./xtrabackup_tablespaces.qp
2023-01-03T12:26:22.891960+08:00 0 [Note] [MY-011825] [Xtrabackup] completed OK!
[root@mysql2 backup]# xtrabackup --prepare --apply-log-only --target-dir=/data/backup/2022-12-30 --incremental-dir=/data/backup/2022-12-31
2023-01-03T12:30:27.391775+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized server arguments: --innodb_checksum_algorithm=crc32 --innodb_log_checksums=1 --innodb_data_file_path=ibdata1:12M:autoextend --innodb_log_file_size=50331648 --innodb_page_size=16384 --innodb_undo_directory=./ --innodb_undo_tablespaces=2 --server-id=2 --innodb_log_checksums=ON --innodb_redo_log_encrypt=0 --innodb_undo_log_encrypt=0 
2023-01-03T12:30:27.392255+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized client arguments: --prepare=1 --apply-log-only=1 --target-dir=/data/backup/2022-12-30 --incremental-dir=/data/backup/2022-12-31 
xtrabackup version 8.0.30-23 based on MySQL server 8.0.30 Linux (x86_64) (revision id: 873b467185c)
2023-01-03T12:30:27.392389+08:00 0 [Note] [MY-011825] [Xtrabackup] incremental backup from 20070938 is enabled.
2023-01-03T12:30:27.392430+08:00 0 [Note] [MY-011825] [Xtrabackup] cd to /data/backup/2022-12-30/
2023-01-03T12:30:27.392505+08:00 0 [Note] [MY-011825] [Xtrabackup] This target seems to be already prepared.
2023-01-03T12:30:27.392549+08:00 0 [ERROR] [MY-011825] [Xtrabackup] applying incremental backup needs target prepared with --apply-log-only.
[root@mysql2 backup]# xtrabackup --prepare --apply-log-only --target-dir=/data/backup/2022-12-30 --incremental-dir=/data/backup/2022-12-31
2023-01-03T12:33:29.308748+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized server arguments: --innodb_checksum_algorithm=crc32 --innodb_log_checksums=1 --innodb_data_file_path=ibdata1:12M:autoextend --innodb_log_file_size=50331648 --innodb_page_size=16384 --innodb_undo_directory=./ --innodb_undo_tablespaces=2 --server-id=2 --innodb_log_checksums=ON --innodb_redo_log_encrypt=0 --innodb_undo_log_encrypt=0 
2023-01-03T12:33:29.309416+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized client arguments: --prepare=1 --apply-log-only=1 --target-dir=/data/backup/2022-12-30 --incremental-dir=/data/backup/2022-12-31 
xtrabackup version 8.0.30-23 based on MySQL server 8.0.30 Linux (x86_64) (revision id: 873b467185c)
2023-01-03T12:33:29.309536+08:00 0 [Note] [MY-011825] [Xtrabackup] incremental backup from 20070938 is enabled.
2023-01-03T12:33:29.309577+08:00 0 [Note] [MY-011825] [Xtrabackup] cd to /data/backup/2022-12-30/
2023-01-03T12:33:29.309656+08:00 0 [Note] [MY-011825] [Xtrabackup] This target seems to be already prepared.
2023-01-03T12:33:29.309684+08:00 0 [ERROR] [MY-011825] [Xtrabackup] applying incremental backup needs target prepared with --apply-log-only.
[root@mysql2 backup]# xtrabackup --prepare --apply-log-only --target-dir=/data/backup/2022-12-30 --incremental-dir=/data/backup/2022-12-31 --apply-log-only
2023-01-03T12:33:48.355327+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized server arguments: --innodb_checksum_algorithm=crc32 --innodb_log_checksums=1 --innodb_data_file_path=ibdata1:12M:autoextend --innodb_log_file_size=50331648 --innodb_page_size=16384 --innodb_undo_directory=./ --innodb_undo_tablespaces=2 --server-id=2 --innodb_log_checksums=ON --innodb_redo_log_encrypt=0 --innodb_undo_log_encrypt=0 
2023-01-03T12:33:48.355643+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized client arguments: --prepare=1 --apply-log-only=1 --target-dir=/data/backup/2022-12-30 --incremental-dir=/data/backup/2022-12-31 --apply-log-only=1 
xtrabackup version 8.0.30-23 based on MySQL server 8.0.30 Linux (x86_64) (revision id: 873b467185c)
2023-01-03T12:33:48.355764+08:00 0 [Note] [MY-011825] [Xtrabackup] incremental backup from 20070938 is enabled.
2023-01-03T12:33:48.355805+08:00 0 [Note] [MY-011825] [Xtrabackup] cd to /data/backup/2022-12-30/
2023-01-03T12:33:48.355905+08:00 0 [Note] [MY-011825] [Xtrabackup] This target seems to be already prepared.
2023-01-03T12:33:48.355935+08:00 0 [ERROR] [MY-011825] [Xtrabackup] applying incremental backup needs target prepared with --apply-log-only.
[root@mysql2 backup]# ll /data/backup/2022-12-30
total 114724
-rw-r--r--. 1 root root      447 Jan  3 12:25 backup-my.cnf
-rw-r--r--. 1 root root     4138 Jan  3 12:25 ib_buffer_pool
-rw-r--r--. 1 root root 12582912 Jan  3 12:25 ibdata1
-rw-r-----. 1 root root 12582912 Jan  3 12:25 ibtmp1
drwxr-x---. 2 root root        6 Jan  3 12:25 #innodb_redo
drwxr-x---. 2 root root       19 Jan  3 12:25 jyc
drwxr-x---. 2 root root       22 Jan  3 12:25 jycdb
drwxr-x---. 2 root root      143 Jan  3 12:25 mysql
-rw-r--r--. 1 root root      237 Jan  3 12:25 mysql-bin.000007
-rw-r--r--. 1 root root       29 Jan  3 12:25 mysql-bin.index
-rw-r--r--. 1 root root 25165824 Jan  3 12:25 mysql.ibd
drwxr-x---. 2 root root       64 Jan  3 12:25 performance_schema
drwxr-x---. 2 root root       28 Jan  3 12:25 sys
drwxr-x---. 2 root root       19 Jan  3 12:25 test
-rw-r--r--. 1 root root 16777216 Jan  3 12:25 undo_001
-rw-r--r--. 1 root root 16777216 Jan  3 12:25 undo_002
-rw-r--r--. 1 root root      103 Jan  3 12:25 xtrabackup_binlog_info
-rw-r-----. 1 root root      136 Jan  3 12:25 xtrabackup_checkpoints
-rw-r--r--. 1 root root      719 Jan  3 12:25 xtrabackup_info
-rw-r-----. 1 root root 33554432 Jan  3 12:25 xtrabackup_logfile
-rw-r--r--. 1 root root       39 Jan  3 12:25 xtrabackup_tablespaces
[root@mysql2 backup]# ll /data/backup/2022-12-31
total 136
-rw-r--r--. 1 root root   447 Jan  3 12:26 backup-my.cnf
-rw-r--r--. 1 root root  4138 Jan  3 12:26 ib_buffer_pool
-rw-r--r--. 1 root root 32768 Jan  3 12:26 ibdata1.delta
-rw-r-----. 1 root root    64 Dec 31 08:00 ibdata1.meta
drwxr-x---. 2 root root    43 Jan  3 12:26 jyc
drwxr-x---. 2 root root    49 Jan  3 12:26 jycdb
drwxr-x---. 2 root root   143 Jan  3 12:26 mysql
-rw-r--r--. 1 root root   237 Jan  3 12:26 mysql-bin.000008
-rw-r--r--. 1 root root    29 Jan  3 12:26 mysql-bin.index
-rw-r--r--. 1 root root 16384 Jan  3 12:26 mysql.ibd.delta
-rw-r-----. 1 root root    73 Dec 31 08:00 mysql.ibd.meta
drwxr-x---. 2 root root    64 Jan  3 12:26 performance_schema
drwxr-x---. 2 root root    61 Jan  3 12:26 sys
drwxr-x---. 2 root root    43 Jan  3 12:26 test
-rw-r--r--. 1 root root 16384 Jan  3 12:26 undo_001.delta
-rw-r-----. 1 root root    69 Dec 31 08:00 undo_001.meta
-rw-r--r--. 1 root root 16384 Jan  3 12:26 undo_002.delta
-rw-r-----. 1 root root    69 Dec 31 08:00 undo_002.meta
-rw-r--r--. 1 root root   103 Jan  3 12:26 xtrabackup_binlog_info
-rw-r-----. 1 root root   141 Dec 31 08:00 xtrabackup_checkpoints
-rw-r--r--. 1 root root   784 Jan  3 12:26 xtrabackup_info
-rw-r--r--. 1 root root  2560 Jan  3 12:26 xtrabackup_logfile
-rw-r--r--. 1 root root    39 Jan  3 12:26 xtrabackup_tablespaces
[root@mysql2 backup]# xtrabackup --prepare --apply-log-only --target-dir=/data/backup/2022-12-30
2023-01-03T12:38:40.546348+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized server arguments: --innodb_checksum_algorithm=crc32 --innodb_log_checksums=1 --innodb_data_file_path=ibdata1:12M:autoextend --innodb_log_file_size=50331648 --innodb_page_size=16384 --innodb_undo_directory=./ --innodb_undo_tablespaces=2 --server-id=2 --innodb_log_checksums=ON --innodb_redo_log_encrypt=0 --innodb_undo_log_encrypt=0 
2023-01-03T12:38:40.546666+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized client arguments: --prepare=1 --apply-log-only=1 --target-dir=/data/backup/2022-12-30 
xtrabackup version 8.0.30-23 based on MySQL server 8.0.30 Linux (x86_64) (revision id: 873b467185c)
2023-01-03T12:38:40.546742+08:00 0 [Note] [MY-011825] [Xtrabackup] cd to /data/backup/2022-12-30/
2023-01-03T12:38:40.546836+08:00 0 [Note] [MY-011825] [Xtrabackup] This target seems to be already prepared.
2023-01-03T12:38:40.547800+08:00 0 [Note] [MY-013251] [InnoDB] Number of pools: 1
2023-01-03T12:38:40.548083+08:00 0 [Note] [MY-011825] [Xtrabackup] xtrabackup_logfile was already used to '--prepare'.
2023-01-03T12:38:40.548695+08:00 0 [Note] [MY-011825] [Xtrabackup] using the following InnoDB configuration for recovery:
2023-01-03T12:38:40.548721+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_home_dir = .
2023-01-03T12:38:40.548738+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_file_path = ibdata1:12M:autoextend
2023-01-03T12:38:40.548810+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_group_home_dir = .
2023-01-03T12:38:40.548828+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_files_in_group = 2
2023-01-03T12:38:40.548847+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_file_size = 50331648
2023-01-03T12:38:40.549434+08:00 0 [Note] [MY-011825] [Xtrabackup] inititialize_service_handles suceeded
2023-01-03T12:38:40.549727+08:00 0 [Note] [MY-011825] [Xtrabackup] using the following InnoDB configuration for recovery:
2023-01-03T12:38:40.549753+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_home_dir = .
2023-01-03T12:38:40.549770+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_file_path = ibdata1:12M:autoextend
2023-01-03T12:38:40.549796+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_group_home_dir = .
2023-01-03T12:38:40.549813+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_files_in_group = 2
2023-01-03T12:38:40.549828+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_file_size = 50331648
2023-01-03T12:38:40.549854+08:00 0 [Note] [MY-011825] [Xtrabackup] Starting InnoDB instance for recovery.
2023-01-03T12:38:40.549871+08:00 0 [Note] [MY-011825] [Xtrabackup] Using 104857600 bytes for buffer pool (set by --use-memory parameter)
2023-01-03T12:38:40.549941+08:00 0 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available
2023-01-03T12:38:40.549984+08:00 0 [Note] [MY-012944] [InnoDB] Uses event mutexes
2023-01-03T12:38:40.550001+08:00 0 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier
2023-01-03T12:38:40.550032+08:00 0 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.12
2023-01-03T12:38:40.550289+08:00 0 [Note] [MY-013251] [InnoDB] Number of pools: 1
2023-01-03T12:38:40.550470+08:00 0 [Note] [MY-012951] [InnoDB] Using software crc32.
2023-01-03T12:38:40.551310+08:00 0 [Note] [MY-012203] [InnoDB] Directories to scan './'
2023-01-03T12:38:40.551397+08:00 0 [Note] [MY-012204] [InnoDB] Scanning './'
2023-01-03T12:38:40.552328+08:00 0 [Note] [MY-012208] [InnoDB] Completed space ID check of 7 files.
2023-01-03T12:38:40.553964+08:00 0 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 128.000000M, instances = 1, chunk size =128.000000M 
2023-01-03T12:38:40.568539+08:00 0 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool
2023-01-03T12:38:40.573001+08:00 0 [Note] [MY-011951] [InnoDB] page_cleaner coordinator priority: -20
2023-01-03T12:38:40.574349+08:00 0 [Note] [MY-011954] [InnoDB] page_cleaner worker priority: -20
2023-01-03T12:38:40.581122+08:00 0 [Note] [MY-011954] [InnoDB] page_cleaner worker priority: -20
2023-01-03T12:38:40.581292+08:00 0 [Note] [MY-011954] [InnoDB] page_cleaner worker priority: -20
2023-01-03T12:38:40.688458+08:00 0 [Note] [MY-011825] [InnoDB] Creating redo log file at ./#innodb_redo/#ib_redo0_tmp with file_id 0 with size 33554432 bytes
2023-01-03T12:38:40.691624+08:00 0 [Note] [MY-011825] [InnoDB] Renaming redo log file from ./#innodb_redo/#ib_redo0_tmp to ./#innodb_redo/#ib_redo0
2023-01-03T12:38:40.693673+08:00 0 [Note] [MY-012893] [InnoDB] New redo log files created, LSN=20071446
2023-01-03T12:38:40.694440+08:00 0 [Note] [MY-013883] [InnoDB] The latest found checkpoint is at lsn = 20071948 in redo log file ./#innodb_redo/#ib_redo0.
2023-01-03T12:38:40.695150+08:00 0 [Note] [MY-013086] [InnoDB] Starting to parse redo log at lsn = 20071948, whereas checkpoint_lsn = 20071948 and start_lsn = 20071936
2023-01-03T12:38:40.698084+08:00 0 [Note] [MY-013083] [InnoDB] Log background threads are being started...
2023-01-03T12:38:40.747735+08:00 0 [Note] [MY-012532] [InnoDB] Applying a batch of 0 redo log records ...
2023-01-03T12:38:40.747791+08:00 0 [Note] [MY-012535] [InnoDB] Apply batch completed!
2023-01-03T12:38:40.748115+08:00 0 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_001'.
2023-01-03T12:38:40.749078+08:00 0 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_002'.
2023-01-03T12:38:40.750803+08:00 0 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces.
2023-01-03T12:38:40.750891+08:00 0 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 5440
2023-01-03T12:38:40.770440+08:00 0 [Note] [MY-013776] [InnoDB] Parallel initialization of rseg complete
2023-01-03T12:38:40.770515+08:00 0 [Note] [MY-013777] [InnoDB] Time taken to initialize rseg using 2 thread: 19638 ms.
2023-01-03T12:38:40.773462+08:00 0 [Note] [MY-012255] [InnoDB] Removed temporary tablespace data file: "ibtmp1"
2023-01-03T12:38:40.773494+08:00 0 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables
2023-01-03T12:38:40.773636+08:00 0 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-01-03T12:38:40.821686+08:00 0 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB.
2023-01-03T12:38:40.822113+08:00 0 [Note] [MY-013627] [InnoDB] Scanning temp tablespace dir:'./#innodb_temp/'
2023-01-03T12:38:40.859743+08:00 0 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
2023-01-03T12:38:40.860242+08:00 0 [Note] [MY-012976] [InnoDB] 8.0.30 started; log sequence number 20071958
2023-01-03T12:38:40.861036+08:00 0 [Warning] [MY-012091] [InnoDB] Allocated tablespace ID 1 for sys/sys_config, old maximum was 0
2023-01-03T12:38:40.900298+08:00 0 [Note] [MY-011825] [Xtrabackup] starting shutdown with innodb_fast_shutdown = 1
2023-01-03T12:38:40.900408+08:00 0 [Note] [MY-012330] [InnoDB] FTS optimize thread exiting.
2023-01-03T12:38:41.899959+08:00 0 [Note] [MY-013072] [InnoDB] Starting shutdown...
2023-01-03T12:38:41.909551+08:00 0 [Note] [MY-013084] [InnoDB] Log background threads are being closed...
2023-01-03T12:38:41.933032+08:00 0 [Note] [MY-012980] [InnoDB] Shutdown completed; log sequence number 20071958
2023-01-03T12:38:41.933765+08:00 0 [Note] [MY-013251] [InnoDB] Number of pools: 1
2023-01-03T12:38:41.935613+08:00 0 [Note] [MY-011825] [Xtrabackup] completed OK!
[root@mysql2 backup]# xtrabackup --prepare --apply-log-only --target-dir=/data/backup/2022-12-30 --incremental-dir=/data/backup/2022-12-31
2023-01-03T12:38:50.779740+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized server arguments: --innodb_checksum_algorithm=crc32 --innodb_log_checksums=1 --innodb_data_file_path=ibdata1:12M:autoextend --innodb_log_file_size=50331648 --innodb_page_size=16384 --innodb_undo_directory=./ --innodb_undo_tablespaces=2 --server-id=2 --innodb_log_checksums=ON --innodb_redo_log_encrypt=0 --innodb_undo_log_encrypt=0 
2023-01-03T12:38:50.780051+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized client arguments: --prepare=1 --apply-log-only=1 --target-dir=/data/backup/2022-12-30 --incremental-dir=/data/backup/2022-12-31 
xtrabackup version 8.0.30-23 based on MySQL server 8.0.30 Linux (x86_64) (revision id: 873b467185c)
2023-01-03T12:38:50.780206+08:00 0 [Note] [MY-011825] [Xtrabackup] incremental backup from 20070938 is enabled.
2023-01-03T12:38:50.780248+08:00 0 [Note] [MY-011825] [Xtrabackup] cd to /data/backup/2022-12-30/
2023-01-03T12:38:50.780346+08:00 0 [Note] [MY-011825] [Xtrabackup] This target seems to be already prepared with --apply-log-only.
2023-01-03T12:38:50.781184+08:00 0 [Note] [MY-013251] [InnoDB] Number of pools: 1
2023-01-03T12:38:50.789942+08:00 0 [Note] [MY-011825] [Xtrabackup] xtrabackup_logfile detected: size=8388608, start_lsn=(20070958)
2023-01-03T12:38:50.791084+08:00 0 [Note] [MY-011825] [Xtrabackup] using the following InnoDB configuration for recovery:
2023-01-03T12:38:50.791121+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_home_dir = .
2023-01-03T12:38:50.791139+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_file_path = ibdata1:12M:autoextend
2023-01-03T12:38:50.791228+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_group_home_dir = /data/backup/2022-12-31/
2023-01-03T12:38:50.791248+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_files_in_group = 1
2023-01-03T12:38:50.791271+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_file_size = 8388608
2023-01-03T12:38:50.791853+08:00 0 [Note] [MY-011825] [Xtrabackup] inititialize_service_handles suceeded
2023-01-03T12:38:50.994603+08:00 0 [Note] [MY-011825] [Xtrabackup] Generating a list of tablespaces
2023-01-03T12:38:50.994740+08:00 0 [Note] [MY-011825] [Xtrabackup] Generating a list of tablespaces
2023-01-03T12:38:50.994773+08:00 0 [Note] [MY-012204] [InnoDB] Scanning './'
2023-01-03T12:38:50.995583+08:00 0 [Note] [MY-012208] [InnoDB] Completed space ID check of 2 files.
2023-01-03T12:38:50.995918+08:00 0 [Warning] [MY-012091] [InnoDB] Allocated tablespace ID 6 for test/t, old maximum was 0
2023-01-03T12:38:50.996463+08:00 0 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_001'.
2023-01-03T12:38:50.997265+08:00 0 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_002'.
2023-01-03T12:38:50.999369+08:00 0 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces.
2023-01-03T12:38:50.999601+08:00 0 [Note] [MY-011825] [Xtrabackup] page size for /data/backup/2022-12-31//sys/sys_config.ibd.delta is 16384 bytes
2023-01-03T12:38:50.999735+08:00 0 [Note] [MY-011825] [Xtrabackup] Applying /data/backup/2022-12-31//sys/sys_config.ibd.delta to ./sys/sys_config.ibd
2023-01-03T12:38:51.001051+08:00 0 [Note] [MY-011825] [Xtrabackup] page size for /data/backup/2022-12-31//jycdb/test.ibd.delta is 16384 bytes
2023-01-03T12:38:51.001206+08:00 0 [Note] [MY-011825] [Xtrabackup] Applying /data/backup/2022-12-31//jycdb/test.ibd.delta to ./jycdb/test.ibd
2023-01-03T12:38:51.002117+08:00 0 [Note] [MY-011825] [Xtrabackup] page size for /data/backup/2022-12-31//jyc/t.ibd.delta is 16384 bytes
2023-01-03T12:38:51.002236+08:00 0 [Note] [MY-011825] [Xtrabackup] Applying /data/backup/2022-12-31//jyc/t.ibd.delta to ./jyc/t.ibd
2023-01-03T12:38:51.003224+08:00 0 [Note] [MY-011825] [Xtrabackup] page size for /data/backup/2022-12-31//test/t.ibd.delta is 16384 bytes
2023-01-03T12:38:51.003345+08:00 0 [Note] [MY-011825] [Xtrabackup] Applying /data/backup/2022-12-31//test/t.ibd.delta to ./test/t.ibd
2023-01-03T12:38:51.004465+08:00 0 [Note] [MY-011825] [Xtrabackup] page size for /data/backup/2022-12-31//ibdata1.delta is 16384 bytes
2023-01-03T12:38:51.006904+08:00 0 [Note] [MY-011825] [Xtrabackup] Applying /data/backup/2022-12-31//ibdata1.delta to ./ibdata1
2023-01-03T12:38:51.008218+08:00 0 [Note] [MY-011825] [Xtrabackup] page size for /data/backup/2022-12-31//mysql.ibd.delta is 16384 bytes
2023-01-03T12:38:51.012842+08:00 0 [Note] [MY-011825] [Xtrabackup] Applying /data/backup/2022-12-31//mysql.ibd.delta to ./mysql.ibd
2023-01-03T12:38:51.014014+08:00 0 [Note] [MY-011825] [Xtrabackup] page size for /data/backup/2022-12-31//undo_002.delta is 16384 bytes
2023-01-03T12:38:51.017132+08:00 0 [Note] [MY-011825] [Xtrabackup] Applying /data/backup/2022-12-31//undo_002.delta to ./undo_002
2023-01-03T12:38:51.018095+08:00 0 [Note] [MY-011825] [Xtrabackup] page size for /data/backup/2022-12-31//undo_001.delta is 16384 bytes
2023-01-03T12:38:51.021205+08:00 0 [Note] [MY-011825] [Xtrabackup] Applying /data/backup/2022-12-31//undo_001.delta to ./undo_001
2023-01-03T12:38:51.223473+08:00 0 [Note] [MY-011825] [Xtrabackup] using the following InnoDB configuration for recovery:
2023-01-03T12:38:51.223531+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_home_dir = .
2023-01-03T12:38:51.223551+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_file_path = ibdata1:12M:autoextend
2023-01-03T12:38:51.223582+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_group_home_dir = /data/backup/2022-12-31/
2023-01-03T12:38:51.223600+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_files_in_group = 1
2023-01-03T12:38:51.223616+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_file_size = 8388608
2023-01-03T12:38:51.223644+08:00 0 [Note] [MY-011825] [Xtrabackup] Starting InnoDB instance for recovery.
2023-01-03T12:38:51.223663+08:00 0 [Note] [MY-011825] [Xtrabackup] Using 104857600 bytes for buffer pool (set by --use-memory parameter)
2023-01-03T12:38:51.223710+08:00 0 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available
2023-01-03T12:38:51.223751+08:00 0 [Note] [MY-012944] [InnoDB] Uses event mutexes
2023-01-03T12:38:51.223782+08:00 0 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier
2023-01-03T12:38:51.223805+08:00 0 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.12
2023-01-03T12:38:51.224124+08:00 0 [Note] [MY-013251] [InnoDB] Number of pools: 1
2023-01-03T12:38:51.224282+08:00 0 [Note] [MY-012951] [InnoDB] Using software crc32.
2023-01-03T12:38:51.224881+08:00 0 [Note] [MY-012203] [InnoDB] Directories to scan './'
2023-01-03T12:38:51.224958+08:00 0 [Note] [MY-012204] [InnoDB] Scanning './'
2023-01-03T12:38:51.230933+08:00 0 [Note] [MY-012208] [InnoDB] Completed space ID check of 7 files.
2023-01-03T12:38:51.231707+08:00 0 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 128.000000M, instances = 1, chunk size =128.000000M 
2023-01-03T12:38:51.246403+08:00 0 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool
2023-01-03T12:38:51.250760+08:00 0 [Note] [MY-011951] [InnoDB] page_cleaner coordinator priority: -20
2023-01-03T12:38:51.251118+08:00 0 [Note] [MY-011954] [InnoDB] page_cleaner worker priority: -20
2023-01-03T12:38:51.290339+08:00 0 [Note] [MY-011954] [InnoDB] page_cleaner worker priority: -20
2023-01-03T12:38:51.291146+08:00 0 [Note] [MY-011954] [InnoDB] page_cleaner worker priority: -20
2023-01-03T12:38:51.372788+08:00 0 [Note] [MY-013883] [InnoDB] The latest found checkpoint is at lsn = 20070958 in redo log file /data/backup/2022-12-31/#innodb_redo/#ib_redo0.
2023-01-03T12:38:51.372921+08:00 0 [Warning] [MY-012559] [InnoDB] Are you sure you are using the right redo log files to start up the database? Log sequence number in the redo log files is 20070958, less than the log sequence number in the first system tablespace file header, 20071958.
2023-01-03T12:38:51.372951+08:00 0 [Note] [MY-012560] [InnoDB] The log sequence number 20071958 in the system tablespace does not match the log sequence number 20070958 in the redo log files!
2023-01-03T12:38:51.372975+08:00 0 [Note] [MY-012551] [InnoDB] Database was not shutdown normally!
2023-01-03T12:38:51.372993+08:00 0 [Note] [MY-012552] [InnoDB] Starting crash recovery.
2023-01-03T12:38:51.373336+08:00 0 [Note] [MY-013086] [InnoDB] Starting to parse redo log at lsn = 20070928, whereas checkpoint_lsn = 20070958 and start_lsn = 20070912
2023-01-03T12:38:51.373374+08:00 0 [Note] [MY-012550] [InnoDB] Doing recovery: scanned up to log sequence number 20070958
2023-01-03T12:38:51.401888+08:00 0 [Note] [MY-013083] [InnoDB] Log background threads are being started...
2023-01-03T12:38:51.455663+08:00 0 [Note] [MY-012532] [InnoDB] Applying a batch of 0 redo log records ...
2023-01-03T12:38:51.455725+08:00 0 [Note] [MY-012535] [InnoDB] Apply batch completed!
2023-01-03T12:38:51.556160+08:00 0 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_001'.
2023-01-03T12:38:51.557202+08:00 0 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_002'.
2023-01-03T12:38:51.561234+08:00 0 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces.
2023-01-03T12:38:51.561329+08:00 0 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 5442
2023-01-03T12:38:51.664459+08:00 0 [Note] [MY-013776] [InnoDB] Parallel initialization of rseg complete
2023-01-03T12:38:51.664530+08:00 0 [Note] [MY-013777] [InnoDB] Time taken to initialize rseg using 2 thread: 103216 ms.
2023-01-03T12:38:51.667554+08:00 0 [Note] [MY-012255] [InnoDB] Removed temporary tablespace data file: "ibtmp1"
2023-01-03T12:38:51.667590+08:00 0 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables
2023-01-03T12:38:51.667756+08:00 0 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-01-03T12:38:51.711162+08:00 0 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB.
2023-01-03T12:38:51.711512+08:00 0 [Note] [MY-013627] [InnoDB] Scanning temp tablespace dir:'./#innodb_temp/'
2023-01-03T12:38:51.747238+08:00 0 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
2023-01-03T12:38:51.747712+08:00 0 [Note] [MY-012976] [InnoDB] 8.0.30 started; log sequence number 20070968
2023-01-03T12:38:51.748289+08:00 0 [Warning] [MY-012091] [InnoDB] Allocated tablespace ID 1 for sys/sys_config, old maximum was 0
2023-01-03T12:38:51.796670+08:00 0 [Note] [MY-011825] [Xtrabackup] starting shutdown with innodb_fast_shutdown = 1
2023-01-03T12:38:51.796796+08:00 0 [Note] [MY-012330] [InnoDB] FTS optimize thread exiting.
2023-01-03T12:38:52.792813+08:00 0 [Note] [MY-013072] [InnoDB] Starting shutdown...
2023-01-03T12:38:52.801164+08:00 0 [Note] [MY-013084] [InnoDB] Log background threads are being closed...
2023-01-03T12:38:52.825647+08:00 0 [Note] [MY-012980] [InnoDB] Shutdown completed; log sequence number 20070968
2023-01-03T12:38:52.827955+08:00 0 [Note] [MY-013251] [InnoDB] Number of pools: 1
2023-01-03T12:38:52.829774+08:00 0 [Note] [MY-011825] [Xtrabackup] Copying /data/backup/2022-12-31//mysql/slow_log.CSM to ./mysql/slow_log.CSM
2023-01-03T12:38:52.829908+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Copying /data/backup/2022-12-31//mysql/slow_log.CSM to ./mysql/slow_log.CSM
2023-01-03T12:38:52.830937+08:00 0 [Note] [MY-011825] [Xtrabackup] Copying /data/backup/2022-12-31//mysql/slow_log.CSV to ./mysql/slow_log.CSV
2023-01-03T12:38:52.830977+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Copying /data/backup/2022-12-31//mysql/slow_log.CSV to ./mysql/slow_log.CSV
2023-01-03T12:38:52.832738+08:00 0 [Note] [MY-011825] [Xtrabackup] Copying /data/backup/2022-12-31//mysql/general_log.CSV to ./mysql/general_log.CSV
2023-01-03T12:38:52.832790+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Copying /data/backup/2022-12-31//mysql/general_log.CSV to ./mysql/general_log.CSV
2023-01-03T12:38:52.834501+08:00 0 [Note] [MY-011825] [Xtrabackup] Copying /data/backup/2022-12-31//mysql/general_log.CSM to ./mysql/general_log.CSM
2023-01-03T12:38:52.834644+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Copying /data/backup/2022-12-31//mysql/general_log.CSM to ./mysql/general_log.CSM
2023-01-03T12:38:52.836527+08:00 0 [Note] [MY-011825] [Xtrabackup] Copying /data/backup/2022-12-31//mysql/general_log_496.sdi to ./mysql/general_log_496.sdi
2023-01-03T12:38:52.836667+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Copying /data/backup/2022-12-31//mysql/general_log_496.sdi to ./mysql/general_log_496.sdi
2023-01-03T12:38:52.837496+08:00 0 [Note] [MY-011825] [Xtrabackup] Copying /data/backup/2022-12-31//mysql/slow_log_498.sdi to ./mysql/slow_log_498.sdi
2023-01-03T12:38:52.837647+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Copying /data/backup/2022-12-31//mysql/slow_log_498.sdi to ./mysql/slow_log_498.sdi
2023-01-03T12:38:52.839405+08:00 0 [Note] [MY-011825] [Xtrabackup] Copying /data/backup/2022-12-31//performance_schema/clone_status_381.sdi to ./performance_schema/clone_status_381.sdi
2023-01-03T12:38:52.839551+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Copying /data/backup/2022-12-31//performance_schema/clone_status_381.sdi to ./performance_schema/clone_status_381.sdi
2023-01-03T12:38:52.841312+08:00 0 [Note] [MY-011825] [Xtrabackup] Copying /data/backup/2022-12-31//performance_schema/clone_progress_382.sdi to ./performance_schema/clone_progress_382.sdi
2023-01-03T12:38:52.841473+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Copying /data/backup/2022-12-31//performance_schema/clone_progress_382.sdi to ./performance_schema/clone_progress_382.sdi
2023-01-03T12:38:52.843415+08:00 0 [Note] [MY-011825] [Xtrabackup] Copying /data/backup/2022-12-31//xtrabackup_binlog_info to ./xtrabackup_binlog_info
2023-01-03T12:38:52.843541+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Copying /data/backup/2022-12-31//xtrabackup_binlog_info to ./xtrabackup_binlog_info
2023-01-03T12:38:52.845426+08:00 0 [Note] [MY-011825] [Xtrabackup] Copying /data/backup/2022-12-31//xtrabackup_info to ./xtrabackup_info
2023-01-03T12:38:52.845570+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Copying /data/backup/2022-12-31//xtrabackup_info to ./xtrabackup_info
2023-01-03T12:38:52.847393+08:00 0 [Note] [MY-011825] [Xtrabackup] Copying /data/backup/2022-12-31//xtrabackup_tablespaces to ./xtrabackup_tablespaces
2023-01-03T12:38:52.847516+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Copying /data/backup/2022-12-31//xtrabackup_tablespaces to ./xtrabackup_tablespaces
2023-01-03T12:38:52.849946+08:00 0 [Note] [MY-011825] [Xtrabackup] Copying /data/backup/2022-12-31/mysql-bin.000008 to ./mysql-bin.000008
2023-01-03T12:38:52.850111+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Copying /data/backup/2022-12-31/mysql-bin.000008 to ./mysql-bin.000008
2023-01-03T12:38:52.851854+08:00 0 [Note] [MY-011825] [Xtrabackup] Copying /data/backup/2022-12-31/mysql-bin.index to ./mysql-bin.index
2023-01-03T12:38:52.851978+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Copying /data/backup/2022-12-31/mysql-bin.index to ./mysql-bin.index
2023-01-03T12:38:52.854325+08:00 0 [Note] [MY-011825] [Xtrabackup] completed OK!
[root@mysql2 backup]# more /data/backup/2022-12-30/xtrabackup_checkpoints
backup_type = log-applied
from_lsn = 0
to_lsn = 20070958
last_lsn = 20070958
flushed_lsn = 20070958
redo_memory = 360
redo_frames = 1
[root@mysql2 backup]# more /data/backup/2022-12-31/xtrabackup_checkpoints
backup_type = incremental
from_lsn = 20070938
to_lsn = 20070958
last_lsn = 20070958
flushed_lsn = 20070958
redo_memory = 360
redo_frames = 1
[root@mysql2 backup]# xtrabackup --decompress --remove-original --target-dir=/data/backup/2023-01-01
2023-01-03T12:40:27.079491+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized server arguments: --datadir=/mysql/data --innodb_buffer_pool_size=2G --innodb_flush_log_at_trx_commit=2 --log_bin=/mysql/data/mysql-bin --server-id=2 
2023-01-03T12:40:27.079850+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized client arguments: --port=3306 --socket=/mysql/mysql.sock --decompress=1 --remove-original=1 --target-dir=/data/backup/2023-01-01 
xtrabackup version 8.0.30-23 based on MySQL server 8.0.30 Linux (x86_64) (revision id: 873b467185c)
2023-01-03T12:40:27.080838+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./xtrabackup_logfile.qp
2023-01-03T12:40:27.088120+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./xtrabackup_logfile.qp
2023-01-03T12:40:27.088296+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./ibdata1.delta.qp
2023-01-03T12:40:27.094781+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./ibdata1.delta.qp
2023-01-03T12:40:27.094945+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./sys/sys_config.ibd.delta.qp
2023-01-03T12:40:27.101416+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./sys/sys_config.ibd.delta.qp
2023-01-03T12:40:27.101593+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./jycdb/test.ibd.delta.qp
2023-01-03T12:40:27.108331+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./jycdb/test.ibd.delta.qp
2023-01-03T12:40:27.108500+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./jyc/t.ibd.delta.qp
2023-01-03T12:40:27.115071+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./jyc/t.ibd.delta.qp
2023-01-03T12:40:27.115244+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./test/t.ibd.delta.qp
2023-01-03T12:40:27.121603+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./test/t.ibd.delta.qp
2023-01-03T12:40:27.121785+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./mysql.ibd.delta.qp
2023-01-03T12:40:27.128103+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./mysql.ibd.delta.qp
2023-01-03T12:40:27.128266+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./undo_002.delta.qp
2023-01-03T12:40:27.135549+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./undo_002.delta.qp
2023-01-03T12:40:27.135716+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./undo_001.delta.qp
2023-01-03T12:40:27.142423+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./undo_001.delta.qp
2023-01-03T12:40:27.142633+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./mysql/slow_log.CSM.qp
2023-01-03T12:40:27.149105+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./mysql/slow_log.CSM.qp
2023-01-03T12:40:27.149270+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./mysql/slow_log.CSV.qp
2023-01-03T12:40:27.155635+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./mysql/slow_log.CSV.qp
2023-01-03T12:40:27.155796+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./mysql/general_log.CSV.qp
2023-01-03T12:40:27.162079+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./mysql/general_log.CSV.qp
2023-01-03T12:40:27.162249+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./mysql/general_log.CSM.qp
2023-01-03T12:40:27.168579+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./mysql/general_log.CSM.qp
2023-01-03T12:40:27.168735+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./mysql/general_log_496.sdi.qp
2023-01-03T12:40:27.175197+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./mysql/general_log_496.sdi.qp
2023-01-03T12:40:27.175359+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./mysql/slow_log_498.sdi.qp
2023-01-03T12:40:27.182042+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./mysql/slow_log_498.sdi.qp
2023-01-03T12:40:27.182219+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./performance_schema/clone_status_381.sdi.qp
2023-01-03T12:40:27.188697+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./performance_schema/clone_status_381.sdi.qp
2023-01-03T12:40:27.188854+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./performance_schema/clone_progress_382.sdi.qp
2023-01-03T12:40:27.195232+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./performance_schema/clone_progress_382.sdi.qp
2023-01-03T12:40:27.195391+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./mysql-bin.000009.qp
2023-01-03T12:40:27.201807+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./mysql-bin.000009.qp
2023-01-03T12:40:27.202033+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./mysql-bin.index.qp
2023-01-03T12:40:27.208407+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./mysql-bin.index.qp
2023-01-03T12:40:27.208579+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./xtrabackup_binlog_info.qp
2023-01-03T12:40:27.215692+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./xtrabackup_binlog_info.qp
2023-01-03T12:40:27.215859+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./ib_buffer_pool.qp
2023-01-03T12:40:27.222375+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./ib_buffer_pool.qp
2023-01-03T12:40:27.222546+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./backup-my.cnf.qp
2023-01-03T12:40:27.228970+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./backup-my.cnf.qp
2023-01-03T12:40:27.229154+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./xtrabackup_info.qp
2023-01-03T12:40:27.235510+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./xtrabackup_info.qp
2023-01-03T12:40:27.235687+08:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./xtrabackup_tablespaces.qp
2023-01-03T12:40:27.242116+08:00 0 [Note] [MY-011825] [Xtrabackup] removing ./xtrabackup_tablespaces.qp
2023-01-03T12:40:27.281850+08:00 0 [Note] [MY-011825] [Xtrabackup] completed OK!
[root@mysql2 backup]# xtrabackup --prepare --apply-log-only --target-dir=/data/backup/2022-12-30 --incremental-dir=/data/backup/2023-01-01
2023-01-03T12:40:37.683513+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized server arguments: --innodb_checksum_algorithm=crc32 --innodb_log_checksums=1 --innodb_data_file_path=ibdata1:12M:autoextend --innodb_log_file_size=50331648 --innodb_page_size=16384 --innodb_undo_directory=./ --innodb_undo_tablespaces=2 --server-id=2 --innodb_log_checksums=ON --innodb_redo_log_encrypt=0 --innodb_undo_log_encrypt=0 
2023-01-03T12:40:37.683826+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized client arguments: --prepare=1 --apply-log-only=1 --target-dir=/data/backup/2022-12-30 --incremental-dir=/data/backup/2023-01-01 
xtrabackup version 8.0.30-23 based on MySQL server 8.0.30 Linux (x86_64) (revision id: 873b467185c)
2023-01-03T12:40:37.683971+08:00 0 [Note] [MY-011825] [Xtrabackup] incremental backup from 20070958 is enabled.
2023-01-03T12:40:37.684014+08:00 0 [Note] [MY-011825] [Xtrabackup] cd to /data/backup/2022-12-30/
2023-01-03T12:40:37.684288+08:00 0 [Note] [MY-011825] [Xtrabackup] This target seems to be already prepared with --apply-log-only.
2023-01-03T12:40:37.685133+08:00 0 [Note] [MY-013251] [InnoDB] Number of pools: 1
2023-01-03T12:40:37.693954+08:00 0 [Note] [MY-011825] [Xtrabackup] xtrabackup_logfile detected: size=8388608, start_lsn=(20070978)
2023-01-03T12:40:37.694947+08:00 0 [Note] [MY-011825] [Xtrabackup] using the following InnoDB configuration for recovery:
2023-01-03T12:40:37.694980+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_home_dir = .
2023-01-03T12:40:37.694999+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_file_path = ibdata1:12M:autoextend
2023-01-03T12:40:37.695101+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_group_home_dir = /data/backup/2023-01-01/
2023-01-03T12:40:37.695123+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_files_in_group = 1
2023-01-03T12:40:37.695147+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_file_size = 8388608
2023-01-03T12:40:37.695703+08:00 0 [Note] [MY-011825] [Xtrabackup] inititialize_service_handles suceeded
2023-01-03T12:40:37.898758+08:00 0 [Note] [MY-011825] [Xtrabackup] Generating a list of tablespaces
2023-01-03T12:40:37.898895+08:00 0 [Note] [MY-011825] [Xtrabackup] Generating a list of tablespaces
2023-01-03T12:40:37.898928+08:00 0 [Note] [MY-012204] [InnoDB] Scanning './'
2023-01-03T12:40:37.899733+08:00 0 [Note] [MY-012208] [InnoDB] Completed space ID check of 2 files.
2023-01-03T12:40:37.900103+08:00 0 [Warning] [MY-012091] [InnoDB] Allocated tablespace ID 6 for test/t, old maximum was 0
2023-01-03T12:40:37.900656+08:00 0 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_001'.
2023-01-03T12:40:37.901411+08:00 0 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_002'.
2023-01-03T12:40:37.903420+08:00 0 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces.
2023-01-03T12:40:37.903640+08:00 0 [Note] [MY-011825] [Xtrabackup] page size for /data/backup/2023-01-01//sys/sys_config.ibd.delta is 16384 bytes
2023-01-03T12:40:37.903751+08:00 0 [Note] [MY-011825] [Xtrabackup] Applying /data/backup/2023-01-01//sys/sys_config.ibd.delta to ./sys/sys_config.ibd
2023-01-03T12:40:37.904875+08:00 0 [Note] [MY-011825] [Xtrabackup] page size for /data/backup/2023-01-01//jycdb/test.ibd.delta is 16384 bytes
2023-01-03T12:40:37.904988+08:00 0 [Note] [MY-011825] [Xtrabackup] Applying /data/backup/2023-01-01//jycdb/test.ibd.delta to ./jycdb/test.ibd
2023-01-03T12:40:37.905989+08:00 0 [Note] [MY-011825] [Xtrabackup] page size for /data/backup/2023-01-01//jyc/t.ibd.delta is 16384 bytes
2023-01-03T12:40:37.906128+08:00 0 [Note] [MY-011825] [Xtrabackup] Applying /data/backup/2023-01-01//jyc/t.ibd.delta to ./jyc/t.ibd
2023-01-03T12:40:37.907015+08:00 0 [Note] [MY-011825] [Xtrabackup] page size for /data/backup/2023-01-01//test/t.ibd.delta is 16384 bytes
2023-01-03T12:40:37.907155+08:00 0 [Note] [MY-011825] [Xtrabackup] Applying /data/backup/2023-01-01//test/t.ibd.delta to ./test/t.ibd
2023-01-03T12:40:37.908284+08:00 0 [Note] [MY-011825] [Xtrabackup] page size for /data/backup/2023-01-01//ibdata1.delta is 16384 bytes
2023-01-03T12:40:37.908589+08:00 0 [Note] [MY-011825] [Xtrabackup] Applying /data/backup/2023-01-01//ibdata1.delta to ./ibdata1
2023-01-03T12:40:37.910095+08:00 0 [Note] [MY-011825] [Xtrabackup] page size for /data/backup/2023-01-01//mysql.ibd.delta is 16384 bytes
2023-01-03T12:40:37.910379+08:00 0 [Note] [MY-011825] [Xtrabackup] Applying /data/backup/2023-01-01//mysql.ibd.delta to ./mysql.ibd
2023-01-03T12:40:37.911278+08:00 0 [Note] [MY-011825] [Xtrabackup] page size for /data/backup/2023-01-01//undo_002.delta is 16384 bytes
2023-01-03T12:40:37.913262+08:00 0 [Note] [MY-011825] [Xtrabackup] Applying /data/backup/2023-01-01//undo_002.delta to ./undo_002
2023-01-03T12:40:37.914283+08:00 0 [Note] [MY-011825] [Xtrabackup] page size for /data/backup/2023-01-01//undo_001.delta is 16384 bytes
2023-01-03T12:40:37.916223+08:00 0 [Note] [MY-011825] [Xtrabackup] Applying /data/backup/2023-01-01//undo_001.delta to ./undo_001
2023-01-03T12:40:38.120899+08:00 0 [Note] [MY-011825] [Xtrabackup] using the following InnoDB configuration for recovery:
2023-01-03T12:40:38.120961+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_home_dir = .
2023-01-03T12:40:38.120982+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_file_path = ibdata1:12M:autoextend
2023-01-03T12:40:38.121014+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_group_home_dir = /data/backup/2023-01-01/
2023-01-03T12:40:38.121033+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_files_in_group = 1
2023-01-03T12:40:38.121050+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_file_size = 8388608
2023-01-03T12:40:38.121112+08:00 0 [Note] [MY-011825] [Xtrabackup] Starting InnoDB instance for recovery.
2023-01-03T12:40:38.121133+08:00 0 [Note] [MY-011825] [Xtrabackup] Using 104857600 bytes for buffer pool (set by --use-memory parameter)
2023-01-03T12:40:38.121182+08:00 0 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available
2023-01-03T12:40:38.121224+08:00 0 [Note] [MY-012944] [InnoDB] Uses event mutexes
2023-01-03T12:40:38.121242+08:00 0 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier
2023-01-03T12:40:38.121261+08:00 0 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.12
2023-01-03T12:40:38.121547+08:00 0 [Note] [MY-013251] [InnoDB] Number of pools: 1
2023-01-03T12:40:38.121706+08:00 0 [Note] [MY-012951] [InnoDB] Using software crc32.
2023-01-03T12:40:38.122394+08:00 0 [Note] [MY-012203] [InnoDB] Directories to scan './'
2023-01-03T12:40:38.122476+08:00 0 [Note] [MY-012204] [InnoDB] Scanning './'
2023-01-03T12:40:38.128053+08:00 0 [Note] [MY-012208] [InnoDB] Completed space ID check of 7 files.
2023-01-03T12:40:38.128820+08:00 0 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 128.000000M, instances = 1, chunk size =128.000000M 
2023-01-03T12:40:38.143384+08:00 0 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool
2023-01-03T12:40:38.149015+08:00 0 [Note] [MY-011951] [InnoDB] page_cleaner coordinator priority: -20
2023-01-03T12:40:38.149358+08:00 0 [Note] [MY-011954] [InnoDB] page_cleaner worker priority: -20
2023-01-03T12:40:38.150260+08:00 0 [Note] [MY-011954] [InnoDB] page_cleaner worker priority: -20
2023-01-03T12:40:38.166289+08:00 0 [Note] [MY-011954] [InnoDB] page_cleaner worker priority: -20
2023-01-03T12:40:38.266343+08:00 0 [Note] [MY-013883] [InnoDB] The latest found checkpoint is at lsn = 20070978 in redo log file /data/backup/2023-01-01/#innodb_redo/#ib_redo0.
2023-01-03T12:40:38.266479+08:00 0 [Note] [MY-012560] [InnoDB] The log sequence number 20070968 in the system tablespace does not match the log sequence number 20070978 in the redo log files!
2023-01-03T12:40:38.266509+08:00 0 [Note] [MY-012551] [InnoDB] Database was not shutdown normally!
2023-01-03T12:40:38.266528+08:00 0 [Note] [MY-012552] [InnoDB] Starting crash recovery.
2023-01-03T12:40:38.266749+08:00 0 [Note] [MY-013086] [InnoDB] Starting to parse redo log at lsn = 20070928, whereas checkpoint_lsn = 20070978 and start_lsn = 20070912
2023-01-03T12:40:38.266787+08:00 0 [Note] [MY-012550] [InnoDB] Doing recovery: scanned up to log sequence number 20070978
2023-01-03T12:40:38.291272+08:00 0 [Note] [MY-013083] [InnoDB] Log background threads are being started...
2023-01-03T12:40:38.353713+08:00 0 [Note] [MY-012532] [InnoDB] Applying a batch of 0 redo log records ...
2023-01-03T12:40:38.353771+08:00 0 [Note] [MY-012535] [InnoDB] Apply batch completed!
2023-01-03T12:40:38.454315+08:00 0 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_001'.
2023-01-03T12:40:38.455448+08:00 0 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_002'.
2023-01-03T12:40:38.459493+08:00 0 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces.
2023-01-03T12:40:38.459584+08:00 0 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 5444
2023-01-03T12:40:38.559366+08:00 0 [Note] [MY-013776] [InnoDB] Parallel initialization of rseg complete
2023-01-03T12:40:38.559436+08:00 0 [Note] [MY-013777] [InnoDB] Time taken to initialize rseg using 2 thread: 99862 ms.
2023-01-03T12:40:38.562384+08:00 0 [Note] [MY-012255] [InnoDB] Removed temporary tablespace data file: "ibtmp1"
2023-01-03T12:40:38.562420+08:00 0 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables
2023-01-03T12:40:38.562583+08:00 0 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-01-03T12:40:38.603100+08:00 0 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB.
2023-01-03T12:40:38.603541+08:00 0 [Note] [MY-013627] [InnoDB] Scanning temp tablespace dir:'./#innodb_temp/'
2023-01-03T12:40:38.626380+08:00 0 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
2023-01-03T12:40:38.626652+08:00 0 [Note] [MY-012976] [InnoDB] 8.0.30 started; log sequence number 20070988
2023-01-03T12:40:38.627179+08:00 0 [Warning] [MY-012091] [InnoDB] Allocated tablespace ID 1 for sys/sys_config, old maximum was 0
2023-01-03T12:40:38.671662+08:00 0 [Note] [MY-011825] [Xtrabackup] starting shutdown with innodb_fast_shutdown = 1
2023-01-03T12:40:38.671825+08:00 0 [Note] [MY-012330] [InnoDB] FTS optimize thread exiting.
2023-01-03T12:40:39.671633+08:00 0 [Note] [MY-013072] [InnoDB] Starting shutdown...
2023-01-03T12:40:39.679931+08:00 0 [Note] [MY-013084] [InnoDB] Log background threads are being closed...
2023-01-03T12:40:39.702501+08:00 0 [Note] [MY-012980] [InnoDB] Shutdown completed; log sequence number 20070988
2023-01-03T12:40:39.704719+08:00 0 [Note] [MY-013251] [InnoDB] Number of pools: 1
2023-01-03T12:40:39.706554+08:00 0 [Note] [MY-011825] [Xtrabackup] Copying /data/backup/2023-01-01//mysql/slow_log.CSM to ./mysql/slow_log.CSM
2023-01-03T12:40:39.706726+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Copying /data/backup/2023-01-01//mysql/slow_log.CSM to ./mysql/slow_log.CSM
2023-01-03T12:40:39.708851+08:00 0 [Note] [MY-011825] [Xtrabackup] Copying /data/backup/2023-01-01//mysql/slow_log.CSV to ./mysql/slow_log.CSV
2023-01-03T12:40:39.708902+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Copying /data/backup/2023-01-01//mysql/slow_log.CSV to ./mysql/slow_log.CSV
2023-01-03T12:40:39.709727+08:00 0 [Note] [MY-011825] [Xtrabackup] Copying /data/backup/2023-01-01//mysql/general_log.CSV to ./mysql/general_log.CSV
2023-01-03T12:40:39.709769+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Copying /data/backup/2023-01-01//mysql/general_log.CSV to ./mysql/general_log.CSV
2023-01-03T12:40:39.711512+08:00 0 [Note] [MY-011825] [Xtrabackup] Copying /data/backup/2023-01-01//mysql/general_log.CSM to ./mysql/general_log.CSM
2023-01-03T12:40:39.711687+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Copying /data/backup/2023-01-01//mysql/general_log.CSM to ./mysql/general_log.CSM
2023-01-03T12:40:39.712620+08:00 0 [Note] [MY-011825] [Xtrabackup] Copying /data/backup/2023-01-01//mysql/general_log_496.sdi to ./mysql/general_log_496.sdi
2023-01-03T12:40:39.712789+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Copying /data/backup/2023-01-01//mysql/general_log_496.sdi to ./mysql/general_log_496.sdi
2023-01-03T12:40:39.714681+08:00 0 [Note] [MY-011825] [Xtrabackup] Copying /data/backup/2023-01-01//mysql/slow_log_498.sdi to ./mysql/slow_log_498.sdi
2023-01-03T12:40:39.714863+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Copying /data/backup/2023-01-01//mysql/slow_log_498.sdi to ./mysql/slow_log_498.sdi
2023-01-03T12:40:39.716810+08:00 0 [Note] [MY-011825] [Xtrabackup] Copying /data/backup/2023-01-01//performance_schema/clone_status_381.sdi to ./performance_schema/clone_status_381.sdi
2023-01-03T12:40:39.716984+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Copying /data/backup/2023-01-01//performance_schema/clone_status_381.sdi to ./performance_schema/clone_status_381.sdi
2023-01-03T12:40:39.718774+08:00 0 [Note] [MY-011825] [Xtrabackup] Copying /data/backup/2023-01-01//performance_schema/clone_progress_382.sdi to ./performance_schema/clone_progress_382.sdi
2023-01-03T12:40:39.718959+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Copying /data/backup/2023-01-01//performance_schema/clone_progress_382.sdi to ./performance_schema/clone_progress_382.sdi
2023-01-03T12:40:39.720129+08:00 0 [Note] [MY-011825] [Xtrabackup] Copying /data/backup/2023-01-01//xtrabackup_binlog_info to ./xtrabackup_binlog_info
2023-01-03T12:40:39.720292+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Copying /data/backup/2023-01-01//xtrabackup_binlog_info to ./xtrabackup_binlog_info
2023-01-03T12:40:39.722361+08:00 0 [Note] [MY-011825] [Xtrabackup] Copying /data/backup/2023-01-01//xtrabackup_info to ./xtrabackup_info
2023-01-03T12:40:39.722546+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Copying /data/backup/2023-01-01//xtrabackup_info to ./xtrabackup_info
2023-01-03T12:40:39.724493+08:00 0 [Note] [MY-011825] [Xtrabackup] Copying /data/backup/2023-01-01//xtrabackup_tablespaces to ./xtrabackup_tablespaces
2023-01-03T12:40:39.724668+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Copying /data/backup/2023-01-01//xtrabackup_tablespaces to ./xtrabackup_tablespaces
2023-01-03T12:40:39.726988+08:00 0 [Note] [MY-011825] [Xtrabackup] Copying /data/backup/2023-01-01/mysql-bin.000009 to ./mysql-bin.000009
2023-01-03T12:40:39.727201+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Copying /data/backup/2023-01-01/mysql-bin.000009 to ./mysql-bin.000009
2023-01-03T12:40:39.729250+08:00 0 [Note] [MY-011825] [Xtrabackup] Copying /data/backup/2023-01-01/mysql-bin.index to ./mysql-bin.index
2023-01-03T12:40:39.729429+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Copying /data/backup/2023-01-01/mysql-bin.index to ./mysql-bin.index
2023-01-03T12:40:39.731656+08:00 0 [Note] [MY-011825] [Xtrabackup] completed OK!
[root@mysql2 backup]# more /data/backup/2023-01-01/xtrabackup_checkpoints
backup_type = incremental
from_lsn = 20070958
to_lsn = 20070978
last_lsn = 20070978
flushed_lsn = 20070978
redo_memory = 360
redo_frames = 1
[root@mysql2 backup]# more /data/backup/2023-01-02/xtrabackup_checkpoints
backup_type = incremental
from_lsn = 20070978
to_lsn = 20070998
last_lsn = 20070998
flushed_lsn = 20070998
redo_memory = 360
redo_frames = 1
[root@mysql2 backup]# more /data/backup/2022-12-31/xtrabackup_checkpoints
backup_type = incremental
from_lsn = 20070938
to_lsn = 20070958
last_lsn = 20070958
flushed_lsn = 20070958
redo_memory = 360
redo_frames = 1
[root@mysql2 backup]# more /data/backup/2022-12-30/xtrabackup_checkpoints
backup_type = log-applied
from_lsn = 0
to_lsn = 20070978
last_lsn = 20070978
flushed_lsn = 20070978
redo_memory = 360
redo_frames = 1

相关参考：
xtrabackup-8.0的安装、备份以及恢复