【问题描述】MySQL [oceanbase]> select sum(data_size)/1024/1024/1024,sum(required_size)/1024/1024/1024,svr_ip,svr_port from __all_virtual_meta_table where tenant_id=1001 group by svr_ip,svr_port;
proxy会把sql发到主上去执行,执行日志也需要在主上去看;可以通过select srv_ip,role from __all_virtual_meta_table where table_id=(select table_id from __all_virtual_table where table_name='xxx');查询主在哪里;
select sum(data_size)/1024/1024/1024,sum(required_size)/1024/1024/1024,svr_ip,svr_port from __all_virtual_meta_table where tenant_id=1001 group by svr_ip,svr_port;