首批通过分布式安全可靠测评,为关键业务系统打造
检查集群资源使用状态
更新时间:2024-11-13 23:00:00
通过 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)