确定TiDB的某个表都在哪些store上

-- 注意，以下查询会被转换为调用PD API来获取信息，会导致PD的内存短时间急剧增高。
SELECT
    p.STORE_ID, count(1)
FROM 
    INFORMATION_SCHEMA.TIKV_REGION_STATUS s JOIN 
    INFORMATION_SCHEMA.TIKV_REGION_PEERS p ON s.REGION_ID = p.REGION_ID
WHERE
    s.DB_NAME = "ying99_asset" AND
    s.TABLE_NAME = "pre_asset_fund"
GROUP BY p.STORE_ID;

-- 观察某些表的Leader 分布是否均匀。
SELECT     p.STORE_ID, count(1) FROM      INFORMATION_SCHEMA.TIKV_REGION_STATUS s JOIN      INFORMATION_SCHEMA.TIKV_REGION_PEERS p ON s.REGION_ID = p.REGION_ID WHERE     s.DB_NAME = "ying99_asset" AND     s.TABLE_NAME = "pre_asset_ca_gbc_fof_tmp" and p.IS_LEADER=1 GROUP BY p.STORE_ID;


mysql> select * from TIKV_STORE_STATUS limit 1\G
*************************** 1. row ***************************
         STORE_ID: 13185607
          ADDRESS: 172.18.251.247:20160
      STORE_STATE: 0
 STORE_STATE_NAME: Up
            LABEL: [{"key": "disk", "value": "dw-ssd"}, {"key": "zone", "value": "cn-shenzhen"}, {"key": "host", "value": "prod-dw-tikv6-dw-f002"}, {"key": "dc", "value": "cn-shenzhen-f"}]
          VERSION: 7.5.1
         CAPACITY: 1.745TiB
        AVAILABLE: 402GiB
     LEADER_COUNT: 39377
    LEADER_WEIGHT: 1
     LEADER_SCORE: 39377
      LEADER_SIZE: 38325
     REGION_COUNT: 118162
    REGION_WEIGHT: 1
     REGION_SCORE: 219724.8377096983
      REGION_SIZE: 168706
         START_TS: 2024-03-10 22:03:25
LAST_HEARTBEAT_TS: 2024-03-19 16:11:12
           UPTIME: 210h7m47.168476671s
1 row in set (0.02 sec)


mysql> select * from TIKV_REGION_PEERS limit 1\G
*************************** 1. row ***************************
   REGION_ID: 711049
     PEER_ID: 3443709008
    STORE_ID: 3441543994
  IS_LEARNER: 0
   IS_LEADER: 1
      STATUS: NORMAL
DOWN_SECONDS: NULL
1 row in set (25.87 sec)


mysql> select * from TIKV_REGION_status limit 1\G
*************************** 1. row ***************************
                REGION_ID: 8173629725
                START_KEY: 748000000000000FFF795F698000000000FF000003010E290E29FF0E290E31FF000000FF0000000000F70380FF000000001B523A04FF19A9FA0000000000FF03889032BAF1C000FFED00000000000000F8
                  END_KEY: 748000000000000FFF795F698000000000FF000003010E290E29FF0E290E31FF000000FF0000000000F70380FF000000001B674E04FF19AE7A0000000000FF038B2B1A130A8000FF7900000000000000F8
                 TABLE_ID: 3961
                  DB_NAME: ying99_asset3
               TABLE_NAME: asset_fund_month
                 IS_INDEX: 1
                 INDEX_ID: 3
               INDEX_NAME: idx_acc_2
             IS_PARTITION: 0
             PARTITION_ID: NULL
           PARTITION_NAME: NULL
           EPOCH_CONF_VER: 131
            EPOCH_VERSION: 1635
            WRITTEN_BYTES: 297
               READ_BYTES: 0
         APPROXIMATE_SIZE: 110
         APPROXIMATE_KEYS: 862947
  REPLICATIONSTATUS_STATE: NULL
REPLICATIONSTATUS_STATEID: NULL
1 row in set (27.36 sec)