主集群查下regions到底哪个对象占用了,我遇到表分析历史数据占用几百G的问题,sql如下
select DB_NAME,TABLE_NAME,sum(APPROXIMATE_SIZE) from
(
select t.DB_NAME,t.TABLE_NAME,region_id,t.APPROXIMATE_SIZE from information_schema.TIKV_REGION_STATUS t
group by t.DB_NAMe,t.TABLE_NAME,region_id,t.APPROXIMATE_SIZE
) a
group by DB_NAME,TABLE_NAME
order by 3 desc