memory_limit更改的是12G为啥显示11G

OceanBase 技术问题
#1

memory_limit更改的是12G为啥显示11G

image
image1085×306 77.3 KB

1 个赞
#2

+1

#3

1.集群的拓扑结构，OB的版本 发下？
2.这个监控是什么工具？
3.这个SQL在sys租户查下

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_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 gv$ob_servers a
join oceanbase.DBA_OB_SERVERS b on a.zone=b.zone\G;
#4

OceanBase DBA 实战营(第二季) 中 开箱即用的运维工具 obshell / OB-Dashboard 在线实训环境

#5

4.x有每个租户都用内部对应的Meta 租户，会占用1G内存。

  • 可以看看监控是不是用的GV$OB_UNITS视图，这个是分开计算的，也就是应该是11G+1G(meta)
  • 如果查这个DBA_OB_UNITS视图则是合并计算的。应该查出来是12G
#6

应该是计算方式的问题，是除以1000还是1024的区别吧

#7

好的，可以查下上面那个SQL看下