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 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 |
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)
피드백