FROM oceanbase.__all_tenant AS a JOIN oceanbase.__all_virtual_database AS d ON (a.tenant_id = d.tenant_id) JOIN oceanbase.__all_virtual_table AS t ON (t.tenant_id = d.tenant_id AND t.database_id = d.database_id) JOIN oceanbase.__all_virtual_meta_table t2 ON (t.tenant_id = t2.tenant_id AND (t.table_id=t2.table_id OR t.tablegroup_id=t2.table_id) AND t2.ROLE IN (1))
WHERE a.tenant_id IN (‘1001’) AND t.table_type IN (3) AND d.database_name = ‘tpcc_100’ AND t.table_name IN(‘bmsql_oorder’, ‘bmsql_order_line’)
ORDER BY t.tenant_id, d.database_name, t.table_name, t2.partition_id;
select svr_ip, store_type, major_version, count(1),sum(row_count), round(sum(occupy_size)/1024/1024,0) as occupy_size_MB from __all_virtual_storage_stat where table_id in (select table_id from __all_virtual_table where table_name = 'lineitem3') group by store_type, svr_ip, major_version;
select svr_ip, store_type, major_version, count(1),sum(row_count), round(sum(occupy_size)/1024/1024,0) as occupy_size_MB from __all_virtual_storage_stat where table_id in (select table_id from __all_virtual_table where table_name = 'lineitem3') group by store_type, svr_ip, major_version;