新部署的oceanbase集群 资源都去哪里了？

OceanBase 技术问题
#1

oceanbase v421
新部署oceanbase集群，只有sys租户

image
image754×389 9.09 KB

但是 已经分配出去4Core和5G内存，这个资源应该是分配给sys的管理租户，如何证实呢？

#3

@论坛小助手

#4

新部署的 OceanBase 集群中，系统资源（包括 CPU 和内存）已经被系统租户（sys）占用。这是因为系统租户用于管理集群的内部表和执行系统管理任务。您可以使用如下 SQL 查询来验证资源的分配情况：

SELECT a.tenant_name,a.tenant_id,b.name unit_config,c.name pool_name,b.max_cpu,b.min_cpu
FROM
OCEANBASE.DBA_OB_TENANTS a,
OCEANBASE.DBA_OB_UNIT_CONFIGS b,
OCEANBASE.DBA_OB_RESOURCE_POOLS c
WHERE a.tenant_id=c.tenant_id
AND b.unit_config_id = c.unit_config_id
ORDER BY a.tenant_id desc;

此外，从 V4.2.1 版本开始，系统租户实际可使用的内存上限为 hidden_sys_memory + sys_unit_config.memory_size。您可以使用以下 SQL 查看系统租户的详细资源配置：

ALTER SYSTEM SHOW PARAMETERS LIKE '_hidden_sys_tenant_memory';

通过上述 SQL 语句，您可以确认系统租户（sys）已经分配了 4 Core 和 5G 内存。

检索到的文档如下:

  1. SYS 租户/RS 服务问题
  2. 租户内部内存管理
#5

查看sys租户的unit规格看看多大

#6 
mysql> select * from DBA_OB_UNIT_CONFIGS;
+----------------+-----------------+----------------------------+----------------------------+---------+---------+-------------+---------------+---------------------+---------------------+-------------+
| UNIT_CONFIG_ID | NAME            | CREATE_TIME                | MODIFY_TIME                | MAX_CPU | MIN_CPU | MEMORY_SIZE | LOG_DISK_SIZE | MAX_IOPS            | MIN_IOPS            | IOPS_WEIGHT |
+----------------+-----------------+----------------------------+----------------------------+---------+---------+-------------+---------------+---------------------+---------------------+-------------+
|              1 | sys_unit_config | 2025-07-11 16:45:32.453131 | 2025-07-11 16:45:32.453131 |       4 |       4 |  5368709120 |   13421772800 | 9223372036854775807 | 9223372036854775807 |           4 |
+----------------+-----------------+----------------------------+----------------------------+---------+---------+-------------+---------------+---------------------+---------------------+-------------+
1 row in set (0.00 sec)

mysql> select * from DBA_OB_RESOURCE_POOLS;
+------------------+----------+-----------+----------------------------+----------------------------+------------+----------------+-------------------+--------------+
| RESOURCE_POOL_ID | NAME     | TENANT_ID | CREATE_TIME                | MODIFY_TIME                | UNIT_COUNT | UNIT_CONFIG_ID | ZONE_LIST         | REPLICA_TYPE |
+------------------+----------+-----------+----------------------------+----------------------------+------------+----------------+-------------------+--------------+
|                1 | sys_pool |         1 | 2025-07-11 16:45:32.456351 | 2025-07-11 16:45:32.464322 |          1 |              1 | zone1;zone2;zone3 | FULL         |
+------------------+----------+-----------+----------------------------+----------------------------+------------+----------------+-------------------+--------------+
1 row in set (0.00 sec)

_打头的隐藏参数是不能show查看到，只能用语句：

mysql> select * from gv$ob_parameters where name ='_hidden_sys_tenant_memory'\G
*************************** 1. row ***************************
    SVR_IP: 10.xxxxxx
  SVR_PORT: 2882
      ZONE: zone2
     SCOPE: CLUSTER
 TENANT_ID: NULL
      NAME: _hidden_sys_tenant_memory
 DATA_TYPE: NULL
     VALUE: 0M
      INFO: the size of the memory reserved for hidden sys tenant, 0M means follow the adjusting value.
   SECTION: TENANT
EDIT_LEVEL: DYNAMIC_EFFECTIVE
#7

给sys租户了。ocp上租户概览那就可以看到