sys租户调整内存报错

OceanBase 技术问题
#1

【 使用环境 】测试环境
【 OB or 其他组件 】OB
【 使用版本 】4.2.5
【问题描述】服务器内存512G，单节点OB，sys租户资源池当前内存是1G，想调整为16G报错
【复现路径】

image
image981×414 42.3 KB

#3

这几个信息 先查一下看看
– 1. 节点还能分多少内存（关键）
SELECT svr_ip, svr_port, zone,
ROUND(MEMORY_LIMIT/1024/1024/1024, 2) AS memory_limit_gb,
ROUND(MEM_CAPACITY/1024/1024/1024, 2) AS mem_capacity_gb,
ROUND(MEM_ASSIGNED/1024/1024/1024, 2) AS mem_assigned_gb,
ROUND((MEM_CAPACITY-MEM_ASSIGNED)/1024/1024/1024, 2) AS mem_free_gb
FROM oceanbase.GV$OB_SERVERS;

– 2. sys 租户实际占用 vs 上限
SELECT tenant_id,
ROUND(hold/1024/1024, 2) AS hold_mb,
ROUND(limit/1024/1024, 2) AS limit_mb
FROM oceanbase.GV$OB_TENANT_MEMORY_INFO
WHERE tenant_id = 1;

– 3. observer 参数
SHOW PARAMETERS LIKE ‘memory_limit’;
SHOW PARAMETERS LIKE ‘memory_limit_percentage’;
SHOW PARAMETERS LIKE ‘system_memory’;