Overview
Scenarios
Product Architecture
Instance Types
Compatibility Notes
Usage specification recommendations
INFORMATION_SCHEMA.TDSTORE_INSTALL_SNAPSHOT_INFO is used to query the execution status of Install Snapshot tasks at the TDStore layer, including tasks in progress and completed historical tasks.Field Name | Type | Description |
isLeader | varchar(64) | Whether the node is the Leader. |
source_node | varchar(256) | The Leader Node address for the Install Snapshot task. |
dest_node | varchar(256) | The Follower Node address for the Install Snapshot task. |
term | bigint unsigned | Raft term. |
type | varchar(64) | If it is the Leader, record the trigger reason for the Install Snapshot task: Replica: issued by MC.Log Delay: the log of the Follower node is lagging behind.If it is a Follower, this field is empty. |
replication_group_id | bigint unsigned | RG ID. |
start_time | varchar(64) | The start time of the Install Snapshot task. |
end_time | varchar(64) | The end time of the Install Snapshot task. |
err_msg | varchar(256) | If the task fails, record the error message. |
transfered_file_num | bigint | The number of Snapshot files pulled by the Follower. (If it is the Leader, this field is empty.) |
transfered_file_size | bigint | The total size of Snapshot files pulled by the Follower. (If it is the Leader, this field is empty.) |
total_file_num | bigint | The number of Snapshot files generated by the Leader. (If it is a Follower, this field is empty.) |
total_file_size | bigint | The total size of Snapshot files generated by the Leader. (If it is a Follower, this field is empty.) |
stage | varchar(64) | The status of the Install Snapshot task: Doing: Installation of the Snapshot task is in progress.Done: Installation of the Snapshot task has been completed. |
cost_info | varchar(64) | Duration of the Install Snapshot task: If it is the Leader, record the duration of the phase for generating Snapshot files. If it is a Follower, record the duration of copying Snapshot files from the Leader. |
tdsql> SELECT * FROM TDSTORE_INSTALL_SNAPSHOT_INFO limit 2\\G;*************************** 1. row ***************************is_leader: falsesource_node: 10.10.10.252:20002:768:tpcc_cluster:node-tpcc_cluster-001:0dest_node: 10.10.10.10:20002:768:tpcc_cluster:node-tpcc_cluster-003:1term: 4type: NULLrep_group_id: 768start_time: 2024-08-27 11:15:46 367end_time: 2024-08-27 11:15:46 473err_msg: NULLtransfered_file_num: 2transfered_file_size: 10702037total_file_num: NULLtotal_file_size: NULLstage: donecost_info: DOWNLOAD_SNAPSHOT: 57ms*************************** 2. row ***************************is_leader: truesource_node: 10.10.10.252:20002:768:tpcc_cluster:node-tpcc_cluster-001:0dest_node: 10.10.10.10:20002:768:tpcc_cluster:node-tpcc_cluster-003:1term: 4type: Log Delayrep_group_id: 768start_time: 2024-08-27 11:15:46 505end_time: 2024-08-27 11:15:46 612err_msg: NULLtransfered_file_num: NULLtransfered_file_size: NULLtotal_file_num: 2total_file_size: 10702037stage: donecost_info: [INSTALL_SNAPSHOT: <COMPACT_SST_TO_LBASE: 35ms>, <GENERATE_AND_GET_HARD_LINK_SST_FILE: 0ms>]2 rows in set (0.00 sec)
피드백