Overview
Scenarios
Product Architecture
Instance Types
Compatibility Notes
Usage specification recommendations
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 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. |
tdsql > SELECT * FROM INFORMATION_SCHEMA.ROUTE_CACHE_REGION\\G*************************** 1. row ***************************bucket: Globalregion_id: 23region_version: 0start_key: 00000076end_key: 00000077rep_group_id: 768rep_group_meta_version: 37rep_group_member_version: 0rep_group_key_range_version: 37rep_group_key_range_shrink_version: 0data_space_type: SYSnode_id: 1node_name: node-******-1-001node_rpc_addr: 10.10.10.10:9999*************************** 2. row ***************************bucket: Globalregion_id: 85region_version: 0start_key: 000000BEend_key: 000000BFrep_group_id: 768rep_group_meta_version: 37rep_group_member_version: 0rep_group_key_range_version: 37rep_group_key_range_shrink_version: 0data_space_type: SYSnode_id: 1node_name: node-******-1-001node_rpc_addr: 10.10.10.10:9999
피드백