功能
INFORMATION_SCHEMA.META_CLUSTER_TABLE_LOCATION用于展示表的物理数据分布,具体指展示某张表分布的 RepGroup/Region, 以及 leader 节点名,IP 地址。字段说明
字段名 | 类型 | 描述 |
schema_name | varchar(64) | 库名 |
table_name | varchar(64) | 表名 |
region_id | bigint unsigned | region ID |
rep_group_id | bigint unsigned | RepGroup ID |
leader_node_name | varchar(64) | leader 节点名 |
sql_addr | varchar(64) | IP Port 地址 |
示例
tdsql > SELECT * FROM information_schema.META_CLUSTER_TABLE_LOCATION WHERE table_name="sbtest1" LIMIT 1\\G*************************** 1. row ***************************schema_name: test_indextable_name: sbtest1region_id: 77180rep_group_id: 70164leader_node_name: node-***-004sql_addr: ***.***.***.***:****1 row in set (0.23 sec)