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

ROUTE_CACHE_REGION

PDF
포커스 모드
폰트 크기
마지막 업데이트 시간: 2026-04-03 16:05:18

Function

ROUTE_CACHE_REGION view is used to query the routing cache information of the REGION cached by the current HyperNode, including details such as names and RPC addresses. This view displays only the local routing cache of the HyperNode to which the client is connected.

Field Description

Field Name
Type
Description
bucket
varchar(21)
The bucket label of the bucketed routing cache.
region_id
bigint unsigned
unique identifier of the data shard (REGION).
region_version
bigint unsigned
The version information of the REGION. This version number is incremented when Region scheduling occurs.
start_key
varchar(256)
The starting key value of the data segment for this data shard Region.
end_key
varchar(256)
The endpoint key value of the data segment for this data shard Region.
rep_group_id
bigint unsigned
The replication group ID to which the REGION belongs.
rep_group_meta_version
bigint unsigned
The metadata version number of the replication group. This version number is incremented when the replication group undergoes split or merge operations, or when data shards within the group are created, deleted, split, or merged.
Usage recommendations: This field is primarily used by the Tencent Cloud technical support team during in-depth troubleshooting. No special attention is required during daily Ops.
rep_group_member_version
bigint unsigned
The member version number of the replication group. This version number is incremented when members of the replication group are changed (added, removed, promoted, or demoted).
Usage recommendations: This field is primarily used by the Tencent Cloud technical support team during in-depth troubleshooting. No special attention is required during daily Ops.
rep_group_key_range_version
bigint unsigned
The key range version number of the replication group. This version number is incremented when the replication group undergoes split or merge operations, or when data shards within the group are created or deleted.
Usage recommendations: This field is primarily used by the Tencent Cloud technical support team during in-depth troubleshooting. No special attention is required during daily Ops.
rep_group_key_range_shrink_version
bigint unsigned
The key range compaction version number of the replication group. This version number is incremented when the replication group undergoes split operations or when data shards within the group are deleted.
Usage recommendations: This field is primarily used by the Tencent Cloud technical support team during in-depth troubleshooting. No special attention is required during daily Ops.
data_space_type
varchar(4)
The data space type of the REGION. Options include:
SYS: System data space.
USR: User data space.
node_id
bigint unsigned
The node ID where the REGION is located.
node_name
varchar(128)
The node name where the REGION is located.
node_rpc_addr
varchar(32)
The RPC address of the node where the REGION is located.

Examples

tdsql > SELECT * FROM INFORMATION_SCHEMA.ROUTE_CACHE_REGION\\G
*************************** 1. row ***************************
bucket: Global
region_id: 23
region_version: 0
start_key: 00000076
end_key: 00000077
rep_group_id: 768
rep_group_meta_version: 37
rep_group_member_version: 0
rep_group_key_range_version: 37
rep_group_key_range_shrink_version: 0
data_space_type: SYS
node_id: 1
node_name: node-******-1-001
node_rpc_addr: 10.10.10.10:9999
*************************** 2. row ***************************
bucket: Global
region_id: 85
region_version: 0
start_key: 000000BE
end_key: 000000BF
rep_group_id: 768
rep_group_meta_version: 37
rep_group_member_version: 0
rep_group_key_range_version: 37
rep_group_key_range_shrink_version: 0
data_space_type: SYS
node_id: 1
node_name: node-******-1-001
node_rpc_addr: 10.10.10.10:9999

도움말 및 지원

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

피드백