tencent cloud

TDSQL Boundless

Release Notes
Product Introduction
Overview
Scenarios
Product Architecture
Instance Types
Compatibility Notes
Usage specification recommendations
Kernel Features
Kernel Overview
Kernel Version Release Notes
Functionality Features
Performance Features
Billing
Billing Overview
Purchase Method
Pricing Details
Renewal
Overdue Payments
Refund
Getting Started
Creating an Instance
Connect to Instances
User Guide
Data Migration
Data Subscription
Instance Management
Parameter Configuration
Account Management
Security Group
Backup and Restoration
Database Auditing
Tag Management
Use Cases
Technical Evolution and Usage Practices of Online DDL
Lock Mechanism Analysis and Troubleshooting Practices
Data Intelligent Scheduling and Related Practices for Performance Optimization
TDSQL Boundless Selection Guide and Practical Tutorial
Developer Guide
Developer Guide (MySQL Compatibility Mode)
Developer Guide (HBase Compatibility Mode)
Performance Tuning
Performance Tuning Overview
SQL Tuning
DDL Tuning
Performance White Paper
Performance Overview
TPC-C Test
Sysbench Test
API Documentation
History
Introduction
API Category
Making API Requests
Instance APIs
Security Group APIs
Task APIs
Backup APIs
Rollback APIs
Parameter APIs
Database APIs
Data Types
Error Codes
General Reference
System Architecture
SQL Reference
Database Parameter Description
TPC-H benchmark data model reference
Error Code Information
Security and Compliance
FAQs
Agreements
Service Level Agreement
Terms of Service
Privacy Policy
Data Processing And Security Agreement
Contact Us
Glossary

TDSTORE_INSTALL_SNAPSHOT_INFO

PDF
포커스 모드
폰트 크기
마지막 업데이트 시간: 2026-02-10 11:06:31

Function

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 Description

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.

Examples

tdsql> SELECT * FROM TDSTORE_INSTALL_SNAPSHOT_INFO limit 2\\G;
*************************** 1. row ***************************
is_leader: false
source_node: 10.10.10.252:20002:768:tpcc_cluster:node-tpcc_cluster-001:0
dest_node: 10.10.10.10:20002:768:tpcc_cluster:node-tpcc_cluster-003:1
term: 4
type: NULL
rep_group_id: 768
start_time: 2024-08-27 11:15:46 367
end_time: 2024-08-27 11:15:46 473
err_msg: NULL
transfered_file_num: 2
transfered_file_size: 10702037
total_file_num: NULL
total_file_size: NULL
stage: done
cost_info: DOWNLOAD_SNAPSHOT: 57ms
*************************** 2. row ***************************
is_leader: true
source_node: 10.10.10.252:20002:768:tpcc_cluster:node-tpcc_cluster-001:0
dest_node: 10.10.10.10:20002:768:tpcc_cluster:node-tpcc_cluster-003:1
term: 4
type: Log Delay
rep_group_id: 768
start_time: 2024-08-27 11:15:46 505
end_time: 2024-08-27 11:15:46 612
err_msg: NULL
transfered_file_num: NULL
transfered_file_size: NULL
total_file_num: 2
total_file_size: 10702037
stage: done
cost_info: [INSTALL_SNAPSHOT: <COMPACT_SST_TO_LBASE: 35ms>, <GENERATE_AND_GET_HARD_LINK_SST_FILE: 0ms>]
2 rows in set (0.00 sec)


도움말 및 지원

문제 해결에 도움이 되었나요?

피드백