1、怎么查看表、还有回收站中的表大小
2、怎么查看租户的回收站占用了多少空间
3、ocp上这几个租户已使用的数据盘加起来为啥不等于总的1.73，这里的已使用的数据盘还包括哪些？是动态刷新的吗？
查看某表单副本占用磁盘大小
SELECT sum(size)/1024/1024/1024 FROM (SELECT DATABASE_NAME,TABLE_NAME,TABLE_ID,PARTITION_NAME,TABLET_ID,ROLE
FROM oceanbase.DBA_OB_TABLE_LOCATIONS ) AA full join
(SELECT distinct(TABLET_ID) ,size
FROM oceanbase.GV$OB_SSTABLES ) BB on AA.TABLET_ID=BB.TABLET_ID
WHERE AA.role=‘leader’ and AA.table_name=’${表名}’;
统计租户的大小
SELECT t.tenant_name,
round(sum(t2.data_size)/1024/1024/1024,2) as data_size_gb,
round(sum(t2.required_size)/1024/1024/1024,2) as required_size_gb
FROM oceanbase.dba_ob_tenants t,oceanbase.cdb_ob_table_locations t1,cdb_ob_tablet_replicas t2
WHERE t.tenant_id=t1.tenant_id and t1.svr_ip=t2.svr_ip and t1.tenant_id=t2.tenant_id and t1.ls_id=t2.ls_id and t1.tablet_id=t2.tablet_id
group by t.tenant_name
order by 3 desc;
回收站中的表的大小
select vr.tenant_id, vr.object_name, vr.type, vr.gmt_create, vr.database_id, vr.table_id, vr.tablegroup_id, vr.original_name, sum(data_size) data_size
from __all_virtual_recyclebin vr
left join __all_virtual_table vt on vr.table_id = vt.table_id
left join cdb_ob_tablet_replicas tr on vt.tablet_id = tr.tablet_id
where vr.tenant_id = %s and vr.type = 1
group by table_id;
回收站中的库的大小
select vc.tenant_id, vc.object_name, vc.type, vc.gmt_create, vc.database_id, vc.table_id, vc.tablegroup_id, vc.original_name, round(sum(IFNULL(tr.data_size, 0)) / 1024 / 1024 / 1024, 2) data_size
from __all_virtual_recyclebin vc
left join __all_virtual_table t on vc.tenant_id = t.tenant_id and vc.database_id = t.database_id
left join cdb_ob_tablet_replicas tr on tr.tablet_id = t.tablet_id
where vc.tenant_id = %s and vc.type = 4
group by vc.database_id;
在leader节点上查看
我就一个节点
你这样先查一下 看看是否有信息
SELECT DATABASE_NAME,TABLE_NAME,TABLE_ID,PARTITION_NAME,TABLET_ID,ROLE
FROM oceanbase.DBA_OB_TABLE_LOCATIONS AA WHERE AA.role=‘leader’ and AA.table_name=’${表名}’;
第3个问题，OCP版本是什么？租户的加起来比下面的多了还是少了？差了多少？
