select tenant_name, resource_pool_name, zone, svr_ip, svr_port, max_cpu, round(max_memory/1024/1024/1024) max_mem_gb,round(min_memory/1024/1024/1024) min_mem_gb from gv$unit
where tenant_id=1006
;
如果租户内存不大,或者sql文本实在太长,需要调整租户的sql工作内存。
MySQL [oceanbase]> show global variables like '%area%';
+-----------------------------+-------+
| Variable_name | Value |
+-----------------------------+-------+| ob_sql_work_area_percentage | 5 |
+-----------------------------+-------+
1 row in set (0.047 sec)
MySQL [oceanbase]> set global ob_sql_work_area_percentage=30;