对performance_schema下的系统视图clone_status和clone_progress改造，使其可以作为增量备份操作的状态监控，该视图只能保存最近5次的备份操作记录。更多介绍参考
1、可以使用如下命令查询备份状态：
greatdb> select * from clone_status;
+------+------+-------------+-------------------------+-------------------------+----------------+---------------------------------+----------+---------------+-------------+-----------------+---------------+-----------+----------------+------------+
| ID | PID | STATE | BEGIN_TIME | END_TIME | SOURCE | DESTINATION | ERROR_NO | ERROR_MESSAGE | BINLOG_FILE | BINLOG_POSITION | GTID_EXECUTED | START_LSN | PAGE_TRACK_LSN | END_LSN |
+------+------+-------------+-------------------------+-------------------------+----------------+---------------------------------+----------+---------------+-------------+-----------------+---------------+-----------+----------------+------------+
| 0 | 310 | Completed | 2023-08-01 14:29:29.165 | 2023-08-01 14:29:34.360 | LOCAL INSTANCE | /home/liugang/code/data/clone1/ | 0 | | | 0 | | 0 | 0 | 138085535 |
| 1 | 313 | In Progress | 2023-08-02 16:00:56.557 | NULL | LOCAL INSTANCE | /home/liugang/code/data/clone2/ | 0 | | | 0 | | 0 | 0 | 1606948531 |
+------+------+-------------+-------------------------+-------------------------+----------------+---------------------------------+----------+---------------+-------------+-----------------+---------------+-----------+----------------+------------+
2 rows in set (0.00 sec)
如果需要终止ID=1的备份任务，可以通过如下命令：
greatdb> kill 313;
注意： 终止的备份任务，不能再次启动。
2、可以使用如下命令查询备份进度：
greatdb> select * from clone_progress;
+------+-----------+-------------+----------------------------+----------------------------+---------+------------+------------+---------+------------+---------------+
| ID | STAGE | STATE | BEGIN_TIME | END_TIME | THREADS | ESTIMATE | DATA | NETWORK | DATA_SPEED | NETWORK_SPEED |
+------+-----------+-------------+----------------------------+----------------------------+---------+------------+------------+---------+------------+---------------+
| 0 | DROP DATA | Completed | 2023-08-01 14:29:29.164923 | 2023-08-01 14:29:33.602478 | 1 | 0 | 0 | 0 | 0 | 0 |
| 0 | FILE COPY | Completed | 2023-08-01 14:29:33.602520 | 2023-08-01 14:29:33.801003 | 1 | 419485776 | 419485776 | 0 | 0 | 0 |
| 0 | PAGE COPY | Completed | 2023-08-01 14:29:33.801075 | 2023-08-01 14:29:34.033987 | 1 | 0 | 0 | 0 | 0 | 0 |
| 0 | REDO COPY | Completed | 2023-08-01 14:29:34.034063 | 2023-08-01 14:29:34.048264 | 1 | 21940224 | 21940224 | 0 | 0 | 0 |
| 0 | FILE SYNC | Completed | 2023-08-01 14:29:34.048326 | 2023-08-01 14:29:34.360404 | 1 | 0 | 0 | 0 | 0 | 0 |
| 0 | RESTART | Not Started | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 |
| 0 | RECOVERY | Not Started | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 |
| 1 | DROP DATA | Completed | 2023-08-02 16:00:56.557410 | 2023-08-02 16:00:56.563695 | 1 | 0 | 0 | 0 | 0 | 0 |
| 1 | FILE COPY | Completed | 2023-08-02 16:00:56.563883 | 2023-08-02 16:00:59.131295 | 1 | 1709234256 | 1709234256 | 0 | 0 | 0 |
| 1 | PAGE COPY | Completed | 2023-08-02 16:00:59.131370 | 2023-08-02 16:00:59.140021 | 1 | 0 | 0 | 0 | 0 | 0 |
| 1 | REDO COPY | Completed | 2023-08-02 16:00:59.140058 | 2023-08-02 16:00:59.140424 | 1 | 6656 | 6656 | 0 | 0 | 0 |
| 1 | FILE SYNC | Completed | 2023-08-02 16:00:59.140457 | 2023-08-02 16:00:59.728959 | 1 | 0 | 0 | 0 | 0 | 0 |
| 1 | RESTART | Not Started | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 |
| 1 | RECOVERY | Not Started | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 |
+------+-----------+-------------+----------------------------+----------------------------+---------+------------+------------+---------+------------+---------------+
21 rows in set (0.00 sec)「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
