SELECT b.DB_NAME
,b.TABLE_NAME
,b.INDEX_NAME
,c.STORE_ID
,a.ADDRESS
,COUNT(b.REGION_ID
) FROM INFORMATION_SCHEMA.TIKV_STORE_STATUS
a ,INFORMATION_SCHEMA.TIKV_REGION_STATUS
b,INFORMATION_SCHEMA.TIKV_REGION_PEERS
c
WHERE a.STORE_ID
=c.STORE_ID
AND b.REGION_ID
=c.REGION_ID
AND c.IS_LEADER
=‘1’
AND b.DB_NAME
=‘sbtest’
AND b.TABLE_NAME
=‘sbtest2’
GROUP BY b.DB_NAME
,b.TABLE_NAME
,b.INDEX_NAME
,c.STORE_ID
,a.ADDRESS
ORDER BY 1,2,3,4;
用这个sql查一下也行。