GLOBAL_REDO_STATUS
GLOBAL_REDO_STATUS displays the replaying of logs about instances in the entire cluster.
Name |
Type |
Description |
---|---|---|
node_name |
text |
Instance name. |
redo_start_ptr |
bigint |
Start point for replaying the instance logs. |
redo_start_time |
bigint |
Start time (UTC) when the instance logs are replayed. |
redo_done_time |
bigint |
End time (UTC) when the instance logs are replayed. |
curr_time |
bigint |
Current time (UTC) of the instance. |
min_recovery_point |
bigint |
Minimum barrier for the current instance log to provide services after the replay is complete. |
read_ptr |
bigint |
Position for reading the instance logs. |
last_replayed_read_ptr |
bigint |
Position for replaying the instance logs. |
recovery_done_ptr |
bigint |
Replay position after the instance is started. |
read_xlog_io_counter |
bigint |
Number of I/Os when the current instance reads and replays logs. |
read_xlog_io_total_dur |
bigint |
Total I/O duration when the current instance reads and replays logs. |
read_data_io_counter |
bigint |
Number of data page I/O reads during replay in the current instance log. |
read_data_io_total_dur |
bigint |
Total I/O duration reads during replay in the current instance log. |
write_data_io_counter |
bigint |
Number of data page I/O writes during replay in the current instance log. |
write_data_io_total_dur |
bigint |
Total I/O duration writes during replay in the current instance log. |
process_pending_counter |
bigint |
Number of synchronization times of log distribution threads during replay in the instance log. |
process_pending_total_dur |
bigint |
Synchronization duration of log distribution threads during replay in the instance log. |
apply_counter |
bigint |
Number of synchronization times of replay threads during replay in the instance log. |
apply_total_dur |
bigint |
Synchronization duration of replay threads during replay in the instance log. |
speed |
bigint |
Log replay rate of the current instance. The value is updated every time when a 256-MB log is replayed. The unit is byte/s. In a cluster environment, you are advised to run the cm_ctl query -rv command to obtain a more accurate replay speed of the standby node. For details about the cm_ctl command, see "Unified Cluster Management Tool" in Tool Reference. |
local_max_ptr |
bigint |
Maximum number of replay logs received by the localhost after the instance is started. |
primary_flush_ptr |
bigint |
Log point where the host flushes logs to a disk. |
worker_info |
text |
Replay thread information of the instance. If parallel replay is not enabled, the value is NULL. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot