Description
You can query the historical events related to the daily_merge module at the cluster level.
Statement
OceanBase Database V3.2.0 and later:
SELECT * FROM __all_rootservice_event_history
WHERE module = 'daily_merge' AND gmt_create >= NOW() - INTERVAL 1 DAY
ORDER BY gmt_create DESC;
Here is a sample return result:
+----------------------------+-------------+----------------------+---------------+--------+--------------------------+-------------+-------+--------+-------+--------+-------+--------+-------+--------+------------+----------------+-------------+
| gmt_create | module | event | name1 | value1 | name2 | value2 | name3 | value3 | name4 | value4 | name5 | value5 | name6 | value6 | extra_info | rs_svr_ip | rs_svr_port |
+----------------------------+-------------+----------------------+---------------+--------+--------------------------+-------------+-------+--------+-------+--------+-------+--------+-------+--------+------------+----------------+-------------+
| 2024-08-14 02:01:39.692364 | daily_merge | global_merged | version | 4 | | | | | | | | | | | | xxx.xxx.xxx.xxx | 2882 |
| 2024-08-14 02:01:29.582547 | daily_merge | all_partition_merged | merge_version | 4 | zone | zone1 | | | | | | | | | | xxx.xxx.xxx.xxx | 2882 |
| 2024-08-14 02:01:29.582513 | daily_merge | merge_succeed | merge_version | 4 | zone | zone1 | | | | | | | | | | xxx.xxx.xxx.xxx | 2882 |
| 2024-08-14 02:00:20.951893 | daily_merge | start_merge | zone | zone1 | global_broadcast_version | 4 | | | | | | | | | | xxx.xxx.xxx.xxx | 2882 |
| 2024-08-14 02:00:20.948934 | daily_merge | set_zone_merging | zone | zone1 | | | | | | | | | | | | xxx.xxx.xxx.xxx | 2882 |
| 2024-08-14 02:00:20.921171 | daily_merge | merging | merge_version | 4 | zone | global_zone | | | | | | | | | | xxx.xxx.xxx.xxx | 2882 |
+----------------------------+-------------+----------------------+---------------+--------+--------------------------+-------------+-------+--------+-------+--------+-------+--------+-------+--------+------------+----------------+-------------+