tencent cloud

TDSQL Boundless

DocumentaçãoTDSQL BoundlessGeneral ReferenceSQL ReferenceData DictionaryINFORMATION_SCHEMAMETA_CLUSTER_TABLE_LOCATION

META_CLUSTER_TABLE_LOCATION

Baixar
Modo Foco
Tamanho da Fonte
Última atualização: 2026-05-26 15:18:26

Function

INFORMATION_SCHEMA.META_CLUSTER_TABLE_LOCATION displays the physical data distribution of tables, specifically showing the RepGroups/Regions where a table is distributed, along with the leader node name and IP address.

Field Description

Field Name
Type
Description
schema_name
varchar(64)
Database name
table_name
varchar(64)
Table Name
region_id
bigint unsigned
region ID
rep_group_id
bigint unsigned
RepGroup ID
leader_node_name
varchar(64)
leader node name
sql_addr
varchar(64)
IP address and Port address

Examples

tdsql > SELECT * FROM information_schema.META_CLUSTER_TABLE_LOCATION WHERE table_name="sbtest1" LIMIT 1\\G
*************************** 1. row ***************************
     schema_name: test_index
      table_name: sbtest1
       region_id: 77180
    rep_group_id: 70164
leader_node_name: node-***-004
        sql_addr: ***.***.***.***:****
1 row in set (0.23 sec)

Anterior: META_CLUSTER_STATUSPróximo: META_CLUSTER_TASKS

Ajuda e Suporte

Esta página foi útil?

comentários