My backup was made on the MySQL slave database. When I was preparing the backup file, it prompted “start shutdown”, and then it has been showing “Waiting for change buffer merge to complete number of bytes of change buffer”, but this number keeps increasing and decreasing. I suspect whether it is still synchronizing with the master database during the prepare process.
Here are note info:
2024-07-30T17:43:28.535402+08:00 0 [Note] [MY-013072] [InnoDB] Starting shutdown…
2024-07-30T17:44:28.536153+08:00 0 [Note] [MY-012874] [InnoDB] Waiting for change buffer merge to complete number of bytes of change buffer just merged: 26059
2024-07-30T17:45:02.912677+08:00 0 [Note] [MY-013073] [InnoDB] Waiting for master to exit.
2024-07-30T17:45:28.536472+08:00 0 [Note] [MY-012874] [InnoDB] Waiting for change buffer merge to complete number of bytes of change buffer just merged: 25672
2024-07-30T17:46:28.536851+08:00 0 [Note] [MY-012874] [InnoDB] Waiting for change buffer merge to complete number of bytes of change buffer just merged: 25046
2024-07-30T17:46:37.242152+08:00 0 [Note] [MY-013073] [InnoDB] Waiting for master to exit.
2024-07-30T17:47:28.537042+08:00 0 [Note] [MY-012874] [InnoDB] Waiting for change buffer merge to complete number of bytes of change buffer just merged: 24800
2024-07-30T17:48:11.466264+08:00 0 [Note] [MY-013073] [InnoDB] Waiting for master to exit.
2024-07-30T17:48:28.537710+08:00 0 [Note] [MY-012874] [InnoDB] Waiting for change buffer merge to complete number of bytes of change buffer just merged: 26506
2024-07-30T17:49:28.537857+08:00 0 [Note] [MY-012874] [InnoDB] Waiting for change buffer merge to complete number of bytes of change buffer just merged: 26222
2024-07-30T17:49:45.659260+08:00 0 [Note] [MY-013073] [InnoDB] Waiting for master to exit.
2024-07-30T17:50:28.538629+08:00 0 [Note] [MY-012874] [InnoDB] Waiting for change buffer merge to complete number of bytes of change buffer just merged: 26147
2024-07-30T17:51:19.890650+08:00 0 [Note] [MY-013073] [InnoDB] Waiting for master to exit.
2024-07-30T17:51:28.539107+08:00 0 [Note] [MY-012874] [InnoDB] Waiting for change buffer merge to complete number of bytes of change buffer just merged: 24990
2024-07-30T17:52:28.539204+08:00 0 [Note] [MY-012874] [InnoDB] Waiting for change buffer merge to complete number of bytes of change buffer just merged: 26118
2024-07-30T17:52:54.088733+08:00 0 [Note] [MY-013073] [InnoDB] Waiting for master to exit.
2024-07-30T17:53:28.539744+08:00 0 [Note] [MY-012874] [InnoDB] Waiting for change buffer merge to complete number of bytes of change buffer just merged: 26763
2024-07-30T17:54:28.304980+08:00 0 [Note] [MY-013073] [InnoDB] Waiting for master to exit.
2024-07-30T17:54:28.540255+08:00 0 [Note] [MY-012874] [InnoDB] Waiting for change buffer merge to complete number of bytes of change buffer just merged: 25321
2024-07-30T17:55:28.540414+08:00 0 [Note] [MY-012874] [InnoDB] Waiting for change buffer merge to complete number of bytes of change buffer just merged: 26119
2024-07-30T17:56:02.526305+08:00 0 [Note] [MY-013073] [InnoDB] Waiting for master to exit.
2024-07-30T17:56:28.541092+08:00 0 [Note] [MY-012874] [InnoDB] Waiting for change buffer merge to complete number of bytes of change buffer just merged: 26168
2024-07-30T17:57:28.541436+08:00 0 [Note] [MY-012874] [InnoDB] Waiting for change buffer merge to complete number of bytes of change buffer just merged: 24441
2024-07-30T17:57:36.744417+08:00 0 [Note] [MY-013073] [InnoDB] Waiting for master to exit.
2024-07-30T17:58:28.541860+08:00 0 [Note] [MY-012874] [InnoDB] Waiting for change buffer merge to complete number of bytes of change buffer just merged: 25650