SELECT tenant_id FROM oceanbase.gv$tenant where tenant_name=‘ob_ora’;
#1001
use oceanbase;
select table_id, table_name from __all_virtual_table where tenant_id=1001 and table_name= upper(‘tab_no_queue’);
±-----------------±-------------+
| table_id | table_name |
±-----------------±-------------+
| 1100611139453777 | TAB_NO_QUEUE |
±-----------------±-------------+
1 row in set (0.003 sec)
select tenant.tenant_name,meta.table_id, tab.table_name,
partition_id,zone,svr_ip,svr_port, case when role=1 then ‘leader’ when role=2
then ‘follower’ else null end as role, tab.primary_zone from
__all_virtual_meta_table meta inner join __all_tenant tenant on
meta.tenant_id=tenant.tenant_id inner join __all_virtual_table tab on
meta.tenant_id=tab.tenant_id and meta.table_id=tab.table_id where
tenant.tenant_id=1001 and tab.table_name=‘TAB_NO_QUEUE’ order by
tenant.tenant_name,table_name,partition_id,zone;
登陆 sys 租户，查看 tab_no_queue 表在 memstore 的内存消耗情况， 关注 used_mb 字段值
select ip,table_id,partition_id,round(used/1024/1024,1) as
used_mb,hash_items,btree_items,is_active from gv$memstore_info where table_id = 1100611139453779;
查看表 的转储情况，确认没有转储
select * from gv$merge_info where table_id =1100611139453777 order by start_time desc limit 6;
select tenant.tenant_name,meta.table_id, tab.table_name,
partition_id,zone,svr_ip,svr_port, case when role=1 then ‘leader’ when role=2
then ‘follower’ else null end as role, tab.primary_zone from
__all_virtual_meta_table meta inner join __all_tenant tenant on
meta.tenant_id=tenant.tenant_id inner join __all_virtual_table tab on
meta.tenant_id=tab.tenant_id and meta.table_id=tab.table_id where
tenant.tenant_id=1001 and tab.table_name=‘TAB_QUEUE’ order by
tenant.tenant_name,table_name,partition_id,zone;
执行一次表和租户级别的转储， 避免以上插入操作的影响
ALTER SYSTEM MINOR FREEZE TENANT=(ob_ora);
确认转储结束
SELECT * FROM __all_zone WHERE name=‘merge_status’; --确认 merge_status 为‘IDLE‘状态，表明转储成功结束