数据盘空间不对

[AntTech_NHY7X8]

【 使用环境 】测试环境
ob数据库版本：4.2.1.8 用于存放ocp的元数据库
ocp版本：版本号: 4.3.6-20250815135607

【问题描述】数据盘空间怎么计算出来的， 目前看显示不对呢？
【复现路径】

但是为何这里显示数据盘为28.16G呢？

[旭辉]

这个查一下

select /*+ READ_CONSISTENCY(WEAK) */
a.zone,
a.svr_ip,
b.status,
cpu_capacity,
cpu_assigned_max,
cpu_capacity-cpu_assigned_max as cpu_free,
round(memory_limit /1024/1024/1024 ,2) as memory_total_gb,
round(mem_capacity /1024/1024/1024 ,2) as mem_capacity,
round((memory_limit-mem_capacity) /1024/1024/1024 ,2) as system_memory_gb,
round(mem_assigned /1024/1024/1024 ,2) as mem_assigned_gb,
round((mem_capacity-mem_assigned) /1024/1024/1024 ,2) as memory_free_gb,
round(log_disk_capacity /1024/1024/1024 ,2) as log_disk_capacity_gb,
round(log_disk_assigned /1024/1024/1024 ,2) as log_disk_assigned_gb,
round((log_disk_capacity-log_disk_assigned) /1024/1024/1024 ,2) as log_disk_free_gb,
round((data_disk_capacity /1024/1024/1024 ),2) as data_disk_capacity_gb,
round((DATA_DISK_ALLOCATED /1024/1024/1024 ),2) as data_disk_allocate_gb,
round((data_disk_in_use /1024/1024/1024 ),2) as data_disk_used_gb,
round((data_disk_capacity-data_disk_in_use) /1024/1024/1024 ,2) as data_disk_free_gb
from oceanbase.gv$ob_servers a
join oceanbase.DBA_OB_SERVERS b on a.zone=b.zone\G;

[AntTech_NHY7X8]

@旭辉

select /*+ READ_CONSISTENCY(WEAK) */
a.zone,
a.svr_ip,
b.status,
cpu_capacity,
cpu_assigned_max,
cpu_capacity-cpu_assigned_max as cpu_free,
round(memory_limit /1024/1024/1024 ,2) as memory_total_gb,
round(mem_capacity /1024/1024/1024 ,2) as mem_capacity,
round((memory_limit-mem_capacity) /1024/1024/1024 ,2) as system_memory_gb,
round(mem_assigned /1024/1024/1024 ,2) as mem_assigned_gb,
round((mem_capacity-mem_assigned) /1024/1024/1024 ,2) as memory_free_gb,
round(log_disk_capacity /1024/1024/1024 ,2) as log_disk_capacity_gb,
round(log_disk_assigned /1024/1024/1024 ,2) as log_disk_assigned_gb,
round((log_disk_capacity-log_disk_assigned) /1024/1024/1024 ,2) as log_disk_free_gb,
round((data_disk_capacity /1024/1024/1024 ),2) as data_disk_capacity_gb,
round((DATA_DISK_ALLOCATED /1024/1024/1024 ),2) as data_disk_allocate_gb,
round((data_disk_in_use /1024/1024/1024 ),2) as data_disk_used_gb,
round((data_disk_capacity-data_disk_in_use) /1024/1024/1024 ,2) as data_disk_free_gb
from oceanbase.gv$ob_servers a
join oceanbase.DBA_OB_SERVERS b on a.zone=b.zone\G;

@旭辉

[旭辉]

分配了25GB，capacity是28.04GB

[AntTech_NHY7X8]

按照参数，初始化的时候是25G，然后datafile_next是5G，那这里不应该是30G吗？最大只能使用50G

[旭辉]

你这里可能是30G，可能被其它非OB的文件占用了一部分空间，剩余可用（空间能力）只有28.04G

[AntTech_NHY7X8]

这个不是预分配的吗？按理说预分配的后，这个磁盘，即使有其他的文件占用了一些空间，也不应该影响到这个值的