暂无图片
oceanbase express查看集群总览,为什么observer的磁盘大小只有8G
我来答
分享
暂无图片 匿名用户
oceanbase express查看集群总览,为什么observer的磁盘大小只有8G

1212

我来答
添加附件
收藏
分享
问题补充
1条回答
默认
最新
O
OceanBase社区传送门

这里代表的数据目录的大小,可以用SQL查一下,其中的data_disk_gb
select a.zone,
a.SVR_IP,
a.SVR_PORT,
b.status,
cpu_capacity,
cpu_assigned_max,
cpu_capacity-cpu_assigned_max as cpu_free,
round((memory_limit-mem_capacity)/1024/1024/1024,2) as system_memory_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 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
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏