寻找未被关联的unit

OceanBase 技术问题
#1

图片
图片753×633 37.9 KB

同学们，请教下，ZONE1有一个unit应该是没有释放，如何把它找出来 ？

版本信息是：

| Variable_name | Value |
±----------------±-----------------------------------------------------------------------------------------------------------------+
| version_comment | OceanBase_CE 4.5.0.0 (r100000012025112711-0e8d5ad012baf0953b2032a35a88bdf8886e9a7a) (Built Nov 27 2025 12:06:16) |
±----------------±-----------------------------------------------------------------------------------------------------------------+
1 row in set (0.01 sec)

#4

select zone,concat(SVR_IP,’:’,SVR_PORT) observer,
cpu_capacity_max cpu_total,cpu_assigned_max cpu_assigned,
cpu_capacity-cpu_assigned_max as cpu_free,
round(memory_limit/1024/1024/1024,2) as memory_total,
round((memory_limit-mem_capacity)/1024/1024/1024,2) as system_memory,
round(mem_assigned/1024/1024/1024,2) as mem_assigned,
round((mem_capacity-mem_assigned)/1024/1024/1024,2) as memory_free,
round(log_disk_capacity/1024/1024/1024,2) as log_disk_capacity,
round(log_disk_assigned/1024/1024/1024,2) as log_disk_assigned,
round((log_disk_capacity-log_disk_assigned)/1024/1024/1024,2) as log_disk_free,
round((data_disk_capacity/1024/1024/1024),2) as data_disk,
round((data_disk_in_use/1024/1024/1024),2) as data_disk_used,
round((data_disk_capacity-data_disk_in_use)/1024/1024/1024,2) as data_disk_free
from oceanbase.gv$ob_servers;
你查一下 这个信息 看看

#5

图片
图片1810×92 5.04 KB

#6

看到74这个节点的内存分配的多呀

image
image1864×97 10.3 KB

在查看一下 这个信息
select a.zone,a.svr_ip,b.tenant_name,b.tenant_type, a.max_cpu, a.min_cpu,
round(a.memory_size/1024/1024/1024,2) memory_size_gb,
round(a.log_disk_size/1024/1024/1024,2) log_disk_size,
round(a.log_disk_in_use/1024/1024/1024,2) log_disk_in_use,
round(a.data_disk_in_use/1024/1024/1024,2) data_disk_in_use
from oceanbase.gv$ob_units a join oceanbase.dba_ob_tenants b on a.tenant_id=b.tenant_id order by b.tenant_name;

#7

图片
图片1109×239 7.46 KB

#8 
SELECT c.TENANT_ID, e.TENANT_NAME, f.SVR_IP,concat(c.NAME, ': ', d.NAME)`pool:conf`,concat(c.UNIT_COUNT, ' unit: ', d.min_cpu, 'C/', ROUND(d.MEMORY_SIZE/1024/1024/1024,0), "G") unit_info FROM DBA_OB_RESOURCE_POOLS c, DBA_OB_UNIT_CONFIGS d, DBA_OB_TENANTS e ,DBA_OB_UNITS f WHERE c.UNIT_CONFIG_ID=d.UNIT_CONFIG_ID AND c.TENANT_ID=e.TENANT_ID AND e.TENANT_ID=f.TENANT_ID AND c.RESOURCE_POOL_ID=f.RESOURCE_POOL_ID ORDER BY c.TENANT_ID;

查一下这个

#9

图片

#11

查这个

SELECT  f.SVR_IP,concat(c.NAME, ': ', d.NAME)`pool:conf`,concat(c.UNIT_COUNT, ' unit: ', d.min_cpu, 'C/', ROUND(d.MEMORY_SIZE/1024/1024/1024,0), "G") unit_info FROM DBA_OB_RESOURCE_POOLS c, DBA_OB_UNIT_CONFIGS d, DBA_OB_UNITS f WHERE c.UNIT_CONFIG_ID=d.UNIT_CONFIG_ID  AND c.RESOURCE_POOL_ID=f.RESOURCE_POOL_ID;
#12

±---------------±----------------±---------------------------±---------------------------±--------±--------±------------±--------------±---------------±--------------------±--------------------±------------±--------------------±---------------------+
| UNIT_CONFIG_ID | NAME | CREATE_TIME | MODIFY_TIME | MAX_CPU | MIN_CPU | MEMORY_SIZE | LOG_DISK_SIZE | DATA_DISK_SIZE | MAX_IOPS | MIN_IOPS | IOPS_WEIGHT | MAX_NET_BANDWIDTH | NET_BANDWIDTH_WEIGHT |
±---------------±----------------±---------------------------±---------------------------±--------±--------±------------±--------------±---------------±--------------------±--------------------±------------±--------------------±---------------------+
| 1 | sys_unit_config | 2025-12-30 14:36:39.814073 | 2025-12-30 14:36:39.814073 | 3 | 3 | 1073741824 | 4294967296 | NULL | 9223372036854775807 | 9223372036854775807 | 3 | 9223372036854775807 | 3 |
| 1001 | unit_4c8g | 2025-12-30 14:42:24.309825 | 2025-12-30 14:42:24.309825 | 4 | 4 | 8589934592 | 25769803776 | NULL | 10000 | 10000 | 4 | 9223372036854775807 | 4 |
±---------------±----------------±---------------------------±---------------------------±--------±--------±------------±--------------±---------------±--------------------±--------------------±------------±--------------------±--------------

#13

图片
图片1545×121 5.27 KB

#14

图片

#15

SELECT c.TENANT_ID, concat(c.NAME, ': ', d.NAME) pool:conf,concat(c.UNIT_COUNT, ’ unit: ', d.min_cpu, ‘C/’, ROUND(d.MEMORY_SIZE/1024/1024/1024,0), “G”) unit_info
FROM DBA_OB_RESOURCE_POOLS c, DBA_OB_UNIT_CONFIGS d,
WHERE c.UNIT_CONFIG_ID=d.UNIT_CONFIG_ID;
这个查一下 看看信息

#16

图片

#17

– 可删除的资源池规格配置

SELECT * FROM oceanbase.__all_unit_config t1 LEFT JOIN oceanbase.__all_resource_pool t2 ON t1.unit_config_id = t2.unit_config_id WHERE t2.name IS NULL;

– 可删除的资源池

SELECT * FROM oceanbase.__all_resource_pool WHERE tenant_id = -1;

#18

图片

其实我什么都没有执行。 过了2小时，一切都正常了。

#19

谢谢

#20

之前有做过资源池的删除么？

#21

没有。 之前都是删租户就可以了。

#23

好的 后面观察一下吧 目前没有办法查根因了 已经恢复了

#24

谢谢