暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

分布式数据库学习Note176:OceanBase社区版中,如何检查集群资源使用状态?

欢迎访问OceanBase官网获取更多信息:https://www.oceanbase.com/


通过 SQL 命令查看集群资源的使用情况

您可使用 sys 租户登录, 执行以下命令,查看集群资源的使用情况。

ob-sys 10.0.0.0 (root@oceanbase)>   SELECT * FROM GV$OB_SERVERS LIMIT 2;
+----------------+----------+-------+----------+--------------+--------------+------------------+--------------+------------------+--------------+--------------+-------------------+-------------------+-----------------+--------------------+------------------+-------------------------+-------------------------+
| SVR_IP         | SVR_PORT | ZONE  | SQL_PORT | CPU_RESERVED | CPU_CAPACITY | CPU_CAPACITY_MAX | CPU_ASSIGNED | CPU_ASSIGNED_MAX | MEM_CAPACITY | MEM_ASSIGNED | LOG_DISK_CAPACITY | LOG_DISK_ASSIGNED | LOG_DISK_IN_USE | DATA_DISK_CAPACITY | DATA_DISK_IN_USE | DATA_DISK_HEALTH_STATUS | DATA_DISK_ABNORMAL_TIME |
+----------------+----------+-------+----------+--------------+--------------+------------------+--------------+------------------+--------------+--------------+-------------------+-------------------+-----------------+--------------------+------------------+-------------------------+-------------------------+
| 172.30.xxx.xxx |     288x | zone1 |     2881 |            2 |           62 |               62 |          4.5 |              4.5 |  75161927680 |  30064771072 |      179583320064 |       55834574848 |     15703474176 |       107374182400 |       8380219392 | NORMAL                  | NULL                    |
+----------------+----------+-------+----------+--------------+--------------+------------------+--------------+------------------+--------------+--------------+-------------------+-------------------+-----------------+--------------------+------------------+-------------------------+-------------------------+
1 row in set (0.01 sec)


欢迎访问OceanBase官网获取更多信息:https://www.oceanbase.com/

「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论