Overview
Scenarios
Product Architecture
Instance Types
Compatibility Notes
Usage specification recommendations
INFORMATION_SCHEMA.META_CLUSTER_REGIONS is used to store and display metadata related to data shards (Region) within the instance.Field Name | Type | Description |
region_id | bigint unsigned | Region ID. |
rep_group_id | bigint unsigned | The RG ID of the data shard. |
data_obj_id | bigint unsigned | DataObject ID. |
data_obj_type | varchar(64) | DataObject type. |
start_key | varchar(64) | the start position of the key range. |
end_key | varchar(64) | the end position of the Key range. |
create_time | varchar(64) | Creation time. |
parent_region_id | bigint unsigned | If a split occurs, then it is the ID of the parent Region; otherwise the value is 0. |
region_stats_approximate_size | bigint unsigned | The approximate data size of the data shard in bytes. |
region_stats_approximate_keys | bigint unsigned | The approximate number of keys in the data shard. |
tdsql>select * from information_schema.meta_cluster_regions where region_id=179\\G*************************** 1. row ***************************region_id: 179rep_group_id: 1792data_obj_id: 256data_obj_type: BASE_TABLEstart_key: 00000100end_key: 00000101create_time: 2024-08-19 14:57:42.302908parent_region_id: 0region_stats_approximate_size: 1231749region_stats_approximate_keys: 11801 row in set (0.01 sec)
피드백