OceanBase管理数据库检查集群资源使用状态和检查OBServer状态

通过 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)

本文介绍了三种检查 OBServer 状态的方式，您可根据自身情况选择。

通过宿主机查看 OBServer 状态

1. 登录 OBServer 所在的宿主机。

2. 在命令行工具中运行以下命令查看 observer 进程。

   ps -ef |grep observer
   root       6136      0 99 11:23 ?        08:53:50 ./bin/observer
   root      20514  19521  0 16:09 pts/25   00:00:00 grep --color=auto observer
   

通过视图查看 OBServer 状态

obclient> SELECT status FROM oceanbase.DBA_OB_SERVERS;
+--------+
| status |
+--------+
| active |
| active |
+--------+
2 rows in set (0.00 sec)

• 如果返回结果为 active，说明 OBServer 处于正常运行状态。

• 如果返回结果为 inactive，说明 OBServer 处于下线状态。

• 如果返回结果为 deleting，说明 OBServer 处于正在被删除状态。