tencent cloud

TDSQL Boundless

DocumentaçãoTDSQL BoundlessGeneral ReferenceSQL ReferenceData DictionaryINFORMATION_SCHEMAMETA_CLUSTER_REGIONS

META_CLUSTER_REGIONS

PDF
Modo Foco
Tamanho da Fonte
Última atualização: 2026-02-10 11:06:29

Function

INFORMATION_SCHEMA.META_CLUSTER_REGIONS is used to store and display metadata related to data shards (Region) within the instance.

Field Description

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.

Examples

tdsql>select * from information_schema.meta_cluster_regions where region_id=179\\G
*************************** 1. row ***************************
                    region_id: 179
                 rep_group_id: 1792
                  data_obj_id: 256
                data_obj_type: BASE_TABLE
                    start_key: 00000100
                      end_key: 00000101
                  create_time: 2024-08-19 14:57:42.302908
             parent_region_id: 0
region_stats_approximate_size: 1231749
region_stats_approximate_keys: 1180
1 row in set (0.01 sec)
Anterior: META_CLUSTER_NODESPróximo: META_CLUSTER_REPLICAS

Ajuda e Suporte

Esta página foi útil?

comentários