今日は、Percona XtraBackupのMySQLバージョン違いの挙動が気になったの日。
目次
とある日
どうやら、PerconaXtraBackupはMySQL8.0.29には対応していないらしい。
8.0.29では、この機能が拡張され、INSTANTアルゴリズムがテーブルの任意の位置に列を追加したり、列を削除したりできるようになりました。この新しい機能では、REDOログのバージョンを増やし、新しいREDOログの種類を追加する必要がありました。そのため、古いバージョンのMySQLサーバーや古いバージョンのPerconaXtrabackupとの互換性がなくなりました。サーバーのインプレースマイナーバージョンダウングレードもサポートされていないことに注意してください。
MySQL 8.0.29 and Percona XtraBackup Incompatibilities - Percona Database Performance Blog
この記事が出る前に、MySQL8.0.29に対してXtraBackup 8.0.28-20を試したらエラーになりました。
そのとき、新しいバージョンには対応していないと思い込んでしましたが、記事を見る限りMySQL8.0.29だけの挙動なのかなと思いました。
単純にその時の挙動が気になったので調べました。
検証
概要
PerconaXtraBackupがどのMySQLバージョンに対応しているのかを調べます。
具体的には以下のとおりです。
環境は、docker-composeでMySQL環境立ててます。
コマンドはうまくいかないので各環境にログインしたあと手動でインストールしています。
version: "3" services: # XtraBackup: # image: perconalab/percona-xtrabackup:8.0.28-20 # container_name: xtrabackup # volumes: # - ./backup:/var # - ./backup:/backup XtraBackupdb2: image: mysql:8.0.27 container_name: XtraBackup_mysql_ver_8.0.27 environment: MYSQL_ROOT_PASSWORD: root MYSQL_DATABASE: test MYSQL_USER: docker MYSQL_PASSWORD: docker TZ: "Asia/Tokyo" command: - mysqld --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci - apt-get install -y wget - agt-get install -y curl - wget https://repo.percona.com/apt/percona-release_latest.buster_all.deb - dpkg -i percona-release_latest.buster_all.deb - apt-get update -y - percona-release enable-only tools release - percona-release enable-only tools - apt -y install percona-xtrabackup-80 - apt -y install qpress volumes: - ../../MySQL/settings/my.cnf:/etc/mysql/conf.d/my.cnf - ../../MySQL/settings/mylogin.sh:/root/mylogin.sh XtraBackupdb3: image: mysql:8.0.28 container_name: XtraBackup_mysql_ver_8.0.28 environment: MYSQL_ROOT_PASSWORD: root MYSQL_DATABASE: test MYSQL_USER: docker MYSQL_PASSWORD: docker TZ: "Asia/Tokyo" command: - mysqld --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci - apt-get install -y wget - agt-get install -y curl - wget https://repo.percona.com/apt/percona-release_latest.buster_all.deb - dpkg -i percona-release_latest.buster_all.deb - apt-get update -y - percona-release enable-only tools release - percona-release enable-only tools - apt -y install percona-xtrabackup-80 - apt -y install qpress volumes: - ../../MySQL/settings/my.cnf:/etc/mysql/conf.d/my.cnf - ../../MySQL/settings/mylogin.sh:/root/mylogin.sh XtraBackupdb4: image: mysql:8.0.29 container_name: XtraBackup_mysql_ver_8.0.29 environment: MYSQL_ROOT_PASSWORD: root MYSQL_DATABASE: test MYSQL_USER: docker MYSQL_PASSWORD: docker TZ: "Asia/Tokyo" command: mysqld --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci - apt-get install -y wget - agt-get install -y curl - wget https://repo.percona.com/apt/percona-release_latest.buster_all.deb - dpkg -i percona-release_latest.buster_all.deb - apt-get update -y - percona-release enable-only tools release - percona-release enable-only tools - apt -y install percona-xtrabackup-80 - apt -y install qpress volumes: - ../../MySQL/settings/my.cnf:/etc/mysql/conf.d/my.cnf - ../../MySQL/settings/mylogin.sh:/root/mylogin.sh
結論
XtraBackupは上位バージョンは対応していない。
別に、エラー文の違いとかは特になさそう。
XtraBackup 8.0.28-20
| MySQL | XtraBackup | 結果 |
|---|---|---|
| 8.0.29 | 8.0.28-20 | Error: Unsupported server version 8.0.29. |
| 8.0.28 | 8.0.28-20 | [Xtrabackup] completed OK! |
| 8.0.27 | 8.0.28-20 | [Xtrabackup] completed OK! |
XtraBackup 8.0.27-20
| MySQL | XtraBackup | 結果 |
|---|---|---|
| 8.0.29 | 8.0.27-19 | Error: Unsupported server version 8.0.29. |
| 8.0.28 | 8.0.27-19 | Error: Unsupported server version 8.0.28. |
| 8.0.27 | 8.0.27-19 | completed OK! |
xtrabackup version 8.0.28-20
インストール手順
Docker環境だと色々足りなかったのでインストールしました。
Installing Percona XtraBackup on Debian and Ubuntu — Percona XtraBackup 8.0 Documentation
apt-get update apt-get install curl apt-get install -y wget wget https://repo.percona.com/apt/percona-release_latest.buster_all.deb dpkg -i percona-release_latest.buster_all.deb apt-get install lsb-release apt --fix-broken install apt-get update percona-release enable-only tools apt-get update apt install percona-xtrabackup-80 apt install qpress
MySQL 8.0.29
失敗。
root@c8b975a6fea1:/# xtrabackup --backup --target-dir=/backup/backup8028 --user=root --password=root 2022-05-15T18:36:21.388727+09:00 0 [Note] [MY-011825] [Xtrabackup] recognized server arguments: --datadir=/var/lib/mysql 2022-05-15T18:36:21.392760+09:00 0 [Note] [MY-011825] [Xtrabackup] recognized client arguments: --backup=1 --target-dir=/backup/backup8028 --user=root --password=* xtrabackup version 8.0.28-20 based on MySQL server 8.0.28 Linux (x86_64) (revision id: 4cc3081873d) 220515 18:36:21 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'root' (using password: YES). 220515 18:36:21 version_check Connected to MySQL server 220515 18:36:21 version_check Executing a version check against the server... 220515 18:36:21 version_check Done. 2022-05-15T18:36:21.506221+09:00 0 [Note] [MY-011825] [Xtrabackup] Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: not set 2022-05-15T18:36:21.535177+09:00 0 [ERROR] [MY-011825] [Xtrabackup] Unsupported server version 8.0.29 2022-05-15T18:36:21.535225+09:00 0 [ERROR] [MY-011825] [Xtrabackup] Please upgrade PXB, if a new version is available. To continue with risk, use the option --no-server-version-check. root@c8b975a6fea1:/#
MySQL 8.0.28
成功。
root@dfa20732334c:~# xtrabackup --backup --target-dir=/backup/backup8028 --user=root --password=root 2022-05-13T08:28:17.435351+09:00 0 [Note] [MY-011825] [Xtrabackup] recognized server arguments: --datadir=/var/lib/mysql 2022-05-13T08:28:17.436469+09:00 0 [Note] [MY-011825] [Xtrabackup] recognized client arguments: --backup=1 --target-dir=/backup/backup8028 --user=root --password=* xtrabackup version 8.0.28-20 based on MySQL server 8.0.28 Linux (x86_64) (revision id: 4cc3081873d) 220513 08:28:17 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'root' (using password: YES). 220513 08:28:17 version_check Connected to MySQL server 220513 08:28:17 version_check Executing a version check against the server... 220513 08:28:17 version_check Done. 2022-05-13T08:28:17.491658+09:00 0 [Note] [MY-011825] [Xtrabackup] Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: not set 2022-05-13T08:28:17.494135+09:00 0 [Note] [MY-011825] [Xtrabackup] Using server version 8.0.28 2022-05-13T08:28:17.495802+09:00 0 [Note] [MY-011825] [Xtrabackup] Executing LOCK INSTANCE FOR BACKUP ... 2022-05-13T08:28:17.496267+09:00 0 [Note] [MY-011825] [Xtrabackup] uses posix_fadvise(). 2022-05-13T08:28:17.496308+09:00 0 [Note] [MY-011825] [Xtrabackup] cd to /var/lib/mysql 2022-05-13T08:28:17.496339+09:00 0 [Note] [MY-011825] [Xtrabackup] open files limit requested 0, set to 1048576 2022-05-13T08:28:17.496383+09:00 0 [Note] [MY-011825] [Xtrabackup] using the following InnoDB configuration: 2022-05-13T08:28:17.496409+09:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_home_dir = . 2022-05-13T08:28:17.496435+09:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_file_path = ibdata1:12M:autoextend 2022-05-13T08:28:17.496474+09:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_group_home_dir = ./ 2022-05-13T08:28:17.496501+09:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_files_in_group = 2 2022-05-13T08:28:17.496531+09:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_file_size = 50331648 2022-05-13T08:28:17.496918+09:00 0 [Note] [MY-013251] [InnoDB] Number of pools: 1 2022-05-13T08:28:17.497844+09:00 0 [Note] [MY-011825] [Xtrabackup] inititialize_service_handles suceeded 2022-05-13T08:28:17.567118+09:00 0 [Note] [MY-011825] [Xtrabackup] Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: not set 2022-05-13T08:28:17.569386+09:00 0 [Note] [MY-011825] [Xtrabackup] Redo Log Archiving is not set up. 2022-05-13T08:28:17.669162+09:00 1 [Note] [MY-011825] [Xtrabackup] >> log scanned up to (28623905) 2022-05-13T08:28:17.871402+09:00 0 [Note] [MY-011825] [Xtrabackup] Generating a list of tablespaces 2022-05-13T08:28:17.871459+09:00 0 [Note] [MY-011825] [Xtrabackup] Generating a list of tablespaces 2022-05-13T08:28:17.871487+09:00 0 [Note] [MY-012204] [InnoDB] Scanning './' 2022-05-13T08:28:17.872580+09:00 0 [Note] [MY-012208] [InnoDB] Completed space ID check of 2 files. 2022-05-13T08:28:17.873430+09:00 0 [Warning] [MY-012091] [InnoDB] Allocated tablespace ID 1 for sys/sys_config, old maximum was 0 2022-05-13T08:28:17.873503+09:00 0 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_001'. 2022-05-13T08:28:17.873937+09:00 0 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_002'. 2022-05-13T08:28:17.874492+09:00 0 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces. 2022-05-13T08:28:17.874805+09:00 2 [Note] [MY-011825] [Xtrabackup] Copying ./ibdata1 to /backup/backup8028/ibdata1 2022-05-13T08:28:17.897419+09:00 2 [Note] [MY-011825] [Xtrabackup] Done: Copying ./ibdata1 to /backup/backup8028/ibdata1 2022-05-13T08:28:17.900800+09:00 2 [Note] [MY-011825] [Xtrabackup] Copying ./sys/sys_config.ibd to /backup/backup8028/sys/sys_config.ibd 2022-05-13T08:28:17.900986+09:00 2 [Note] [MY-011825] [Xtrabackup] Done: Copying ./sys/sys_config.ibd to /backup/backup8028/sys/sys_config.ibd 2022-05-13T08:28:17.903825+09:00 2 [Note] [MY-011825] [Xtrabackup] Copying ./mysql.ibd to /backup/backup8028/mysql.ibd 2022-05-13T08:28:17.964998+09:00 2 [Note] [MY-011825] [Xtrabackup] Done: Copying ./mysql.ibd to /backup/backup8028/mysql.ibd 2022-05-13T08:28:17.974910+09:00 2 [Note] [MY-011825] [Xtrabackup] Copying ./undo_002 to /backup/backup8028/undo_002 2022-05-13T08:28:18.004661+09:00 2 [Note] [MY-011825] [Xtrabackup] Done: Copying ./undo_002 to /backup/backup8028/undo_002 2022-05-13T08:28:18.010634+09:00 2 [Note] [MY-011825] [Xtrabackup] Copying ./undo_001 to /backup/backup8028/undo_001 2022-05-13T08:28:18.039936+09:00 2 [Note] [MY-011825] [Xtrabackup] Done: Copying ./undo_001 to /backup/backup8028/undo_001 2022-05-13T08:28:18.669330+09:00 1 [Note] [MY-011825] [Xtrabackup] >> log scanned up to (28623905) 2022-05-13T08:28:18.874773+09:00 0 [Note] [MY-011825] [Xtrabackup] Starting to backup non-InnoDB tables and files 2022-05-13T08:28:18.875289+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/rwlock_instances_101.sdi to /backup/backup8028/performance_schema/rwlock_instances_101.sdi 2022-05-13T08:28:18.876251+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/rwlock_instances_101.sdi to /backup/backup8028/performance_schema/rwlock_instances_101.sdi 2022-05-13T08:28:18.881314+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/variables_by_thr_183.sdi to /backup/backup8028/performance_schema/variables_by_thr_183.sdi 2022-05-13T08:28:18.881622+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/variables_by_thr_183.sdi to /backup/backup8028/performance_schema/variables_by_thr_183.sdi 2022-05-13T08:28:18.884391+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/keyring_keys_152.sdi to /backup/backup8028/performance_schema/keyring_keys_152.sdi 2022-05-13T08:28:18.884760+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/keyring_keys_152.sdi to /backup/backup8028/performance_schema/keyring_keys_152.sdi 2022-05-13T08:28:18.887316+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/setup_actors_102.sdi to /backup/backup8028/performance_schema/setup_actors_102.sdi 2022-05-13T08:28:18.887591+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/setup_actors_102.sdi to /backup/backup8028/performance_schema/setup_actors_102.sdi 2022-05-13T08:28:18.890096+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/prepared_stateme_175.sdi to /backup/backup8028/performance_schema/prepared_stateme_175.sdi 2022-05-13T08:28:18.890477+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/prepared_stateme_175.sdi to /backup/backup8028/performance_schema/prepared_stateme_175.sdi 2022-05-13T08:28:18.893191+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/table_io_waits_s_108.sdi to /backup/backup8028/performance_schema/table_io_waits_s_108.sdi 2022-05-13T08:28:18.893600+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/table_io_waits_s_108.sdi to /backup/backup8028/performance_schema/table_io_waits_s_108.sdi 2022-05-13T08:28:18.896120+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/setup_consumers_103.sdi to /backup/backup8028/performance_schema/setup_consumers_103.sdi 2022-05-13T08:28:18.896516+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/setup_consumers_103.sdi to /backup/backup8028/performance_schema/setup_consumers_103.sdi 2022-05-13T08:28:18.899139+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_errors_su_143.sdi to /backup/backup8028/performance_schema/events_errors_su_143.sdi 2022-05-13T08:28:18.899498+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_errors_su_143.sdi to /backup/backup8028/performance_schema/events_errors_su_143.sdi 2022-05-13T08:28:18.902387+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/threads_110.sdi to /backup/backup8028/performance_schema/threads_110.sdi 2022-05-13T08:28:18.902779+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/threads_110.sdi to /backup/backup8028/performance_schema/threads_110.sdi 2022-05-13T08:28:18.905308+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_statement_128.sdi to /backup/backup8028/performance_schema/events_statement_128.sdi 2022-05-13T08:28:18.905646+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_statement_128.sdi to /backup/backup8028/performance_schema/events_statement_128.sdi 2022-05-13T08:28:18.908343+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_waits_sum_88.sdi to /backup/backup8028/performance_schema/events_waits_sum_88.sdi 2022-05-13T08:28:18.908781+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_waits_sum_88.sdi to /backup/backup8028/performance_schema/events_waits_sum_88.sdi 2022-05-13T08:28:18.911561+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/file_summary_by__95.sdi to /backup/backup8028/performance_schema/file_summary_by__95.sdi 2022-05-13T08:28:18.912005+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/file_summary_by__95.sdi to /backup/backup8028/performance_schema/file_summary_by__95.sdi 2022-05-13T08:28:18.914527+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/metadata_locks_159.sdi to /backup/backup8028/performance_schema/metadata_locks_159.sdi 2022-05-13T08:28:18.914873+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/metadata_locks_159.sdi to /backup/backup8028/performance_schema/metadata_locks_159.sdi 2022-05-13T08:28:18.917754+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_errors_su_141.sdi to /backup/backup8028/performance_schema/events_errors_su_141.sdi 2022-05-13T08:28:18.918164+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_errors_su_141.sdi to /backup/backup8028/performance_schema/events_errors_su_141.sdi 2022-05-13T08:28:18.920954+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_waits_sum_92.sdi to /backup/backup8028/performance_schema/events_waits_sum_92.sdi 2022-05-13T08:28:18.921272+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_waits_sum_92.sdi to /backup/backup8028/performance_schema/events_waits_sum_92.sdi 2022-05-13T08:28:18.923885+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/processlist_100.sdi to /backup/backup8028/performance_schema/processlist_100.sdi 2022-05-13T08:28:18.924165+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/processlist_100.sdi to /backup/backup8028/performance_schema/processlist_100.sdi 2022-05-13T08:28:18.927070+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_waits_cur_84.sdi to /backup/backup8028/performance_schema/events_waits_cur_84.sdi 2022-05-13T08:28:18.927469+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_waits_cur_84.sdi to /backup/backup8028/performance_schema/events_waits_cur_84.sdi 2022-05-13T08:28:18.929966+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/replication_asyn_172.sdi to /backup/backup8028/performance_schema/replication_asyn_172.sdi 2022-05-13T08:28:18.930261+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/replication_asyn_172.sdi to /backup/backup8028/performance_schema/replication_asyn_172.sdi 2022-05-13T08:28:18.932822+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/replication_appl_165.sdi to /backup/backup8028/performance_schema/replication_appl_165.sdi 2022-05-13T08:28:18.933191+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/replication_appl_165.sdi to /backup/backup8028/performance_schema/replication_appl_165.sdi 2022-05-13T08:28:18.935985+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_transacti_137.sdi to /backup/backup8028/performance_schema/events_transacti_137.sdi 2022-05-13T08:28:18.936325+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_transacti_137.sdi to /backup/backup8028/performance_schema/events_transacti_137.sdi 2022-05-13T08:28:18.938781+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/cond_instances_82.sdi to /backup/backup8028/performance_schema/cond_instances_82.sdi 2022-05-13T08:28:18.939017+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/cond_instances_82.sdi to /backup/backup8028/performance_schema/cond_instances_82.sdi 2022-05-13T08:28:18.941606+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_stages_su_117.sdi to /backup/backup8028/performance_schema/events_stages_su_117.sdi 2022-05-13T08:28:18.942241+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_stages_su_117.sdi to /backup/backup8028/performance_schema/events_stages_su_117.sdi 2022-05-13T08:28:18.945113+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/status_by_accoun_177.sdi to /backup/backup8028/performance_schema/status_by_accoun_177.sdi 2022-05-13T08:28:18.945439+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/status_by_accoun_177.sdi to /backup/backup8028/performance_schema/status_by_accoun_177.sdi 2022-05-13T08:28:18.947974+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/memory_summary_b_155.sdi to /backup/backup8028/performance_schema/memory_summary_b_155.sdi 2022-05-13T08:28:18.948263+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/memory_summary_b_155.sdi to /backup/backup8028/performance_schema/memory_summary_b_155.sdi 2022-05-13T08:28:18.951019+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_stages_su_116.sdi to /backup/backup8028/performance_schema/events_stages_su_116.sdi 2022-05-13T08:28:18.951377+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_stages_su_116.sdi to /backup/backup8028/performance_schema/events_stages_su_116.sdi 2022-05-13T08:28:18.954012+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_statement_119.sdi to /backup/backup8028/performance_schema/events_statement_119.sdi 2022-05-13T08:28:18.954400+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_statement_119.sdi to /backup/backup8028/performance_schema/events_statement_119.sdi 2022-05-13T08:28:18.956891+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_waits_sum_87.sdi to /backup/backup8028/performance_schema/events_waits_sum_87.sdi 2022-05-13T08:28:18.957143+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_waits_sum_87.sdi to /backup/backup8028/performance_schema/events_waits_sum_87.sdi 2022-05-13T08:28:18.959895+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/user_variables_b_176.sdi to /backup/backup8028/performance_schema/user_variables_b_176.sdi 2022-05-13T08:28:18.960269+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/user_variables_b_176.sdi to /backup/backup8028/performance_schema/user_variables_b_176.sdi 2022-05-13T08:28:18.962800+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/persisted_variab_187.sdi to /backup/backup8028/performance_schema/persisted_variab_187.sdi 2022-05-13T08:28:18.963058+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/persisted_variab_187.sdi to /backup/backup8028/performance_schema/persisted_variab_187.sdi 2022-05-13T08:28:18.965470+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/table_io_waits_s_107.sdi to /backup/backup8028/performance_schema/table_io_waits_s_107.sdi 2022-05-13T08:28:18.965876+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/table_io_waits_s_107.sdi to /backup/backup8028/performance_schema/table_io_waits_s_107.sdi 2022-05-13T08:28:18.968736+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/status_by_host_178.sdi to /backup/backup8028/performance_schema/status_by_host_178.sdi 2022-05-13T08:28:18.969021+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/status_by_host_178.sdi to /backup/backup8028/performance_schema/status_by_host_178.sdi 2022-05-13T08:28:18.971431+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/data_locks_160.sdi to /backup/backup8028/performance_schema/data_locks_160.sdi 2022-05-13T08:28:18.971724+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/data_locks_160.sdi to /backup/backup8028/performance_schema/data_locks_160.sdi 2022-05-13T08:28:18.974154+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_transacti_134.sdi to /backup/backup8028/performance_schema/events_transacti_134.sdi 2022-05-13T08:28:18.974479+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_transacti_134.sdi to /backup/backup8028/performance_schema/events_transacti_134.sdi 2022-05-13T08:28:18.977421+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_transacti_136.sdi to /backup/backup8028/performance_schema/events_transacti_136.sdi 2022-05-13T08:28:18.977770+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_transacti_136.sdi to /backup/backup8028/performance_schema/events_transacti_136.sdi 2022-05-13T08:28:18.980395+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_statement_125.sdi to /backup/backup8028/performance_schema/events_statement_125.sdi 2022-05-13T08:28:18.980781+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_statement_125.sdi to /backup/backup8028/performance_schema/events_statement_125.sdi 2022-05-13T08:28:18.983385+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_statement_127.sdi to /backup/backup8028/performance_schema/events_statement_127.sdi 2022-05-13T08:28:18.983973+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_statement_127.sdi to /backup/backup8028/performance_schema/events_statement_127.sdi 2022-05-13T08:28:18.986693+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/socket_summary_b_148.sdi to /backup/backup8028/performance_schema/socket_summary_b_148.sdi 2022-05-13T08:28:18.987061+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/socket_summary_b_148.sdi to /backup/backup8028/performance_schema/socket_summary_b_148.sdi 2022-05-13T08:28:18.989516+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/global_variables_184.sdi to /backup/backup8028/performance_schema/global_variables_184.sdi 2022-05-13T08:28:18.989782+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/global_variables_184.sdi to /backup/backup8028/performance_schema/global_variables_184.sdi 2022-05-13T08:28:18.992501+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/replication_conn_164.sdi to /backup/backup8028/performance_schema/replication_conn_164.sdi 2022-05-13T08:28:18.992968+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/replication_conn_164.sdi to /backup/backup8028/performance_schema/replication_conn_164.sdi 2022-05-13T08:28:18.995665+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_stages_hi_113.sdi to /backup/backup8028/performance_schema/events_stages_hi_113.sdi 2022-05-13T08:28:18.995965+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_stages_hi_113.sdi to /backup/backup8028/performance_schema/events_stages_hi_113.sdi 2022-05-13T08:28:18.998409+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/file_instances_93.sdi to /backup/backup8028/performance_schema/file_instances_93.sdi 2022-05-13T08:28:18.998656+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/file_instances_93.sdi to /backup/backup8028/performance_schema/file_instances_93.sdi 2022-05-13T08:28:19.001444+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/replication_grou_163.sdi to /backup/backup8028/performance_schema/replication_grou_163.sdi 2022-05-13T08:28:19.001804+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/replication_grou_163.sdi to /backup/backup8028/performance_schema/replication_grou_163.sdi 2022-05-13T08:28:19.004407+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/session_variable_185.sdi to /backup/backup8028/performance_schema/session_variable_185.sdi 2022-05-13T08:28:19.004701+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/session_variable_185.sdi to /backup/backup8028/performance_schema/session_variable_185.sdi 2022-05-13T08:28:19.007144+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_waits_sum_89.sdi to /backup/backup8028/performance_schema/events_waits_sum_89.sdi 2022-05-13T08:28:19.007401+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_waits_sum_89.sdi to /backup/backup8028/performance_schema/events_waits_sum_89.sdi 2022-05-13T08:28:19.010556+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_waits_his_86.sdi to /backup/backup8028/performance_schema/events_waits_his_86.sdi 2022-05-13T08:28:19.010944+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_waits_his_86.sdi to /backup/backup8028/performance_schema/events_waits_his_86.sdi 2022-05-13T08:28:19.013474+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/memory_summary_b_156.sdi to /backup/backup8028/performance_schema/memory_summary_b_156.sdi 2022-05-13T08:28:19.013775+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/memory_summary_b_156.sdi to /backup/backup8028/performance_schema/memory_summary_b_156.sdi 2022-05-13T08:28:19.016381+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/memory_summary_b_154.sdi to /backup/backup8028/performance_schema/memory_summary_b_154.sdi 2022-05-13T08:28:19.016878+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/memory_summary_b_154.sdi to /backup/backup8028/performance_schema/memory_summary_b_154.sdi 2022-05-13T08:28:19.019535+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/hosts_146.sdi to /backup/backup8028/performance_schema/hosts_146.sdi 2022-05-13T08:28:19.019831+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/hosts_146.sdi to /backup/backup8028/performance_schema/hosts_146.sdi 2022-05-13T08:28:19.022481+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/replication_appl_167.sdi to /backup/backup8028/performance_schema/replication_appl_167.sdi 2022-05-13T08:28:19.022832+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/replication_appl_167.sdi to /backup/backup8028/performance_schema/replication_appl_167.sdi 2022-05-13T08:28:19.025681+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_waits_his_85.sdi to /backup/backup8028/performance_schema/events_waits_his_85.sdi 2022-05-13T08:28:19.026187+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_waits_his_85.sdi to /backup/backup8028/performance_schema/events_waits_his_85.sdi 2022-05-13T08:28:19.028808+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_stages_su_118.sdi to /backup/backup8028/performance_schema/events_stages_su_118.sdi 2022-05-13T08:28:19.029077+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_stages_su_118.sdi to /backup/backup8028/performance_schema/events_stages_su_118.sdi 2022-05-13T08:28:19.031688+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/keyring_componen_191.sdi to /backup/backup8028/performance_schema/keyring_componen_191.sdi 2022-05-13T08:28:19.031978+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/keyring_componen_191.sdi to /backup/backup8028/performance_schema/keyring_componen_191.sdi 2022-05-13T08:28:19.035102+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_errors_su_139.sdi to /backup/backup8028/performance_schema/events_errors_su_139.sdi 2022-05-13T08:28:19.035420+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_errors_su_139.sdi to /backup/backup8028/performance_schema/events_errors_su_139.sdi 2022-05-13T08:28:19.038195+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/binary_log_trans_189.sdi to /backup/backup8028/performance_schema/binary_log_trans_189.sdi 2022-05-13T08:28:19.038470+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/binary_log_trans_189.sdi to /backup/backup8028/performance_schema/binary_log_trans_189.sdi 2022-05-13T08:28:19.040897+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/setup_instrument_104.sdi to /backup/backup8028/performance_schema/setup_instrument_104.sdi 2022-05-13T08:28:19.041253+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/setup_instrument_104.sdi to /backup/backup8028/performance_schema/setup_instrument_104.sdi 2022-05-13T08:28:19.044018+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/error_log_83.sdi to /backup/backup8028/performance_schema/error_log_83.sdi 2022-05-13T08:28:19.044322+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/error_log_83.sdi to /backup/backup8028/performance_schema/error_log_83.sdi 2022-05-13T08:28:19.046787+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/accounts_145.sdi to /backup/backup8028/performance_schema/accounts_145.sdi 2022-05-13T08:28:19.047032+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/accounts_145.sdi to /backup/backup8028/performance_schema/accounts_145.sdi 2022-05-13T08:28:19.049569+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_transacti_131.sdi to /backup/backup8028/performance_schema/events_transacti_131.sdi 2022-05-13T08:28:19.050076+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_transacti_131.sdi to /backup/backup8028/performance_schema/events_transacti_131.sdi 2022-05-13T08:28:19.053306+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_stages_su_115.sdi to /backup/backup8028/performance_schema/events_stages_su_115.sdi 2022-05-13T08:28:19.053605+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_stages_su_115.sdi to /backup/backup8028/performance_schema/events_stages_su_115.sdi 2022-05-13T08:28:19.056118+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/memory_summary_b_157.sdi to /backup/backup8028/performance_schema/memory_summary_b_157.sdi 2022-05-13T08:28:19.056416+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/memory_summary_b_157.sdi to /backup/backup8028/performance_schema/memory_summary_b_157.sdi 2022-05-13T08:28:19.059060+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/performance_time_99.sdi to /backup/backup8028/performance_schema/performance_time_99.sdi 2022-05-13T08:28:19.059419+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/performance_time_99.sdi to /backup/backup8028/performance_schema/performance_time_99.sdi 2022-05-13T08:28:19.062146+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/host_cache_96.sdi to /backup/backup8028/performance_schema/host_cache_96.sdi 2022-05-13T08:28:19.062486+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/host_cache_96.sdi to /backup/backup8028/performance_schema/host_cache_96.sdi 2022-05-13T08:28:19.064976+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_waits_sum_91.sdi to /backup/backup8028/performance_schema/events_waits_sum_91.sdi 2022-05-13T08:28:19.065295+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_waits_sum_91.sdi to /backup/backup8028/performance_schema/events_waits_sum_91.sdi 2022-05-13T08:28:19.068268+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/objects_summary__98.sdi to /backup/backup8028/performance_schema/objects_summary__98.sdi 2022-05-13T08:28:19.068610+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/objects_summary__98.sdi to /backup/backup8028/performance_schema/objects_summary__98.sdi 2022-05-13T08:28:19.071236+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_stages_hi_112.sdi to /backup/backup8028/performance_schema/events_stages_hi_112.sdi 2022-05-13T08:28:19.071542+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_stages_hi_112.sdi to /backup/backup8028/performance_schema/events_stages_hi_112.sdi 2022-05-13T08:28:19.074011+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/session_connect__150.sdi to /backup/backup8028/performance_schema/session_connect__150.sdi 2022-05-13T08:28:19.074242+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/session_connect__150.sdi to /backup/backup8028/performance_schema/session_connect__150.sdi 2022-05-13T08:28:19.079256+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/setup_objects_105.sdi to /backup/backup8028/performance_schema/setup_objects_105.sdi 2022-05-13T08:28:19.079556+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/setup_objects_105.sdi to /backup/backup8028/performance_schema/setup_objects_105.sdi 2022-05-13T08:28:19.083008+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/mutex_instances_97.sdi to /backup/backup8028/performance_schema/mutex_instances_97.sdi 2022-05-13T08:28:19.085485+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/mutex_instances_97.sdi to /backup/backup8028/performance_schema/mutex_instances_97.sdi 2022-05-13T08:28:19.088880+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_errors_su_142.sdi to /backup/backup8028/performance_schema/events_errors_su_142.sdi 2022-05-13T08:28:19.089234+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_errors_su_142.sdi to /backup/backup8028/performance_schema/events_errors_su_142.sdi 2022-05-13T08:28:19.092394+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/global_status_181.sdi to /backup/backup8028/performance_schema/global_status_181.sdi 2022-05-13T08:28:19.092851+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/global_status_181.sdi to /backup/backup8028/performance_schema/global_status_181.sdi 2022-05-13T08:28:19.096028+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/replication_appl_171.sdi to /backup/backup8028/performance_schema/replication_appl_171.sdi 2022-05-13T08:28:19.096455+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/replication_appl_171.sdi to /backup/backup8028/performance_schema/replication_appl_171.sdi 2022-05-13T08:28:19.099615+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/socket_summary_b_149.sdi to /backup/backup8028/performance_schema/socket_summary_b_149.sdi 2022-05-13T08:28:19.100524+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/socket_summary_b_149.sdi to /backup/backup8028/performance_schema/socket_summary_b_149.sdi 2022-05-13T08:28:19.104162+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/replication_asyn_173.sdi to /backup/backup8028/performance_schema/replication_asyn_173.sdi 2022-05-13T08:28:19.104628+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/replication_asyn_173.sdi to /backup/backup8028/performance_schema/replication_asyn_173.sdi 2022-05-13T08:28:19.108303+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/data_lock_waits_161.sdi to /backup/backup8028/performance_schema/data_lock_waits_161.sdi 2022-05-13T08:28:19.108927+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/data_lock_waits_161.sdi to /backup/backup8028/performance_schema/data_lock_waits_161.sdi 2022-05-13T08:28:19.112162+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/session_account__151.sdi to /backup/backup8028/performance_schema/session_account__151.sdi 2022-05-13T08:28:19.112671+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/session_account__151.sdi to /backup/backup8028/performance_schema/session_account__151.sdi 2022-05-13T08:28:19.115432+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/replication_grou_169.sdi to /backup/backup8028/performance_schema/replication_grou_169.sdi 2022-05-13T08:28:19.115777+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/replication_grou_169.sdi to /backup/backup8028/performance_schema/replication_grou_169.sdi 2022-05-13T08:28:19.119226+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/users_144.sdi to /backup/backup8028/performance_schema/users_144.sdi 2022-05-13T08:28:19.119546+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/users_144.sdi to /backup/backup8028/performance_schema/users_144.sdi 2022-05-13T08:28:19.122172+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_statement_121.sdi to /backup/backup8028/performance_schema/events_statement_121.sdi 2022-05-13T08:28:19.122503+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_statement_121.sdi to /backup/backup8028/performance_schema/events_statement_121.sdi 2022-05-13T08:28:19.125142+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_transacti_135.sdi to /backup/backup8028/performance_schema/events_transacti_135.sdi 2022-05-13T08:28:19.125610+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_transacti_135.sdi to /backup/backup8028/performance_schema/events_transacti_135.sdi 2022-05-13T08:28:19.128512+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_statement_120.sdi to /backup/backup8028/performance_schema/events_statement_120.sdi 2022-05-13T08:28:19.128917+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_statement_120.sdi to /backup/backup8028/performance_schema/events_statement_120.sdi 2022-05-13T08:28:19.131462+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/table_handles_158.sdi to /backup/backup8028/performance_schema/table_handles_158.sdi 2022-05-13T08:28:19.131742+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/table_handles_158.sdi to /backup/backup8028/performance_schema/table_handles_158.sdi 2022-05-13T08:28:19.134941+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_statement_130.sdi to /backup/backup8028/performance_schema/events_statement_130.sdi 2022-05-13T08:28:19.135283+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_statement_130.sdi to /backup/backup8028/performance_schema/events_statement_130.sdi 2022-05-13T08:28:19.137880+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/user_defined_fun_188.sdi to /backup/backup8028/performance_schema/user_defined_fun_188.sdi 2022-05-13T08:28:19.138175+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/user_defined_fun_188.sdi to /backup/backup8028/performance_schema/user_defined_fun_188.sdi 2022-05-13T08:28:19.140625+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_stages_su_114.sdi to /backup/backup8028/performance_schema/events_stages_su_114.sdi 2022-05-13T08:28:19.140890+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_stages_su_114.sdi to /backup/backup8028/performance_schema/events_stages_su_114.sdi 2022-05-13T08:28:19.145908+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/log_status_174.sdi to /backup/backup8028/performance_schema/log_status_174.sdi 2022-05-13T08:28:19.146288+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/log_status_174.sdi to /backup/backup8028/performance_schema/log_status_174.sdi 2022-05-13T08:28:19.148973+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_statement_126.sdi to /backup/backup8028/performance_schema/events_statement_126.sdi 2022-05-13T08:28:19.149358+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_statement_126.sdi to /backup/backup8028/performance_schema/events_statement_126.sdi 2022-05-13T08:28:19.152596+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/session_status_182.sdi to /backup/backup8028/performance_schema/session_status_182.sdi 2022-05-13T08:28:19.152878+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/session_status_182.sdi to /backup/backup8028/performance_schema/session_status_182.sdi 2022-05-13T08:28:19.155777+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_stages_cu_111.sdi to /backup/backup8028/performance_schema/events_stages_cu_111.sdi 2022-05-13T08:28:19.156147+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_stages_cu_111.sdi to /backup/backup8028/performance_schema/events_stages_cu_111.sdi 2022-05-13T08:28:19.159115+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_errors_su_140.sdi to /backup/backup8028/performance_schema/events_errors_su_140.sdi 2022-05-13T08:28:19.159477+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_errors_su_140.sdi to /backup/backup8028/performance_schema/events_errors_su_140.sdi 2022-05-13T08:28:19.162184+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_transacti_132.sdi to /backup/backup8028/performance_schema/events_transacti_132.sdi 2022-05-13T08:28:19.162559+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_transacti_132.sdi to /backup/backup8028/performance_schema/events_transacti_132.sdi 2022-05-13T08:28:19.165060+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_statement_122.sdi to /backup/backup8028/performance_schema/events_statement_122.sdi 2022-05-13T08:28:19.165444+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_statement_122.sdi to /backup/backup8028/performance_schema/events_statement_122.sdi 2022-05-13T08:28:19.168605+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/replication_appl_168.sdi to /backup/backup8028/performance_schema/replication_appl_168.sdi 2022-05-13T08:28:19.169169+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/replication_appl_168.sdi to /backup/backup8028/performance_schema/replication_appl_168.sdi 2022-05-13T08:28:19.171658+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_transacti_138.sdi to /backup/backup8028/performance_schema/events_transacti_138.sdi 2022-05-13T08:28:19.172026+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_transacti_138.sdi to /backup/backup8028/performance_schema/events_transacti_138.sdi 2022-05-13T08:28:19.174733+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/tls_channel_stat_190.sdi to /backup/backup8028/performance_schema/tls_channel_stat_190.sdi 2022-05-13T08:28:19.175217+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/tls_channel_stat_190.sdi to /backup/backup8028/performance_schema/tls_channel_stat_190.sdi 2022-05-13T08:28:19.178012+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/setup_threads_106.sdi to /backup/backup8028/performance_schema/setup_threads_106.sdi 2022-05-13T08:28:19.178337+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/setup_threads_106.sdi to /backup/backup8028/performance_schema/setup_threads_106.sdi 2022-05-13T08:28:19.180855+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_statement_123.sdi to /backup/backup8028/performance_schema/events_statement_123.sdi 2022-05-13T08:28:19.181244+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_statement_123.sdi to /backup/backup8028/performance_schema/events_statement_123.sdi 2022-05-13T08:28:19.183902+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_statement_124.sdi to /backup/backup8028/performance_schema/events_statement_124.sdi 2022-05-13T08:28:19.184373+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_statement_124.sdi to /backup/backup8028/performance_schema/events_statement_124.sdi 2022-05-13T08:28:19.186943+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_transacti_133.sdi to /backup/backup8028/performance_schema/events_transacti_133.sdi 2022-05-13T08:28:19.187279+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_transacti_133.sdi to /backup/backup8028/performance_schema/events_transacti_133.sdi 2022-05-13T08:28:19.189945+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/replication_appl_170.sdi to /backup/backup8028/performance_schema/replication_appl_170.sdi 2022-05-13T08:28:19.190213+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/replication_appl_170.sdi to /backup/backup8028/performance_schema/replication_appl_170.sdi 2022-05-13T08:28:19.193128+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/variables_info_186.sdi to /backup/backup8028/performance_schema/variables_info_186.sdi 2022-05-13T08:28:19.193534+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/variables_info_186.sdi to /backup/backup8028/performance_schema/variables_info_186.sdi 2022-05-13T08:28:19.196379+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/file_summary_by__94.sdi to /backup/backup8028/performance_schema/file_summary_by__94.sdi 2022-05-13T08:28:19.196765+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/file_summary_by__94.sdi to /backup/backup8028/performance_schema/file_summary_by__94.sdi 2022-05-13T08:28:19.199721+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/socket_instances_147.sdi to /backup/backup8028/performance_schema/socket_instances_147.sdi 2022-05-13T08:28:19.200753+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/socket_instances_147.sdi to /backup/backup8028/performance_schema/socket_instances_147.sdi 2022-05-13T08:28:19.203541+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/status_by_user_180.sdi to /backup/backup8028/performance_schema/status_by_user_180.sdi 2022-05-13T08:28:19.203884+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/status_by_user_180.sdi to /backup/backup8028/performance_schema/status_by_user_180.sdi 2022-05-13T08:28:19.206642+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/table_lock_waits_109.sdi to /backup/backup8028/performance_schema/table_lock_waits_109.sdi 2022-05-13T08:28:19.207061+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/table_lock_waits_109.sdi to /backup/backup8028/performance_schema/table_lock_waits_109.sdi 2022-05-13T08:28:19.210253+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/status_by_thread_179.sdi to /backup/backup8028/performance_schema/status_by_thread_179.sdi 2022-05-13T08:28:19.210557+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/status_by_thread_179.sdi to /backup/backup8028/performance_schema/status_by_thread_179.sdi 2022-05-13T08:28:19.213172+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/replication_conn_162.sdi to /backup/backup8028/performance_schema/replication_conn_162.sdi 2022-05-13T08:28:19.213547+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/replication_conn_162.sdi to /backup/backup8028/performance_schema/replication_conn_162.sdi 2022-05-13T08:28:19.216214+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/replication_appl_166.sdi to /backup/backup8028/performance_schema/replication_appl_166.sdi 2022-05-13T08:28:19.216655+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/replication_appl_166.sdi to /backup/backup8028/performance_schema/replication_appl_166.sdi 2022-05-13T08:28:19.219501+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_waits_sum_90.sdi to /backup/backup8028/performance_schema/events_waits_sum_90.sdi 2022-05-13T08:28:19.219817+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_waits_sum_90.sdi to /backup/backup8028/performance_schema/events_waits_sum_90.sdi 2022-05-13T08:28:19.222325+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_statement_129.sdi to /backup/backup8028/performance_schema/events_statement_129.sdi 2022-05-13T08:28:19.222590+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_statement_129.sdi to /backup/backup8028/performance_schema/events_statement_129.sdi 2022-05-13T08:28:19.225232+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/memory_summary_g_153.sdi to /backup/backup8028/performance_schema/memory_summary_g_153.sdi 2022-05-13T08:28:19.225681+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/memory_summary_g_153.sdi to /backup/backup8028/performance_schema/memory_summary_g_153.sdi 2022-05-13T08:28:19.228546+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying mysql/slow_log.CSM to /backup/backup8028/mysql/slow_log.CSM 2022-05-13T08:28:19.228860+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying mysql/slow_log.CSM to /backup/backup8028/mysql/slow_log.CSM 2022-05-13T08:28:19.231314+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying mysql/general_log_213.sdi to /backup/backup8028/mysql/general_log_213.sdi 2022-05-13T08:28:19.231604+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying mysql/general_log_213.sdi to /backup/backup8028/mysql/general_log_213.sdi 2022-05-13T08:28:19.234634+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying mysql/general_log.CSV to /backup/backup8028/mysql/general_log.CSV 2022-05-13T08:28:19.234690+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying mysql/general_log.CSV to /backup/backup8028/mysql/general_log.CSV 2022-05-13T08:28:19.237515+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying mysql/slow_log_214.sdi to /backup/backup8028/mysql/slow_log_214.sdi 2022-05-13T08:28:19.237802+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying mysql/slow_log_214.sdi to /backup/backup8028/mysql/slow_log_214.sdi 2022-05-13T08:28:19.240218+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying mysql/general_log.CSM to /backup/backup8028/mysql/general_log.CSM 2022-05-13T08:28:19.240479+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying mysql/general_log.CSM to /backup/backup8028/mysql/general_log.CSM 2022-05-13T08:28:19.243340+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying mysql/slow_log.CSV to /backup/backup8028/mysql/slow_log.CSV 2022-05-13T08:28:19.243394+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying mysql/slow_log.CSV to /backup/backup8028/mysql/slow_log.CSV 2022-05-13T08:28:19.245893+09:00 3 [Note] [MY-011825] [Xtrabackup] Writing /backup/backup8028/test/db.opt 2022-05-13T08:28:19.245931+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Writing file /backup/backup8028/test/db.opt 2022-05-13T08:28:19.276050+09:00 0 [Note] [MY-011825] [Xtrabackup] Finished backing up non-InnoDB tables and files 2022-05-13T08:28:19.276092+09:00 0 [Note] [MY-011825] [Xtrabackup] Executing FLUSH NO_WRITE_TO_BINLOG BINARY LOGS 2022-05-13T08:28:19.289631+09:00 0 [Note] [MY-011825] [Xtrabackup] Selecting LSN and binary log position from p_s.log_status 2022-05-13T08:28:19.291373+09:00 0 [Note] [MY-011825] [Xtrabackup] Copying /var/lib/mysql/binlog.000004 to /backup/backup8028/binlog.000004 up to position 157 2022-05-13T08:28:19.291510+09:00 0 [Note] [MY-011825] [Xtrabackup] Done: Copying /var/lib/mysql/binlog.000004 to /backup/backup8028/binlog.000004 2022-05-13T08:28:19.295169+09:00 0 [Note] [MY-011825] [Xtrabackup] Writing /backup/backup8028/binlog.index 2022-05-13T08:28:19.295252+09:00 0 [Note] [MY-011825] [Xtrabackup] Done: Writing file /backup/backup8028/binlog.index 2022-05-13T08:28:19.299074+09:00 0 [Note] [MY-011825] [Xtrabackup] Writing /backup/backup8028/xtrabackup_binlog_info 2022-05-13T08:28:19.299174+09:00 0 [Note] [MY-011825] [Xtrabackup] Done: Writing file /backup/backup8028/xtrabackup_binlog_info 2022-05-13T08:28:19.302109+09:00 0 [Note] [MY-011825] [Xtrabackup] Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS... 2022-05-13T08:28:19.306080+09:00 0 [Note] [MY-011825] [Xtrabackup] The latest check point (for incremental): '28623905' 2022-05-13T08:28:19.306121+09:00 0 [Note] [MY-011825] [Xtrabackup] Stopping log copying thread at LSN 28623905 2022-05-13T08:28:19.306198+09:00 1 [Note] [MY-011825] [Xtrabackup] Starting to parse redo log at lsn = 28623885 2022-05-13T08:28:19.312070+09:00 0 [Note] [MY-011825] [Xtrabackup] Executing UNLOCK INSTANCE 2022-05-13T08:28:19.312264+09:00 0 [Note] [MY-011825] [Xtrabackup] All tables unlocked 2022-05-13T08:28:19.312369+09:00 0 [Note] [MY-011825] [Xtrabackup] Copying ib_buffer_pool to /backup/backup8028/ib_buffer_pool 2022-05-13T08:28:19.312674+09:00 0 [Note] [MY-011825] [Xtrabackup] Done: Copying ib_buffer_pool to /backup/backup8028/ib_buffer_pool 2022-05-13T08:28:19.315177+09:00 0 [Note] [MY-011825] [Xtrabackup] Backup created in directory '/backup/backup8028/' 2022-05-13T08:28:19.315209+09:00 0 [Note] [MY-011825] [Xtrabackup] MySQL binlog position: filename 'binlog.000004', position '157' 2022-05-13T08:28:19.315303+09:00 0 [Note] [MY-011825] [Xtrabackup] Writing /backup/backup8028/backup-my.cnf 2022-05-13T08:28:19.315357+09:00 0 [Note] [MY-011825] [Xtrabackup] Done: Writing file /backup/backup8028/backup-my.cnf 2022-05-13T08:28:19.318513+09:00 0 [Note] [MY-011825] [Xtrabackup] Writing /backup/backup8028/xtrabackup_info 2022-05-13T08:28:19.318587+09:00 0 [Note] [MY-011825] [Xtrabackup] Done: Writing file /backup/backup8028/xtrabackup_info 2022-05-13T08:28:20.323689+09:00 0 [Note] [MY-011825] [Xtrabackup] Transaction log of lsn (28623905) to (28623915) was copied. 2022-05-13T08:28:20.530776+09:00 0 [Note] [MY-011825] [Xtrabackup] completed OK! root@dfa20732334c:~#
MySQL 8.0.27
成功。
root@462c93c9e1f6:/# xtrabackup --backup --target-dir=/backup/backup8028 --user=root --password=root 2022-05-15T19:34:45.859805+09:00 0 [Note] [MY-011825] [Xtrabackup] recognized server arguments: --datadir=/var/lib/mysql 2022-05-15T19:34:45.863834+09:00 0 [Note] [MY-011825] [Xtrabackup] recognized client arguments: --backup=1 --target-dir=/backup/backup8028 --user=root --password=* xtrabackup version 8.0.28-20 based on MySQL server 8.0.28 Linux (x86_64) (revision id: 4cc3081873d) 220515 19:34:45 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'root' (using password: YES). 220515 19:34:45 version_check Connected to MySQL server 220515 19:34:45 version_check Executing a version check against the server... 220515 19:34:45 version_check Done. 2022-05-15T19:34:46.004501+09:00 0 [Note] [MY-011825] [Xtrabackup] Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: not set 2022-05-15T19:34:46.031336+09:00 0 [Note] [MY-011825] [Xtrabackup] Using server version 8.0.27 2022-05-15T19:34:46.040792+09:00 0 [Note] [MY-011825] [Xtrabackup] Executing LOCK INSTANCE FOR BACKUP ... 2022-05-15T19:34:46.043766+09:00 0 [Note] [MY-011825] [Xtrabackup] uses posix_fadvise(). 2022-05-15T19:34:46.044027+09:00 0 [Note] [MY-011825] [Xtrabackup] cd to /var/lib/mysql 2022-05-15T19:34:46.044068+09:00 0 [Note] [MY-011825] [Xtrabackup] open files limit requested 0, set to 1048576 2022-05-15T19:34:46.044516+09:00 0 [Note] [MY-011825] [Xtrabackup] using the following InnoDB configuration: 2022-05-15T19:34:46.044569+09:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_home_dir = . 2022-05-15T19:34:46.044602+09:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_file_path = ibdata1:12M:autoextend 2022-05-15T19:34:46.046188+09:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_group_home_dir = ./ 2022-05-15T19:34:46.046243+09:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_files_in_group = 2 2022-05-15T19:34:46.046286+09:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_file_size = 50331648 2022-05-15T19:34:46.048966+09:00 0 [Note] [MY-013251] [InnoDB] Number of pools: 1 2022-05-15T19:34:46.052016+09:00 0 [Note] [MY-011825] [Xtrabackup] inititialize_service_handles suceeded 2022-05-15T19:34:46.134532+09:00 0 [Note] [MY-011825] [Xtrabackup] Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: not set 2022-05-15T19:34:46.137937+09:00 0 [Note] [MY-011825] [Xtrabackup] Redo Log Archiving is not set up. 2022-05-15T19:34:46.241460+09:00 1 [Note] [MY-011825] [Xtrabackup] >> log scanned up to (28620551) 2022-05-15T19:34:46.442481+09:00 0 [Note] [MY-011825] [Xtrabackup] Generating a list of tablespaces 2022-05-15T19:34:46.442876+09:00 0 [Note] [MY-011825] [Xtrabackup] Generating a list of tablespaces 2022-05-15T19:34:46.442916+09:00 0 [Note] [MY-012204] [InnoDB] Scanning './' 2022-05-15T19:34:46.444578+09:00 0 [Note] [MY-012208] [InnoDB] Completed space ID check of 2 files. 2022-05-15T19:34:46.445986+09:00 0 [Warning] [MY-012091] [InnoDB] Allocated tablespace ID 1 for sys/sys_config, old maximum was 0 2022-05-15T19:34:46.446354+09:00 0 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_001'. 2022-05-15T19:34:46.447121+09:00 0 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_002'. 2022-05-15T19:34:46.448053+09:00 0 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces. 2022-05-15T19:34:46.448494+09:00 2 [Note] [MY-011825] [Xtrabackup] Copying ./ibdata1 to /backup/backup8028/ibdata1 2022-05-15T19:34:46.477171+09:00 2 [Note] [MY-011825] [Xtrabackup] Done: Copying ./ibdata1 to /backup/backup8028/ibdata1 2022-05-15T19:34:46.482291+09:00 2 [Note] [MY-011825] [Xtrabackup] Copying ./sys/sys_config.ibd to /backup/backup8028/sys/sys_config.ibd 2022-05-15T19:34:46.482488+09:00 2 [Note] [MY-011825] [Xtrabackup] Done: Copying ./sys/sys_config.ibd to /backup/backup8028/sys/sys_config.ibd 2022-05-15T19:34:46.485237+09:00 2 [Note] [MY-011825] [Xtrabackup] Copying ./mysql.ibd to /backup/backup8028/mysql.ibd 2022-05-15T19:34:46.561855+09:00 2 [Note] [MY-011825] [Xtrabackup] Done: Copying ./mysql.ibd to /backup/backup8028/mysql.ibd 2022-05-15T19:34:46.571791+09:00 2 [Note] [MY-011825] [Xtrabackup] Copying ./undo_002 to /backup/backup8028/undo_002 2022-05-15T19:34:46.609009+09:00 2 [Note] [MY-011825] [Xtrabackup] Done: Copying ./undo_002 to /backup/backup8028/undo_002 2022-05-15T19:34:46.613669+09:00 2 [Note] [MY-011825] [Xtrabackup] Copying ./undo_001 to /backup/backup8028/undo_001 2022-05-15T19:34:46.649276+09:00 2 [Note] [MY-011825] [Xtrabackup] Done: Copying ./undo_001 to /backup/backup8028/undo_001 2022-05-15T19:34:47.241751+09:00 1 [Note] [MY-011825] [Xtrabackup] >> log scanned up to (28620551) 2022-05-15T19:34:47.449364+09:00 0 [Note] [MY-011825] [Xtrabackup] Starting to backup non-InnoDB tables and files 2022-05-15T19:34:47.449791+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/rwlock_instances_101.sdi to /backup/backup8028/performance_schema/rwlock_instances_101.sdi 2022-05-15T19:34:47.450285+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/rwlock_instances_101.sdi to /backup/backup8028/performance_schema/rwlock_instances_101.sdi 2022-05-15T19:34:47.453584+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/variables_by_thr_183.sdi to /backup/backup8028/performance_schema/variables_by_thr_183.sdi 2022-05-15T19:34:47.453886+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/variables_by_thr_183.sdi to /backup/backup8028/performance_schema/variables_by_thr_183.sdi 2022-05-15T19:34:47.456763+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/keyring_keys_152.sdi to /backup/backup8028/performance_schema/keyring_keys_152.sdi 2022-05-15T19:34:47.457087+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/keyring_keys_152.sdi to /backup/backup8028/performance_schema/keyring_keys_152.sdi 2022-05-15T19:34:47.459627+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/setup_actors_102.sdi to /backup/backup8028/performance_schema/setup_actors_102.sdi 2022-05-15T19:34:47.459883+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/setup_actors_102.sdi to /backup/backup8028/performance_schema/setup_actors_102.sdi 2022-05-15T19:34:47.462485+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/prepared_stateme_175.sdi to /backup/backup8028/performance_schema/prepared_stateme_175.sdi 2022-05-15T19:34:47.462828+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/prepared_stateme_175.sdi to /backup/backup8028/performance_schema/prepared_stateme_175.sdi 2022-05-15T19:34:47.466912+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/table_io_waits_s_108.sdi to /backup/backup8028/performance_schema/table_io_waits_s_108.sdi 2022-05-15T19:34:47.467254+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/table_io_waits_s_108.sdi to /backup/backup8028/performance_schema/table_io_waits_s_108.sdi 2022-05-15T19:34:47.469945+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/setup_consumers_103.sdi to /backup/backup8028/performance_schema/setup_consumers_103.sdi 2022-05-15T19:34:47.470246+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/setup_consumers_103.sdi to /backup/backup8028/performance_schema/setup_consumers_103.sdi 2022-05-15T19:34:47.472865+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_errors_su_143.sdi to /backup/backup8028/performance_schema/events_errors_su_143.sdi 2022-05-15T19:34:47.473165+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_errors_su_143.sdi to /backup/backup8028/performance_schema/events_errors_su_143.sdi 2022-05-15T19:34:47.475427+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/threads_110.sdi to /backup/backup8028/performance_schema/threads_110.sdi 2022-05-15T19:34:47.475806+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/threads_110.sdi to /backup/backup8028/performance_schema/threads_110.sdi 2022-05-15T19:34:47.478674+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_statement_128.sdi to /backup/backup8028/performance_schema/events_statement_128.sdi 2022-05-15T19:34:47.479148+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_statement_128.sdi to /backup/backup8028/performance_schema/events_statement_128.sdi 2022-05-15T19:34:47.481841+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_waits_sum_88.sdi to /backup/backup8028/performance_schema/events_waits_sum_88.sdi 2022-05-15T19:34:47.482102+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_waits_sum_88.sdi to /backup/backup8028/performance_schema/events_waits_sum_88.sdi 2022-05-15T19:34:47.484558+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/file_summary_by__95.sdi to /backup/backup8028/performance_schema/file_summary_by__95.sdi 2022-05-15T19:34:47.484948+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/file_summary_by__95.sdi to /backup/backup8028/performance_schema/file_summary_by__95.sdi 2022-05-15T19:34:47.487579+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/metadata_locks_159.sdi to /backup/backup8028/performance_schema/metadata_locks_159.sdi 2022-05-15T19:34:47.487952+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/metadata_locks_159.sdi to /backup/backup8028/performance_schema/metadata_locks_159.sdi 2022-05-15T19:34:47.490694+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_errors_su_141.sdi to /backup/backup8028/performance_schema/events_errors_su_141.sdi 2022-05-15T19:34:47.491032+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_errors_su_141.sdi to /backup/backup8028/performance_schema/events_errors_su_141.sdi 2022-05-15T19:34:47.493542+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_waits_sum_92.sdi to /backup/backup8028/performance_schema/events_waits_sum_92.sdi 2022-05-15T19:34:47.493786+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_waits_sum_92.sdi to /backup/backup8028/performance_schema/events_waits_sum_92.sdi 2022-05-15T19:34:47.496464+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/processlist_100.sdi to /backup/backup8028/performance_schema/processlist_100.sdi 2022-05-15T19:34:47.496895+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/processlist_100.sdi to /backup/backup8028/performance_schema/processlist_100.sdi 2022-05-15T19:34:47.499483+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_waits_cur_84.sdi to /backup/backup8028/performance_schema/events_waits_cur_84.sdi 2022-05-15T19:34:47.499783+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_waits_cur_84.sdi to /backup/backup8028/performance_schema/events_waits_cur_84.sdi 2022-05-15T19:34:47.502298+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/replication_asyn_172.sdi to /backup/backup8028/performance_schema/replication_asyn_172.sdi 2022-05-15T19:34:47.502580+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/replication_asyn_172.sdi to /backup/backup8028/performance_schema/replication_asyn_172.sdi 2022-05-15T19:34:47.505617+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/replication_appl_165.sdi to /backup/backup8028/performance_schema/replication_appl_165.sdi 2022-05-15T19:34:47.505954+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/replication_appl_165.sdi to /backup/backup8028/performance_schema/replication_appl_165.sdi 2022-05-15T19:34:47.508654+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_transacti_137.sdi to /backup/backup8028/performance_schema/events_transacti_137.sdi 2022-05-15T19:34:47.508978+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_transacti_137.sdi to /backup/backup8028/performance_schema/events_transacti_137.sdi 2022-05-15T19:34:47.511720+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/cond_instances_82.sdi to /backup/backup8028/performance_schema/cond_instances_82.sdi 2022-05-15T19:34:47.512145+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/cond_instances_82.sdi to /backup/backup8028/performance_schema/cond_instances_82.sdi 2022-05-15T19:34:47.514975+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_stages_su_117.sdi to /backup/backup8028/performance_schema/events_stages_su_117.sdi 2022-05-15T19:34:47.515259+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_stages_su_117.sdi to /backup/backup8028/performance_schema/events_stages_su_117.sdi 2022-05-15T19:34:47.517939+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/status_by_accoun_177.sdi to /backup/backup8028/performance_schema/status_by_accoun_177.sdi 2022-05-15T19:34:47.518194+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/status_by_accoun_177.sdi to /backup/backup8028/performance_schema/status_by_accoun_177.sdi 2022-05-15T19:34:47.520901+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/memory_summary_b_155.sdi to /backup/backup8028/performance_schema/memory_summary_b_155.sdi 2022-05-15T19:34:47.521297+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/memory_summary_b_155.sdi to /backup/backup8028/performance_schema/memory_summary_b_155.sdi 2022-05-15T19:34:47.523863+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_stages_su_116.sdi to /backup/backup8028/performance_schema/events_stages_su_116.sdi 2022-05-15T19:34:47.524128+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_stages_su_116.sdi to /backup/backup8028/performance_schema/events_stages_su_116.sdi 2022-05-15T19:34:47.526817+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_statement_119.sdi to /backup/backup8028/performance_schema/events_statement_119.sdi 2022-05-15T19:34:47.527179+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_statement_119.sdi to /backup/backup8028/performance_schema/events_statement_119.sdi 2022-05-15T19:34:47.530135+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_waits_sum_87.sdi to /backup/backup8028/performance_schema/events_waits_sum_87.sdi 2022-05-15T19:34:47.530439+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_waits_sum_87.sdi to /backup/backup8028/performance_schema/events_waits_sum_87.sdi 2022-05-15T19:34:47.532943+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/user_variables_b_176.sdi to /backup/backup8028/performance_schema/user_variables_b_176.sdi 2022-05-15T19:34:47.533213+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/user_variables_b_176.sdi to /backup/backup8028/performance_schema/user_variables_b_176.sdi 2022-05-15T19:34:47.535596+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/persisted_variab_187.sdi to /backup/backup8028/performance_schema/persisted_variab_187.sdi 2022-05-15T19:34:47.535838+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/persisted_variab_187.sdi to /backup/backup8028/performance_schema/persisted_variab_187.sdi 2022-05-15T19:34:47.538602+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/table_io_waits_s_107.sdi to /backup/backup8028/performance_schema/table_io_waits_s_107.sdi 2022-05-15T19:34:47.539010+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/table_io_waits_s_107.sdi to /backup/backup8028/performance_schema/table_io_waits_s_107.sdi 2022-05-15T19:34:47.541662+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/status_by_host_178.sdi to /backup/backup8028/performance_schema/status_by_host_178.sdi 2022-05-15T19:34:47.541906+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/status_by_host_178.sdi to /backup/backup8028/performance_schema/status_by_host_178.sdi 2022-05-15T19:34:47.544654+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/data_locks_160.sdi to /backup/backup8028/performance_schema/data_locks_160.sdi 2022-05-15T19:34:47.545438+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/data_locks_160.sdi to /backup/backup8028/performance_schema/data_locks_160.sdi 2022-05-15T19:34:47.548255+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_transacti_134.sdi to /backup/backup8028/performance_schema/events_transacti_134.sdi 2022-05-15T19:34:47.548586+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_transacti_134.sdi to /backup/backup8028/performance_schema/events_transacti_134.sdi 2022-05-15T19:34:47.551268+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_transacti_136.sdi to /backup/backup8028/performance_schema/events_transacti_136.sdi 2022-05-15T19:34:47.551565+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_transacti_136.sdi to /backup/backup8028/performance_schema/events_transacti_136.sdi 2022-05-15T19:34:47.554238+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_statement_125.sdi to /backup/backup8028/performance_schema/events_statement_125.sdi 2022-05-15T19:34:47.554627+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_statement_125.sdi to /backup/backup8028/performance_schema/events_statement_125.sdi 2022-05-15T19:34:47.557344+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_statement_127.sdi to /backup/backup8028/performance_schema/events_statement_127.sdi 2022-05-15T19:34:47.557764+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_statement_127.sdi to /backup/backup8028/performance_schema/events_statement_127.sdi 2022-05-15T19:34:47.560377+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/socket_summary_b_148.sdi to /backup/backup8028/performance_schema/socket_summary_b_148.sdi 2022-05-15T19:34:47.560713+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/socket_summary_b_148.sdi to /backup/backup8028/performance_schema/socket_summary_b_148.sdi 2022-05-15T19:34:47.563479+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/global_variables_184.sdi to /backup/backup8028/performance_schema/global_variables_184.sdi 2022-05-15T19:34:47.563810+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/global_variables_184.sdi to /backup/backup8028/performance_schema/global_variables_184.sdi 2022-05-15T19:34:47.566369+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/replication_conn_164.sdi to /backup/backup8028/performance_schema/replication_conn_164.sdi 2022-05-15T19:34:47.566752+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/replication_conn_164.sdi to /backup/backup8028/performance_schema/replication_conn_164.sdi 2022-05-15T19:34:47.569468+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_stages_hi_113.sdi to /backup/backup8028/performance_schema/events_stages_hi_113.sdi 2022-05-15T19:34:47.569902+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_stages_hi_113.sdi to /backup/backup8028/performance_schema/events_stages_hi_113.sdi 2022-05-15T19:34:47.572726+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/file_instances_93.sdi to /backup/backup8028/performance_schema/file_instances_93.sdi 2022-05-15T19:34:47.573066+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/file_instances_93.sdi to /backup/backup8028/performance_schema/file_instances_93.sdi 2022-05-15T19:34:47.575574+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/replication_grou_163.sdi to /backup/backup8028/performance_schema/replication_grou_163.sdi 2022-05-15T19:34:47.575870+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/replication_grou_163.sdi to /backup/backup8028/performance_schema/replication_grou_163.sdi 2022-05-15T19:34:47.578483+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/session_variable_185.sdi to /backup/backup8028/performance_schema/session_variable_185.sdi 2022-05-15T19:34:47.578893+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/session_variable_185.sdi to /backup/backup8028/performance_schema/session_variable_185.sdi 2022-05-15T19:34:47.581646+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_waits_sum_89.sdi to /backup/backup8028/performance_schema/events_waits_sum_89.sdi 2022-05-15T19:34:47.581938+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_waits_sum_89.sdi to /backup/backup8028/performance_schema/events_waits_sum_89.sdi 2022-05-15T19:34:47.584422+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_waits_his_86.sdi to /backup/backup8028/performance_schema/events_waits_his_86.sdi 2022-05-15T19:34:47.584785+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_waits_his_86.sdi to /backup/backup8028/performance_schema/events_waits_his_86.sdi 2022-05-15T19:34:47.587486+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/memory_summary_b_156.sdi to /backup/backup8028/performance_schema/memory_summary_b_156.sdi 2022-05-15T19:34:47.587977+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/memory_summary_b_156.sdi to /backup/backup8028/performance_schema/memory_summary_b_156.sdi 2022-05-15T19:34:47.590569+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/memory_summary_b_154.sdi to /backup/backup8028/performance_schema/memory_summary_b_154.sdi 2022-05-15T19:34:47.590891+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/memory_summary_b_154.sdi to /backup/backup8028/performance_schema/memory_summary_b_154.sdi 2022-05-15T19:34:47.593390+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/hosts_146.sdi to /backup/backup8028/performance_schema/hosts_146.sdi 2022-05-15T19:34:47.593633+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/hosts_146.sdi to /backup/backup8028/performance_schema/hosts_146.sdi 2022-05-15T19:34:47.596480+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/replication_appl_167.sdi to /backup/backup8028/performance_schema/replication_appl_167.sdi 2022-05-15T19:34:47.596921+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/replication_appl_167.sdi to /backup/backup8028/performance_schema/replication_appl_167.sdi 2022-05-15T19:34:47.599422+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_waits_his_85.sdi to /backup/backup8028/performance_schema/events_waits_his_85.sdi 2022-05-15T19:34:47.599788+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_waits_his_85.sdi to /backup/backup8028/performance_schema/events_waits_his_85.sdi 2022-05-15T19:34:47.602277+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_stages_su_118.sdi to /backup/backup8028/performance_schema/events_stages_su_118.sdi 2022-05-15T19:34:47.602594+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_stages_su_118.sdi to /backup/backup8028/performance_schema/events_stages_su_118.sdi 2022-05-15T19:34:47.605530+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/keyring_componen_191.sdi to /backup/backup8028/performance_schema/keyring_componen_191.sdi 2022-05-15T19:34:47.605821+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/keyring_componen_191.sdi to /backup/backup8028/performance_schema/keyring_componen_191.sdi 2022-05-15T19:34:47.608358+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_errors_su_139.sdi to /backup/backup8028/performance_schema/events_errors_su_139.sdi 2022-05-15T19:34:47.608804+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_errors_su_139.sdi to /backup/backup8028/performance_schema/events_errors_su_139.sdi 2022-05-15T19:34:47.612041+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/binary_log_trans_189.sdi to /backup/backup8028/performance_schema/binary_log_trans_189.sdi 2022-05-15T19:34:47.612443+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/binary_log_trans_189.sdi to /backup/backup8028/performance_schema/binary_log_trans_189.sdi 2022-05-15T19:34:47.615256+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/setup_instrument_104.sdi to /backup/backup8028/performance_schema/setup_instrument_104.sdi 2022-05-15T19:34:47.615562+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/setup_instrument_104.sdi to /backup/backup8028/performance_schema/setup_instrument_104.sdi 2022-05-15T19:34:47.618202+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/error_log_83.sdi to /backup/backup8028/performance_schema/error_log_83.sdi 2022-05-15T19:34:47.618511+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/error_log_83.sdi to /backup/backup8028/performance_schema/error_log_83.sdi 2022-05-15T19:34:47.621169+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/accounts_145.sdi to /backup/backup8028/performance_schema/accounts_145.sdi 2022-05-15T19:34:47.621494+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/accounts_145.sdi to /backup/backup8028/performance_schema/accounts_145.sdi 2022-05-15T19:34:47.624080+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_transacti_131.sdi to /backup/backup8028/performance_schema/events_transacti_131.sdi 2022-05-15T19:34:47.624374+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_transacti_131.sdi to /backup/backup8028/performance_schema/events_transacti_131.sdi 2022-05-15T19:34:47.626877+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_stages_su_115.sdi to /backup/backup8028/performance_schema/events_stages_su_115.sdi 2022-05-15T19:34:47.627158+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_stages_su_115.sdi to /backup/backup8028/performance_schema/events_stages_su_115.sdi 2022-05-15T19:34:47.629819+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/memory_summary_b_157.sdi to /backup/backup8028/performance_schema/memory_summary_b_157.sdi 2022-05-15T19:34:47.630154+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/memory_summary_b_157.sdi to /backup/backup8028/performance_schema/memory_summary_b_157.sdi 2022-05-15T19:34:47.632668+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/performance_time_99.sdi to /backup/backup8028/performance_schema/performance_time_99.sdi 2022-05-15T19:34:47.633025+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/performance_time_99.sdi to /backup/backup8028/performance_schema/performance_time_99.sdi 2022-05-15T19:34:47.635574+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/host_cache_96.sdi to /backup/backup8028/performance_schema/host_cache_96.sdi 2022-05-15T19:34:47.635996+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/host_cache_96.sdi to /backup/backup8028/performance_schema/host_cache_96.sdi 2022-05-15T19:34:47.638927+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_waits_sum_91.sdi to /backup/backup8028/performance_schema/events_waits_sum_91.sdi 2022-05-15T19:34:47.639391+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_waits_sum_91.sdi to /backup/backup8028/performance_schema/events_waits_sum_91.sdi 2022-05-15T19:34:47.641951+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/objects_summary__98.sdi to /backup/backup8028/performance_schema/objects_summary__98.sdi 2022-05-15T19:34:47.642271+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/objects_summary__98.sdi to /backup/backup8028/performance_schema/objects_summary__98.sdi 2022-05-15T19:34:47.644887+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_stages_hi_112.sdi to /backup/backup8028/performance_schema/events_stages_hi_112.sdi 2022-05-15T19:34:47.645267+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_stages_hi_112.sdi to /backup/backup8028/performance_schema/events_stages_hi_112.sdi 2022-05-15T19:34:47.647859+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/session_connect__150.sdi to /backup/backup8028/performance_schema/session_connect__150.sdi 2022-05-15T19:34:47.648126+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/session_connect__150.sdi to /backup/backup8028/performance_schema/session_connect__150.sdi 2022-05-15T19:34:47.650699+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/setup_objects_105.sdi to /backup/backup8028/performance_schema/setup_objects_105.sdi 2022-05-15T19:34:47.651003+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/setup_objects_105.sdi to /backup/backup8028/performance_schema/setup_objects_105.sdi 2022-05-15T19:34:47.653593+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/mutex_instances_97.sdi to /backup/backup8028/performance_schema/mutex_instances_97.sdi 2022-05-15T19:34:47.653923+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/mutex_instances_97.sdi to /backup/backup8028/performance_schema/mutex_instances_97.sdi 2022-05-15T19:34:47.656792+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_errors_su_142.sdi to /backup/backup8028/performance_schema/events_errors_su_142.sdi 2022-05-15T19:34:47.657085+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_errors_su_142.sdi to /backup/backup8028/performance_schema/events_errors_su_142.sdi 2022-05-15T19:34:47.659542+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/global_status_181.sdi to /backup/backup8028/performance_schema/global_status_181.sdi 2022-05-15T19:34:47.659828+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/global_status_181.sdi to /backup/backup8028/performance_schema/global_status_181.sdi 2022-05-15T19:34:47.662410+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/replication_appl_171.sdi to /backup/backup8028/performance_schema/replication_appl_171.sdi 2022-05-15T19:34:47.662751+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/replication_appl_171.sdi to /backup/backup8028/performance_schema/replication_appl_171.sdi 2022-05-15T19:34:47.665401+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/socket_summary_b_149.sdi to /backup/backup8028/performance_schema/socket_summary_b_149.sdi 2022-05-15T19:34:47.665813+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/socket_summary_b_149.sdi to /backup/backup8028/performance_schema/socket_summary_b_149.sdi 2022-05-15T19:34:47.668365+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/replication_asyn_173.sdi to /backup/backup8028/performance_schema/replication_asyn_173.sdi 2022-05-15T19:34:47.668682+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/replication_asyn_173.sdi to /backup/backup8028/performance_schema/replication_asyn_173.sdi 2022-05-15T19:34:47.674533+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/data_lock_waits_161.sdi to /backup/backup8028/performance_schema/data_lock_waits_161.sdi 2022-05-15T19:34:47.674914+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/data_lock_waits_161.sdi to /backup/backup8028/performance_schema/data_lock_waits_161.sdi 2022-05-15T19:34:47.677393+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/session_account__151.sdi to /backup/backup8028/performance_schema/session_account__151.sdi 2022-05-15T19:34:47.677701+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/session_account__151.sdi to /backup/backup8028/performance_schema/session_account__151.sdi 2022-05-15T19:34:47.681264+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/replication_grou_169.sdi to /backup/backup8028/performance_schema/replication_grou_169.sdi 2022-05-15T19:34:47.681640+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/replication_grou_169.sdi to /backup/backup8028/performance_schema/replication_grou_169.sdi 2022-05-15T19:34:47.684272+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/users_144.sdi to /backup/backup8028/performance_schema/users_144.sdi 2022-05-15T19:34:47.684531+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/users_144.sdi to /backup/backup8028/performance_schema/users_144.sdi 2022-05-15T19:34:47.687330+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_statement_121.sdi to /backup/backup8028/performance_schema/events_statement_121.sdi 2022-05-15T19:34:47.687744+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_statement_121.sdi to /backup/backup8028/performance_schema/events_statement_121.sdi 2022-05-15T19:34:47.690397+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_transacti_135.sdi to /backup/backup8028/performance_schema/events_transacti_135.sdi 2022-05-15T19:34:47.690744+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_transacti_135.sdi to /backup/backup8028/performance_schema/events_transacti_135.sdi 2022-05-15T19:34:47.696531+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_statement_120.sdi to /backup/backup8028/performance_schema/events_statement_120.sdi 2022-05-15T19:34:47.696972+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_statement_120.sdi to /backup/backup8028/performance_schema/events_statement_120.sdi 2022-05-15T19:34:47.702965+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/table_handles_158.sdi to /backup/backup8028/performance_schema/table_handles_158.sdi 2022-05-15T19:34:47.703401+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/table_handles_158.sdi to /backup/backup8028/performance_schema/table_handles_158.sdi 2022-05-15T19:34:47.709235+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_statement_130.sdi to /backup/backup8028/performance_schema/events_statement_130.sdi 2022-05-15T19:34:47.709643+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_statement_130.sdi to /backup/backup8028/performance_schema/events_statement_130.sdi 2022-05-15T19:34:47.712558+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/user_defined_fun_188.sdi to /backup/backup8028/performance_schema/user_defined_fun_188.sdi 2022-05-15T19:34:47.712868+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/user_defined_fun_188.sdi to /backup/backup8028/performance_schema/user_defined_fun_188.sdi 2022-05-15T19:34:47.715468+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_stages_su_114.sdi to /backup/backup8028/performance_schema/events_stages_su_114.sdi 2022-05-15T19:34:47.715733+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_stages_su_114.sdi to /backup/backup8028/performance_schema/events_stages_su_114.sdi 2022-05-15T19:34:47.718288+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/log_status_174.sdi to /backup/backup8028/performance_schema/log_status_174.sdi 2022-05-15T19:34:47.718559+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/log_status_174.sdi to /backup/backup8028/performance_schema/log_status_174.sdi 2022-05-15T19:34:47.721156+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_statement_126.sdi to /backup/backup8028/performance_schema/events_statement_126.sdi 2022-05-15T19:34:47.721610+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_statement_126.sdi to /backup/backup8028/performance_schema/events_statement_126.sdi 2022-05-15T19:34:47.724049+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/session_status_182.sdi to /backup/backup8028/performance_schema/session_status_182.sdi 2022-05-15T19:34:47.724286+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/session_status_182.sdi to /backup/backup8028/performance_schema/session_status_182.sdi 2022-05-15T19:34:47.726896+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_stages_cu_111.sdi to /backup/backup8028/performance_schema/events_stages_cu_111.sdi 2022-05-15T19:34:47.727251+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_stages_cu_111.sdi to /backup/backup8028/performance_schema/events_stages_cu_111.sdi 2022-05-15T19:34:47.729967+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_errors_su_140.sdi to /backup/backup8028/performance_schema/events_errors_su_140.sdi 2022-05-15T19:34:47.730282+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_errors_su_140.sdi to /backup/backup8028/performance_schema/events_errors_su_140.sdi 2022-05-15T19:34:47.732752+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_transacti_132.sdi to /backup/backup8028/performance_schema/events_transacti_132.sdi 2022-05-15T19:34:47.733119+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_transacti_132.sdi to /backup/backup8028/performance_schema/events_transacti_132.sdi 2022-05-15T19:34:47.735588+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_statement_122.sdi to /backup/backup8028/performance_schema/events_statement_122.sdi 2022-05-15T19:34:47.735924+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_statement_122.sdi to /backup/backup8028/performance_schema/events_statement_122.sdi 2022-05-15T19:34:47.738715+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/replication_appl_168.sdi to /backup/backup8028/performance_schema/replication_appl_168.sdi 2022-05-15T19:34:47.739176+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/replication_appl_168.sdi to /backup/backup8028/performance_schema/replication_appl_168.sdi 2022-05-15T19:34:47.741754+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_transacti_138.sdi to /backup/backup8028/performance_schema/events_transacti_138.sdi 2022-05-15T19:34:47.742060+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_transacti_138.sdi to /backup/backup8028/performance_schema/events_transacti_138.sdi 2022-05-15T19:34:47.744647+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/tls_channel_stat_190.sdi to /backup/backup8028/performance_schema/tls_channel_stat_190.sdi 2022-05-15T19:34:47.745224+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/tls_channel_stat_190.sdi to /backup/backup8028/performance_schema/tls_channel_stat_190.sdi 2022-05-15T19:34:47.747840+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/setup_threads_106.sdi to /backup/backup8028/performance_schema/setup_threads_106.sdi 2022-05-15T19:34:47.748118+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/setup_threads_106.sdi to /backup/backup8028/performance_schema/setup_threads_106.sdi 2022-05-15T19:34:47.750574+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_statement_123.sdi to /backup/backup8028/performance_schema/events_statement_123.sdi 2022-05-15T19:34:47.750872+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_statement_123.sdi to /backup/backup8028/performance_schema/events_statement_123.sdi 2022-05-15T19:34:47.753399+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_statement_124.sdi to /backup/backup8028/performance_schema/events_statement_124.sdi 2022-05-15T19:34:47.753908+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_statement_124.sdi to /backup/backup8028/performance_schema/events_statement_124.sdi 2022-05-15T19:34:47.756782+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_transacti_133.sdi to /backup/backup8028/performance_schema/events_transacti_133.sdi 2022-05-15T19:34:47.757192+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_transacti_133.sdi to /backup/backup8028/performance_schema/events_transacti_133.sdi 2022-05-15T19:34:47.759773+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/replication_appl_170.sdi to /backup/backup8028/performance_schema/replication_appl_170.sdi 2022-05-15T19:34:47.760015+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/replication_appl_170.sdi to /backup/backup8028/performance_schema/replication_appl_170.sdi 2022-05-15T19:34:47.762666+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/variables_info_186.sdi to /backup/backup8028/performance_schema/variables_info_186.sdi 2022-05-15T19:34:47.762992+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/variables_info_186.sdi to /backup/backup8028/performance_schema/variables_info_186.sdi 2022-05-15T19:34:47.765577+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/file_summary_by__94.sdi to /backup/backup8028/performance_schema/file_summary_by__94.sdi 2022-05-15T19:34:47.765880+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/file_summary_by__94.sdi to /backup/backup8028/performance_schema/file_summary_by__94.sdi 2022-05-15T19:34:47.768405+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/socket_instances_147.sdi to /backup/backup8028/performance_schema/socket_instances_147.sdi 2022-05-15T19:34:47.768705+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/socket_instances_147.sdi to /backup/backup8028/performance_schema/socket_instances_147.sdi 2022-05-15T19:34:47.771498+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/status_by_user_180.sdi to /backup/backup8028/performance_schema/status_by_user_180.sdi 2022-05-15T19:34:47.771823+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/status_by_user_180.sdi to /backup/backup8028/performance_schema/status_by_user_180.sdi 2022-05-15T19:34:47.774412+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/table_lock_waits_109.sdi to /backup/backup8028/performance_schema/table_lock_waits_109.sdi 2022-05-15T19:34:47.774897+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/table_lock_waits_109.sdi to /backup/backup8028/performance_schema/table_lock_waits_109.sdi 2022-05-15T19:34:47.777671+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/status_by_thread_179.sdi to /backup/backup8028/performance_schema/status_by_thread_179.sdi 2022-05-15T19:34:47.778086+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/status_by_thread_179.sdi to /backup/backup8028/performance_schema/status_by_thread_179.sdi 2022-05-15T19:34:47.780958+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/replication_conn_162.sdi to /backup/backup8028/performance_schema/replication_conn_162.sdi 2022-05-15T19:34:47.781343+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/replication_conn_162.sdi to /backup/backup8028/performance_schema/replication_conn_162.sdi 2022-05-15T19:34:47.784132+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/replication_appl_166.sdi to /backup/backup8028/performance_schema/replication_appl_166.sdi 2022-05-15T19:34:47.784409+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/replication_appl_166.sdi to /backup/backup8028/performance_schema/replication_appl_166.sdi 2022-05-15T19:34:47.788856+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_waits_sum_90.sdi to /backup/backup8028/performance_schema/events_waits_sum_90.sdi 2022-05-15T19:34:47.789180+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_waits_sum_90.sdi to /backup/backup8028/performance_schema/events_waits_sum_90.sdi 2022-05-15T19:34:47.791654+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/events_statement_129.sdi to /backup/backup8028/performance_schema/events_statement_129.sdi 2022-05-15T19:34:47.791930+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/events_statement_129.sdi to /backup/backup8028/performance_schema/events_statement_129.sdi 2022-05-15T19:34:47.794524+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/memory_summary_g_153.sdi to /backup/backup8028/performance_schema/memory_summary_g_153.sdi 2022-05-15T19:34:47.794833+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/memory_summary_g_153.sdi to /backup/backup8028/performance_schema/memory_summary_g_153.sdi 2022-05-15T19:34:47.797493+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying mysql/slow_log.CSM to /backup/backup8028/mysql/slow_log.CSM 2022-05-15T19:34:47.797830+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying mysql/slow_log.CSM to /backup/backup8028/mysql/slow_log.CSM 2022-05-15T19:34:47.800570+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying mysql/general_log_213.sdi to /backup/backup8028/mysql/general_log_213.sdi 2022-05-15T19:34:47.800844+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying mysql/general_log_213.sdi to /backup/backup8028/mysql/general_log_213.sdi 2022-05-15T19:34:47.803470+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying mysql/general_log.CSV to /backup/backup8028/mysql/general_log.CSV 2022-05-15T19:34:47.803524+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying mysql/general_log.CSV to /backup/backup8028/mysql/general_log.CSV 2022-05-15T19:34:47.806292+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying mysql/slow_log_214.sdi to /backup/backup8028/mysql/slow_log_214.sdi 2022-05-15T19:34:47.806588+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying mysql/slow_log_214.sdi to /backup/backup8028/mysql/slow_log_214.sdi 2022-05-15T19:34:47.809015+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying mysql/general_log.CSM to /backup/backup8028/mysql/general_log.CSM 2022-05-15T19:34:47.809271+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying mysql/general_log.CSM to /backup/backup8028/mysql/general_log.CSM 2022-05-15T19:34:47.811754+09:00 3 [Note] [MY-011825] [Xtrabackup] Copying mysql/slow_log.CSV to /backup/backup8028/mysql/slow_log.CSV 2022-05-15T19:34:47.811801+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying mysql/slow_log.CSV to /backup/backup8028/mysql/slow_log.CSV 2022-05-15T19:34:47.814655+09:00 3 [Note] [MY-011825] [Xtrabackup] Writing /backup/backup8028/test/db.opt 2022-05-15T19:34:47.814702+09:00 3 [Note] [MY-011825] [Xtrabackup] Done: Writing file /backup/backup8028/test/db.opt 2022-05-15T19:34:47.850348+09:00 0 [Note] [MY-011825] [Xtrabackup] Finished backing up non-InnoDB tables and files 2022-05-15T19:34:47.850397+09:00 0 [Note] [MY-011825] [Xtrabackup] Executing FLUSH NO_WRITE_TO_BINLOG BINARY LOGS 2022-05-15T19:34:47.865382+09:00 0 [Note] [MY-011825] [Xtrabackup] Selecting LSN and binary log position from p_s.log_status 2022-05-15T19:34:47.868961+09:00 0 [Note] [MY-011825] [Xtrabackup] Copying /var/lib/mysql/binlog.000004 to /backup/backup8028/binlog.000004 up to position 156 2022-05-15T19:34:47.869037+09:00 0 [Note] [MY-011825] [Xtrabackup] Done: Copying /var/lib/mysql/binlog.000004 to /backup/backup8028/binlog.000004 2022-05-15T19:34:47.872054+09:00 0 [Note] [MY-011825] [Xtrabackup] Writing /backup/backup8028/binlog.index 2022-05-15T19:34:47.872153+09:00 0 [Note] [MY-011825] [Xtrabackup] Done: Writing file /backup/backup8028/binlog.index 2022-05-15T19:34:47.875677+09:00 0 [Note] [MY-011825] [Xtrabackup] Writing /backup/backup8028/xtrabackup_binlog_info 2022-05-15T19:34:47.875740+09:00 0 [Note] [MY-011825] [Xtrabackup] Done: Writing file /backup/backup8028/xtrabackup_binlog_info 2022-05-15T19:34:47.878313+09:00 0 [Note] [MY-011825] [Xtrabackup] Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS... 2022-05-15T19:34:47.882368+09:00 0 [Note] [MY-011825] [Xtrabackup] The latest check point (for incremental): '28620551' 2022-05-15T19:34:47.882413+09:00 0 [Note] [MY-011825] [Xtrabackup] Stopping log copying thread at LSN 28620551 2022-05-15T19:34:47.882499+09:00 1 [Note] [MY-011825] [Xtrabackup] Starting to parse redo log at lsn = 28620369 2022-05-15T19:34:47.887708+09:00 0 [Note] [MY-011825] [Xtrabackup] Executing UNLOCK INSTANCE 2022-05-15T19:34:47.887896+09:00 0 [Note] [MY-011825] [Xtrabackup] All tables unlocked 2022-05-15T19:34:47.887986+09:00 0 [Note] [MY-011825] [Xtrabackup] Copying ib_buffer_pool to /backup/backup8028/ib_buffer_pool 2022-05-15T19:34:47.888351+09:00 0 [Note] [MY-011825] [Xtrabackup] Done: Copying ib_buffer_pool to /backup/backup8028/ib_buffer_pool 2022-05-15T19:34:47.891028+09:00 0 [Note] [MY-011825] [Xtrabackup] Backup created in directory '/backup/backup8028/' 2022-05-15T19:34:47.891065+09:00 0 [Note] [MY-011825] [Xtrabackup] MySQL binlog position: filename 'binlog.000004', position '156' 2022-05-15T19:34:47.891149+09:00 0 [Note] [MY-011825] [Xtrabackup] Writing /backup/backup8028/backup-my.cnf 2022-05-15T19:34:47.891205+09:00 0 [Note] [MY-011825] [Xtrabackup] Done: Writing file /backup/backup8028/backup-my.cnf 2022-05-15T19:34:47.894043+09:00 0 [Note] [MY-011825] [Xtrabackup] Writing /backup/backup8028/xtrabackup_info 2022-05-15T19:34:47.894113+09:00 0 [Note] [MY-011825] [Xtrabackup] Done: Writing file /backup/backup8028/xtrabackup_info 2022-05-15T19:34:48.899571+09:00 0 [Note] [MY-011825] [Xtrabackup] Transaction log of lsn (28620551) to (28620561) was copied. 2022-05-15T19:34:49.107431+09:00 0 [Note] [MY-011825] [Xtrabackup] completed OK!
xtrabackup version 8.0.27-19
インストール手順
過去バージョン削除してバージョン指定でインストール。
apt remove percona-xtrabackup-80 apt install percona-xtrabackup-80=8.0.27-19-1.buster
MySQL 8.0.29
失敗。
root@c8b975a6fea1:/# xtrabackup --backup --target-dir=/backup/backup8027/ --user=root --password=root xtrabackup: recognized server arguments: --datadir=/var/lib/mysql xtrabackup: recognized client arguments: --backup=1 --target-dir=/backup/backup8027/ --user=root --password=* xtrabackup version 8.0.27-19 based on MySQL server 8.0.27 Linux (x86_64) (revision id: 50dbc8dadda) 220515 18:45:17 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'root' (using password: YES). 220515 18:45:17 version_check Connected to MySQL server 220515 18:45:17 version_check Executing a version check against the server... 220515 18:45:17 version_check Done. 220515 18:45:17 Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: not set Error: Unsupported server version 8.0.29. Please upgrade PXB, if a new version is available. To continue with risk, use the option --no-server-version-check.
MySQL 8.0.28
失敗。
root@dfa20732334c:/# xtrabackup --backup --target-dir=/backup/backup8027/ --user=root --password=root xtrabackup: recognized server arguments: --datadir=/var/lib/mysql xtrabackup: recognized client arguments: --backup=1 --target-dir=/backup/backup8027/ --user=root --password=* xtrabackup version 8.0.27-19 based on MySQL server 8.0.27 Linux (x86_64) (revision id: 50dbc8dadda) 220515 18:18:27 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'root' (using password: YES). 220515 18:18:28 version_check Connected to MySQL server 220515 18:18:28 version_check Executing a version check against the server... 220515 18:18:28 version_check Done. 220515 18:18:28 Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: not set Error: Unsupported server version 8.0.28. Please upgrade PXB, if a new version is available. To continue with risk, use the option --no-server-version-check. root@dfa20732334c:/#
MySQL 8.0.27
成功。
root@462c93c9e1f6:/# xtrabackup --backup --target-dir=/backup/backup8027/ --user=root --password=root xtrabackup: recognized server arguments: --datadir=/var/lib/mysql xtrabackup: recognized client arguments: --backup=1 --target-dir=/backup/backup8027/ --user=root --password=* xtrabackup version 8.0.27-19 based on MySQL server 8.0.27 Linux (x86_64) (revision id: 50dbc8dadda) 220515 19:37:10 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'root' (using password: YES). 220515 19:37:10 version_check Connected to MySQL server 220515 19:37:10 version_check Executing a version check against the server... 220515 19:37:10 version_check Done. 220515 19:37:10 Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: not set Using server version 8.0.27 220515 19:37:10 Executing LOCK INSTANCE FOR BACKUP... xtrabackup: uses posix_fadvise(). xtrabackup: cd to /var/lib/mysql xtrabackup: open files limit requested 0, set to 1048576 xtrabackup: using the following InnoDB configuration: xtrabackup: innodb_data_home_dir = . xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 2 xtrabackup: innodb_log_file_size = 50331648 Number of pools: 1 xtrabackup: inititialize_service_handles suceeded 220515 19:37:10 Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: not set xtrabackup: Redo Log Archiving is not set up. 220515 19:37:10 >> log scanned up to (28620571) xtrabackup: Generating a list of tablespaces xtrabackup: Generating a list of tablespaces Scanning './' Completed space ID check of 2 files. Allocated tablespace ID 1 for sys/sys_config, old maximum was 0 Using undo tablespace './undo_001'. Using undo tablespace './undo_002'. Opened 2 existing undo tablespaces. 220515 19:37:10 [01] Copying ./ibdata1 to /backup/backup8027/ibdata1 220515 19:37:10 [01] ...done 220515 19:37:10 [01] Copying ./sys/sys_config.ibd to /backup/backup8027/sys/sys_config.ibd 220515 19:37:10 [01] ...done 220515 19:37:10 [01] Copying ./mysql.ibd to /backup/backup8027/mysql.ibd 220515 19:37:10 [01] ...done 220515 19:37:10 [01] Copying ./undo_002 to /backup/backup8027/undo_002 220515 19:37:10 [01] ...done 220515 19:37:10 [01] Copying ./undo_001 to /backup/backup8027/undo_001 220515 19:37:10 [01] ...done 220515 19:37:11 >> log scanned up to (28620571) 220515 19:37:11 Starting to backup non-InnoDB tables and files 220515 19:37:11 [01] Copying performance_schema/rwlock_instances_101.sdi to /backup/backup8027/performance_schema/rwlock_instances_101.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/variables_by_thr_183.sdi to /backup/backup8027/performance_schema/variables_by_thr_183.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/keyring_keys_152.sdi to /backup/backup8027/performance_schema/keyring_keys_152.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/setup_actors_102.sdi to /backup/backup8027/performance_schema/setup_actors_102.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/prepared_stateme_175.sdi to /backup/backup8027/performance_schema/prepared_stateme_175.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/table_io_waits_s_108.sdi to /backup/backup8027/performance_schema/table_io_waits_s_108.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/setup_consumers_103.sdi to /backup/backup8027/performance_schema/setup_consumers_103.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/events_errors_su_143.sdi to /backup/backup8027/performance_schema/events_errors_su_143.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/threads_110.sdi to /backup/backup8027/performance_schema/threads_110.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/events_statement_128.sdi to /backup/backup8027/performance_schema/events_statement_128.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/events_waits_sum_88.sdi to /backup/backup8027/performance_schema/events_waits_sum_88.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/file_summary_by__95.sdi to /backup/backup8027/performance_schema/file_summary_by__95.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/metadata_locks_159.sdi to /backup/backup8027/performance_schema/metadata_locks_159.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/events_errors_su_141.sdi to /backup/backup8027/performance_schema/events_errors_su_141.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/events_waits_sum_92.sdi to /backup/backup8027/performance_schema/events_waits_sum_92.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/processlist_100.sdi to /backup/backup8027/performance_schema/processlist_100.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/events_waits_cur_84.sdi to /backup/backup8027/performance_schema/events_waits_cur_84.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/replication_asyn_172.sdi to /backup/backup8027/performance_schema/replication_asyn_172.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/replication_appl_165.sdi to /backup/backup8027/performance_schema/replication_appl_165.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/events_transacti_137.sdi to /backup/backup8027/performance_schema/events_transacti_137.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/cond_instances_82.sdi to /backup/backup8027/performance_schema/cond_instances_82.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/events_stages_su_117.sdi to /backup/backup8027/performance_schema/events_stages_su_117.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/status_by_accoun_177.sdi to /backup/backup8027/performance_schema/status_by_accoun_177.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/memory_summary_b_155.sdi to /backup/backup8027/performance_schema/memory_summary_b_155.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/events_stages_su_116.sdi to /backup/backup8027/performance_schema/events_stages_su_116.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/events_statement_119.sdi to /backup/backup8027/performance_schema/events_statement_119.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/events_waits_sum_87.sdi to /backup/backup8027/performance_schema/events_waits_sum_87.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/user_variables_b_176.sdi to /backup/backup8027/performance_schema/user_variables_b_176.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/persisted_variab_187.sdi to /backup/backup8027/performance_schema/persisted_variab_187.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/table_io_waits_s_107.sdi to /backup/backup8027/performance_schema/table_io_waits_s_107.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/status_by_host_178.sdi to /backup/backup8027/performance_schema/status_by_host_178.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/data_locks_160.sdi to /backup/backup8027/performance_schema/data_locks_160.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/events_transacti_134.sdi to /backup/backup8027/performance_schema/events_transacti_134.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/events_transacti_136.sdi to /backup/backup8027/performance_schema/events_transacti_136.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/events_statement_125.sdi to /backup/backup8027/performance_schema/events_statement_125.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/events_statement_127.sdi to /backup/backup8027/performance_schema/events_statement_127.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/socket_summary_b_148.sdi to /backup/backup8027/performance_schema/socket_summary_b_148.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/global_variables_184.sdi to /backup/backup8027/performance_schema/global_variables_184.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/replication_conn_164.sdi to /backup/backup8027/performance_schema/replication_conn_164.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/events_stages_hi_113.sdi to /backup/backup8027/performance_schema/events_stages_hi_113.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/file_instances_93.sdi to /backup/backup8027/performance_schema/file_instances_93.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/replication_grou_163.sdi to /backup/backup8027/performance_schema/replication_grou_163.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/session_variable_185.sdi to /backup/backup8027/performance_schema/session_variable_185.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/events_waits_sum_89.sdi to /backup/backup8027/performance_schema/events_waits_sum_89.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/events_waits_his_86.sdi to /backup/backup8027/performance_schema/events_waits_his_86.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/memory_summary_b_156.sdi to /backup/backup8027/performance_schema/memory_summary_b_156.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/memory_summary_b_154.sdi to /backup/backup8027/performance_schema/memory_summary_b_154.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/hosts_146.sdi to /backup/backup8027/performance_schema/hosts_146.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/replication_appl_167.sdi to /backup/backup8027/performance_schema/replication_appl_167.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/events_waits_his_85.sdi to /backup/backup8027/performance_schema/events_waits_his_85.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/events_stages_su_118.sdi to /backup/backup8027/performance_schema/events_stages_su_118.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/keyring_componen_191.sdi to /backup/backup8027/performance_schema/keyring_componen_191.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/events_errors_su_139.sdi to /backup/backup8027/performance_schema/events_errors_su_139.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/binary_log_trans_189.sdi to /backup/backup8027/performance_schema/binary_log_trans_189.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/setup_instrument_104.sdi to /backup/backup8027/performance_schema/setup_instrument_104.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/error_log_83.sdi to /backup/backup8027/performance_schema/error_log_83.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/accounts_145.sdi to /backup/backup8027/performance_schema/accounts_145.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/events_transacti_131.sdi to /backup/backup8027/performance_schema/events_transacti_131.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/events_stages_su_115.sdi to /backup/backup8027/performance_schema/events_stages_su_115.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/memory_summary_b_157.sdi to /backup/backup8027/performance_schema/memory_summary_b_157.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/performance_time_99.sdi to /backup/backup8027/performance_schema/performance_time_99.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/host_cache_96.sdi to /backup/backup8027/performance_schema/host_cache_96.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/events_waits_sum_91.sdi to /backup/backup8027/performance_schema/events_waits_sum_91.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/objects_summary__98.sdi to /backup/backup8027/performance_schema/objects_summary__98.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/events_stages_hi_112.sdi to /backup/backup8027/performance_schema/events_stages_hi_112.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/session_connect__150.sdi to /backup/backup8027/performance_schema/session_connect__150.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/setup_objects_105.sdi to /backup/backup8027/performance_schema/setup_objects_105.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/mutex_instances_97.sdi to /backup/backup8027/performance_schema/mutex_instances_97.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/events_errors_su_142.sdi to /backup/backup8027/performance_schema/events_errors_su_142.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/global_status_181.sdi to /backup/backup8027/performance_schema/global_status_181.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/replication_appl_171.sdi to /backup/backup8027/performance_schema/replication_appl_171.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/socket_summary_b_149.sdi to /backup/backup8027/performance_schema/socket_summary_b_149.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/replication_asyn_173.sdi to /backup/backup8027/performance_schema/replication_asyn_173.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/data_lock_waits_161.sdi to /backup/backup8027/performance_schema/data_lock_waits_161.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/session_account__151.sdi to /backup/backup8027/performance_schema/session_account__151.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/replication_grou_169.sdi to /backup/backup8027/performance_schema/replication_grou_169.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/users_144.sdi to /backup/backup8027/performance_schema/users_144.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/events_statement_121.sdi to /backup/backup8027/performance_schema/events_statement_121.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/events_transacti_135.sdi to /backup/backup8027/performance_schema/events_transacti_135.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/events_statement_120.sdi to /backup/backup8027/performance_schema/events_statement_120.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/table_handles_158.sdi to /backup/backup8027/performance_schema/table_handles_158.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/events_statement_130.sdi to /backup/backup8027/performance_schema/events_statement_130.sdi 220515 19:37:11 [01] ...done 220515 19:37:11 [01] Copying performance_schema/user_defined_fun_188.sdi to /backup/backup8027/performance_schema/user_defined_fun_188.sdi 220515 19:37:12 [01] ...done 220515 19:37:12 [01] Copying performance_schema/events_stages_su_114.sdi to /backup/backup8027/performance_schema/events_stages_su_114.sdi 220515 19:37:12 [01] ...done 220515 19:37:12 [01] Copying performance_schema/log_status_174.sdi to /backup/backup8027/performance_schema/log_status_174.sdi 220515 19:37:12 [01] ...done 220515 19:37:12 [01] Copying performance_schema/events_statement_126.sdi to /backup/backup8027/performance_schema/events_statement_126.sdi 220515 19:37:12 [01] ...done 220515 19:37:12 [01] Copying performance_schema/session_status_182.sdi to /backup/backup8027/performance_schema/session_status_182.sdi 220515 19:37:12 [01] ...done 220515 19:37:12 [01] Copying performance_schema/events_stages_cu_111.sdi to /backup/backup8027/performance_schema/events_stages_cu_111.sdi 220515 19:37:12 [01] ...done 220515 19:37:12 [01] Copying performance_schema/events_errors_su_140.sdi to /backup/backup8027/performance_schema/events_errors_su_140.sdi 220515 19:37:12 [01] ...done 220515 19:37:12 [01] Copying performance_schema/events_transacti_132.sdi to /backup/backup8027/performance_schema/events_transacti_132.sdi 220515 19:37:12 [01] ...done 220515 19:37:12 [01] Copying performance_schema/events_statement_122.sdi to /backup/backup8027/performance_schema/events_statement_122.sdi 220515 19:37:12 [01] ...done 220515 19:37:12 [01] Copying performance_schema/replication_appl_168.sdi to /backup/backup8027/performance_schema/replication_appl_168.sdi 220515 19:37:12 [01] ...done 220515 19:37:12 [01] Copying performance_schema/events_transacti_138.sdi to /backup/backup8027/performance_schema/events_transacti_138.sdi 220515 19:37:12 [01] ...done 220515 19:37:12 [01] Copying performance_schema/tls_channel_stat_190.sdi to /backup/backup8027/performance_schema/tls_channel_stat_190.sdi 220515 19:37:12 [01] ...done 220515 19:37:12 [01] Copying performance_schema/setup_threads_106.sdi to /backup/backup8027/performance_schema/setup_threads_106.sdi 220515 19:37:12 [01] ...done 220515 19:37:12 [01] Copying performance_schema/events_statement_123.sdi to /backup/backup8027/performance_schema/events_statement_123.sdi 220515 19:37:12 [01] ...done 220515 19:37:12 [01] Copying performance_schema/events_statement_124.sdi to /backup/backup8027/performance_schema/events_statement_124.sdi 220515 19:37:12 [01] ...done 220515 19:37:12 [01] Copying performance_schema/events_transacti_133.sdi to /backup/backup8027/performance_schema/events_transacti_133.sdi 220515 19:37:12 [01] ...done 220515 19:37:12 [01] Copying performance_schema/replication_appl_170.sdi to /backup/backup8027/performance_schema/replication_appl_170.sdi 220515 19:37:12 [01] ...done 220515 19:37:12 [01] Copying performance_schema/variables_info_186.sdi to /backup/backup8027/performance_schema/variables_info_186.sdi 220515 19:37:12 [01] ...done 220515 19:37:12 [01] Copying performance_schema/file_summary_by__94.sdi to /backup/backup8027/performance_schema/file_summary_by__94.sdi 220515 19:37:12 [01] ...done 220515 19:37:12 [01] Copying performance_schema/socket_instances_147.sdi to /backup/backup8027/performance_schema/socket_instances_147.sdi 220515 19:37:12 [01] ...done 220515 19:37:12 [01] Copying performance_schema/status_by_user_180.sdi to /backup/backup8027/performance_schema/status_by_user_180.sdi 220515 19:37:12 [01] ...done 220515 19:37:12 [01] Copying performance_schema/table_lock_waits_109.sdi to /backup/backup8027/performance_schema/table_lock_waits_109.sdi 220515 19:37:12 [01] ...done 220515 19:37:12 [01] Copying performance_schema/status_by_thread_179.sdi to /backup/backup8027/performance_schema/status_by_thread_179.sdi 220515 19:37:12 [01] ...done 220515 19:37:12 [01] Copying performance_schema/replication_conn_162.sdi to /backup/backup8027/performance_schema/replication_conn_162.sdi 220515 19:37:12 [01] ...done 220515 19:37:12 [01] Copying performance_schema/replication_appl_166.sdi to /backup/backup8027/performance_schema/replication_appl_166.sdi 220515 19:37:12 [01] ...done 220515 19:37:12 [01] Copying performance_schema/events_waits_sum_90.sdi to /backup/backup8027/performance_schema/events_waits_sum_90.sdi 220515 19:37:12 [01] ...done 220515 19:37:12 [01] Copying performance_schema/events_statement_129.sdi to /backup/backup8027/performance_schema/events_statement_129.sdi 220515 19:37:12 [01] ...done 220515 19:37:12 [01] Copying performance_schema/memory_summary_g_153.sdi to /backup/backup8027/performance_schema/memory_summary_g_153.sdi 220515 19:37:12 [01] ...done 220515 19:37:12 [01] Copying mysql/slow_log.CSM to /backup/backup8027/mysql/slow_log.CSM 220515 19:37:12 [01] ...done 220515 19:37:12 [01] Copying mysql/general_log_213.sdi to /backup/backup8027/mysql/general_log_213.sdi 220515 19:37:12 [01] ...done 220515 19:37:12 [01] Copying mysql/general_log.CSV to /backup/backup8027/mysql/general_log.CSV 220515 19:37:12 [01] ...done 220515 19:37:12 [01] Copying mysql/slow_log_214.sdi to /backup/backup8027/mysql/slow_log_214.sdi 220515 19:37:12 [01] ...done 220515 19:37:12 [01] Copying mysql/general_log.CSM to /backup/backup8027/mysql/general_log.CSM 220515 19:37:12 [01] ...done 220515 19:37:12 [01] Copying mysql/slow_log.CSV to /backup/backup8027/mysql/slow_log.CSV 220515 19:37:12 [01] ...done 220515 19:37:12 [00] Writing /backup/backup8027/test/db.opt 220515 19:37:12 [00] ...done 220515 19:37:12 Finished backing up non-InnoDB tables and files 220515 19:37:12 Executing FLUSH NO_WRITE_TO_BINLOG BINARY LOGS 220515 19:37:12 Selecting LSN and binary log position from p_s.log_status 220515 19:37:12 [00] Copying /var/lib/mysql/binlog.000005 to /backup/backup8027/binlog.000005 up to position 156 220515 19:37:12 [00] ...done 220515 19:37:12 [00] Writing /backup/backup8027/binlog.index 220515 19:37:12 [00] ...done 220515 19:37:12 [00] Writing /backup/backup8027/xtrabackup_binlog_info 220515 19:37:12 [00] ...done 220515 19:37:12 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS... xtrabackup: The latest check point (for incremental): '28620571' xtrabackup: Stopping log copying thread at LSN 28620571. Starting to parse redo log at lsn = 28620369 220515 19:37:12 Executing UNLOCK INSTANCE 220515 19:37:12 All tables unlocked 220515 19:37:12 [00] Copying ib_buffer_pool to /backup/backup8027/ib_buffer_pool 220515 19:37:12 [00] ...done 220515 19:37:12 Backup created in directory '/backup/backup8027/' MySQL binlog position: filename 'binlog.000005', position '156' 220515 19:37:12 [00] Writing /backup/backup8027/backup-my.cnf 220515 19:37:12 [00] ...done 220515 19:37:12 [00] Writing /backup/backup8027/xtrabackup_info 220515 19:37:12 [00] ...done xtrabackup: Transaction log of lsn (28620571) to (28620581) was copied. 220515 19:37:13 completed OK!
〆
XtraBackupのイメージ使ってみたけどうまくいかなかったので各コンテナの中でXtraBackupをインストールしました。
エラーメッセージとか気になったので検証しましたが、挙動としては想定通りで上位バージョンだと実行されないですね。
参考記事
MySQL 8.0.29 and Percona XtraBackup Incompatibilities - Percona Database Performance Blog
MySQL のバックアップに Percona XtraBackup を使って、Amazon S3 へ直接バックアップする | CyberAgent Developers Blog
Percona XtraBackup 8.0.23 を使ってみる | スマートスタイル TECH BLOG
第59回 Percona XtraBackupを使ってみよう：MySQL道普請便り｜gihyo.jp … 技術評論社
DockerコンテナでのPerconaXtraBackupの実行— PerconaXtraBackup2.4ドキュメント
Image Layer Details - perconalab/percona-xtrabackup:8.0.28-20 | Docker Hub
docker-compose で立ち上げたコンテナの IP アドレスを調べる - Qiita
docker inspect — Docker-docs-ja 20.10 ドキュメント
ERROR: No such service:となった時の対応方法 - Qiita
percona — percona xtrabackupを使用したローカルマシンのリモートサーバーのMySQLバックアップ
Linux Mint で Percona XtraBackup をインストールする方法 - 約束の地
lsb_releaseコマンド／ディストリビューションのバージョン確認 | スタディインフラ
https://repo.percona.com/apt/percona-release_latest.buster_all.deb
