查看 OceanBase 集群基本信息
通过命令行查询集群基本信息
连接集群
使用 root 用户登录 OceanBase 集群的 sys 租户。
obclient -h127.0.0.1 -P2883 -uroot@sys#obcluster -Doceanbase -A
查看集群默认创建的 Zone 信息
查看集群的 Zone 信息，可以查询 oceanbase.DBA_OB_ZONES 视图。
SELECT * FROM oceanbase.DBA_OB_ZONES;
从查询结果可以看到，创建的 OceanBase 集群，有 3 个 Zone，都是读写类型的可用状态。
obclient(root@sys)[oceanbase]> SELECT * FROM oceanbase.DBA_OB_ZONES;
+-------+----------------------------+----------------------------+--------+------+----------------+-----------+
| ZONE | CREATE_TIME | MODIFY_TIME | STATUS | IDC | REGION | TYPE |
+-------+----------------------------+----------------------------+--------+------+----------------+-----------+
| zone1 | 2025-06-16 17:12:21.089517 | 2025-06-16 17:12:21.089517 | ACTIVE | | default_region | ReadWrite |
| zone2 | 2025-06-16 17:12:21.089517 | 2025-06-16 17:12:21.089517 | ACTIVE | | default_region | ReadWrite |
| zone3 | 2025-06-16 17:12:21.089517 | 2025-06-16 17:12:21.089517 | ACTIVE | | default_region | ReadWrite |
+-------+----------------------------+----------------------------+--------+------+----------------+-----------+
3 rows in set (0.095 sec)
查看默认的节点
查看完 Zone 再来查看下默认创建的节点信息，可以通过查询 oceanbase.DBA_OB_SERVERS 视图，获取集群中的节点信息。
SELECT * FROM oceanbase.DBA_OB_SERVERS;
从查询结果看，该集群有 3 个节点，SQL_PORT 为 2881，SVR_PORT 为 2882，3 个节点都是 ACTIVE 状态。
obclient(root@sys)[oceanbase]> SELECT * FROM oceanbase.DBA_OB_SERVERS;
+--------------+----------+------+-------+----------+-----------------+--------+----------------------------+-----------+-----------------------+----------------------------+----------------------------+-------------------------------------------------------------------------------------------+-------------------+
| SVR_IP | SVR_PORT | ID | ZONE | SQL_PORT | WITH_ROOTSERVER | STATUS | START_SERVICE_TIME | STOP_TIME | BLOCK_MIGRATE_IN_TIME | CREATE_TIME | MODIFY_TIME | BUILD_VERSION | LAST_OFFLINE_TIME |
+--------------+----------+------+-------+----------+-----------------+--------+----------------------------+-----------+-----------------------+----------------------------+----------------------------+-------------------------------------------------------------------------------------------+-------------------+
| 10.43.139.79 | 2882 | 1 | zone1 | 2881 | NO | ACTIVE | 2025-09-18 14:18:44.272730 | NULL | NULL | 2025-06-16 17:12:21.573383 | 2025-09-18 14:18:45.051746 | 4.3.1.0_100030022024062419-5e9adb56815d345ed3abda33bdb13ac2538ddec2(Jun 24 2024 19:46:42) | NULL |
| 10.43.231.92 | 2882 | 3 | zone3 | 2881 | NO | ACTIVE | 2025-09-18 14:18:48.403398 | NULL | NULL | 2025-06-16 17:12:21.613945 | 2025-09-18 14:18:49.063845 | 4.3.1.0_100030022024062419-5e9adb56815d345ed3abda33bdb13ac2538ddec2(Jun 24 2024 19:46:42) | NULL |
| 10.43.51.60 | 2882 | 2 | zone2 | 2881 | YES | ACTIVE | 2025-09-18 14:18:43.219156 | NULL | NULL | 2025-06-16 17:12:21.604364 | 2025-09-18 14:18:45.054931 | 4.3.1.0_100030022024062419-5e9adb56815d345ed3abda33bdb13ac2538ddec2(Jun 24 2024 19:46:42) | NULL |
+--------------+----------+------+-------+----------+-----------------+--------+----------------------------+-----------+-----------------------+----------------------------+----------------------------+-------------------------------------------------------------------------------------------+-------------------+
3 rows in set (0.034 sec)
查看默认的资源信息
查看默认的资源池信息
可用使用 DBA_OB_RESOURCE_POOLS 视图，查看资源池信息。
SELECT * FROM oceanbase.DBA_OB_RESOURCE_POOLS;
从查询结果看，默认的资源池（RESOURCE_POOL_ID）名称是 sys_pool ，资源池的 ID（RESOURCE_POOL_ID）是 1，归属于的租户 ID（TENANT_ID）是 1、使用的资源规格 ID（UNIT_CONFIG_ID）是 1，资源池的 Unit 个数（UNIT_COUNT）是 1，可用 Zone 列表（ZONE_LIST）是 zone1;zone2;zone3，这意味着 3 个 Zone 的读写优先级是一致的。
obclient(root@sys)[oceanbase]> SELECT * FROM oceanbase.DBA_OB_RESOURCE_POOLS;
+------------------+----------+-----------+----------------------------+----------------------------+------------+----------------+-------------------+--------------+
| RESOURCE_POOL_ID | NAME | TENANT_ID | CREATE_TIME | MODIFY_TIME | UNIT_COUNT | UNIT_CONFIG_ID | ZONE_LIST | REPLICA_TYPE |
+------------------+----------+-----------+----------------------------+----------------------------+------------+----------------+-------------------+--------------+
| 1 | sys_pool | 1 | 2025-06-16 17:12:20.920342 | 2025-06-16 17:12:20.930196 | 1 | 1 | zone1;zone2;zone3 | FULL |
+------------------+----------+-----------+----------------------------+----------------------------+------------+----------------+-------------------+--------------+
1 row in set (0.045 sec)
查看默认的资源规格信息
查看资源规格信息
通过 DBA_OB_UNIT_CONFIGS 视图，可以查看资源规格信息。
SELECT * FROM DBA_OB_UNIT_CONFIGS;
从查询结果看，默认创建的资源规格（UNIT_CONFIG_ID）名称是 sys_unit_config ，资源规格 ID（UNIT_CONFIG_ID）是 1，CPU 规格上限（MAX_CPU）是 3C，内存规格（MEMORY_SIZE）是 2147483648/1024/1024/1024 = 2G，日志盘空间（LOG_DISK_SIZE）是 2147483648/1024/1024/1024 = 2G。
obclient(root@sys)[oceanbase]> SELECT * FROM DBA_OB_UNIT_CONFIGS;
+----------------+-----------------+----------------------------+----------------------------+---------+---------+-------------+---------------+---------------------+---------------------+-------------+
| UNIT_CONFIG_ID | NAME | CREATE_TIME | MODIFY_TIME | MAX_CPU | MIN_CPU | MEMORY_SIZE | LOG_DISK_SIZE | MAX_IOPS | MIN_IOPS | IOPS_WEIGHT |
+----------------+-----------------+----------------------------+----------------------------+---------+---------+-------------+---------------+---------------------+---------------------+-------------+
| 1 | sys_unit_config | 2025-06-16 17:12:20.916675 | 2025-06-16 17:12:20.916675 | 3 | 3 | 2147483648 | 2147483648 | 9223372036854775807 | 9223372036854775807 | 3 |
+----------------+-----------------+----------------------------+----------------------------+---------+---------+-------------+---------------+---------------------+---------------------+-------------+
1 row in set (0.008 sec)
查看节点的 Unit 信息
通过 GV$OB_UNITS 视图，也可以查看节点的 Unit 信息。
SELECT * FROM GV$OB_UNITS;
输出结果如下：
obclient(root@sys)[oceanbase]> SELECT * FROM GV$OB_UNITS;
+--------------+----------+---------+-----------+-------+-----------+----------------+---------+---------+-------------+---------------------+---------------------+-------------+---------------+-----------------+------------------+--------+----------------------------+
| SVR_IP | SVR_PORT | UNIT_ID | TENANT_ID | ZONE | ZONE_TYPE | REGION | MAX_CPU | MIN_CPU | MEMORY_SIZE | MAX_IOPS | MIN_IOPS | IOPS_WEIGHT | LOG_DISK_SIZE | LOG_DISK_IN_USE | DATA_DISK_IN_USE | STATUS | CREATE_TIME |
+--------------+----------+---------+-----------+-------+-----------+----------------+---------+---------+-------------+---------------------+---------------------+-------------+---------------+-----------------+------------------+--------+----------------------------+
| 10.43.51.60 | 2882 | 2 | 1 | zone2 | ReadWrite | default_region | 3 | 3 | 2147483648 | 9223372036854775807 | 9223372036854775807 | 3 | 2147483648 | 105593859 | 98304 | NORMAL | 2025-06-16 17:11:39.041296 |
| 10.43.139.79 | 2882 | 1 | 1 | zone1 | ReadWrite | default_region | 3 | 3 | 2147483648 | 9223372036854775807 | 9223372036854775807 | 3 | 2147483648 | 105593859 | 98304 | NORMAL | 2025-06-16 17:11:39.041214 |
| 10.43.231.92 | 2882 | 3 | 1 | zone3 | ReadWrite | default_region | 3 | 3 | 2147483648 | 9223372036854775807 | 9223372036854775807 | 3 | 2147483648 | 105593859 | 98304 | NORMAL | 2025-06-16 17:11:39.041234 |
+--------------+----------+---------+-----------+-------+-----------+----------------+---------+---------+-------------+---------------------+---------------------+-------------+---------------+-----------------+------------------+--------+----------------------------+
3 rows in set (0.011 sec)
查看资源分配信息
通过 GV$OB_SERVERS 视图，可以查看 OBServer 的信息。
SELECT * FROM GV$OB_SERVERS;
以第一行数据来看，节点 IP（SVR_IP）是 10.43.51.60 ，服务器端口号（SVR_PORT）是 2882，对应的 zone 名称（zone）是 zone2，SQL 端口（SQL_PORT）是 2881，observer 进程可用的 CPU 数量（CPU_CAPACITY）是 16C，observer 进程可用的内存（MEM_CAPACITY）是 8589934592/1024/1024/1024 =8G，已分配的内存（MEM_ASSIGNED）是 2147483648/1024/1024/1024 = 2G，日志盘总空间（LOG_DISK_CAPACITY）为 30064771072/1024/1024/1024 = 28G，已分配日志盘空间（LOG_DISK_ASSIGNED）是 2147483648/1024/1024/1024 = 2G，日志盘已使用（LOG_DISK_IN_USE） 134217728/1024/1024 = 128M，数据盘空间（DATA_DISK_CAPACITY）30064771072/1024/1024/1024 = 28G，数据盘已使用（DATA_DISK_IN_USE） 16777216/1024/1024 = 16M。
obclient(root@sys)[oceanbase]> SELECT * FROM GV$OB_SERVERS;
+--------------+----------+-------+----------+--------------+------------------+--------------+------------------+--------------+--------------+-------------------+-------------------+-----------------+--------------------+------------------+-------------------------+--------------+---------------------+-------------------------+-----------------------+
| SVR_IP | SVR_PORT | ZONE | SQL_PORT | 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 | MEMORY_LIMIT | DATA_DISK_ALLOCATED | DATA_DISK_ABNORMAL_TIME | SSL_CERT_EXPIRED_TIME |
+--------------+----------+-------+----------+--------------+------------------+--------------+------------------+--------------+--------------+-------------------+-------------------+-----------------+--------------------+------------------+-------------------------+--------------+---------------------+-------------------------+-----------------------+
| 10.43.51.60 | 2882 | zone2 | 2881 | 16 | 16 | 3 | 3 | 8589934592 | 2147483648 | 30064771072 | 2147483648 | 134217728 | 30064771072 | 16777216 | NORMAL | 9663676416 | 6442450944 | NULL | NULL |
| 10.43.139.79 | 2882 | zone1 | 2881 | 16 | 16 | 3 | 3 | 8589934592 | 2147483648 | 30064771072 | 2147483648 | 134217728 | 30064771072 | 16777216 | NORMAL | 9663676416 | 6442450944 | NULL | NULL |
| 10.43.231.92 | 2882 | zone3 | 2881 | 16 | 16 | 3 | 3 | 8589934592 | 2147483648 | 30064771072 | 2147483648 | 134217728 | 30064771072 | 16777216 | NORMAL | 9663676416 | 6442450944 | NULL | NULL |
+--------------+----------+-------+----------+--------------+------------------+--------------+------------------+--------------+--------------+-------------------+-------------------+-----------------+--------------------+------------------+-------------------------+--------------+---------------------+-------------------------+-----------------------+
3 rows in set (0.010 sec)
查询 Unit 列表
可以通过如下 SQL，查询当前集群的 unit 对应的租户、所在的主机等更详细的信息。
SELECT
/*+ QUERY_TIMEOUT(5000000) */
t1.UNIT_ID,
t1.RESOURCE_POOL_ID,
t1.ZONE,
t1.SVR_IP,
t1.SVR_PORT,
t1.STATUS,
t2.REPLICA_TYPE,
t2.TENANT_ID,
t3.TENANT_NAME,
t2.NAME AS RESOURCE_POOL_NAME,
t1.MIGRATE_FROM_SVR_IP,
t1.MIGRATE_FROM_SVR_PORT,
t1.MANUAL_MIGRATE
FROM
oceanbase.DBA_OB_UNITS AS t1
JOIN oceanbase.DBA_OB_RESOURCE_POOLS AS t2 ON t1.RESOURCE_POOL_ID = t2.RESOURCE_POOL_ID
JOIN oceanbase.DBA_OB_TENANTS t3 ON t2.TENANT_ID = t3.TENANT_ID;
输出结果如下：
+---------+------------------+-------+--------------+----------+--------+--------------+-----------+-------------+--------------------+---------------------+-----------------------+----------------+
| UNIT_ID | RESOURCE_POOL_ID | ZONE | SVR_IP | SVR_PORT | STATUS | REPLICA_TYPE | TENANT_ID | TENANT_NAME | RESOURCE_POOL_NAME | MIGRATE_FROM_SVR_IP | MIGRATE_FROM_SVR_PORT | MANUAL_MIGRATE |
+---------+------------------+-------+--------------+----------+--------+--------------+-----------+-------------+--------------------+---------------------+-----------------------+----------------+
| 1 | 1 | zone1 | 10.43.139.79 | 2882 | ACTIVE | FULL | 1 | sys | sys_pool | NULL | NULL | NULL |
| 2 | 1 | zone2 | 10.43.51.60 | 2882 | ACTIVE | FULL | 1 | sys | sys_pool | NULL | NULL | NULL |
| 3 | 1 | zone3 | 10.43.231.92 | 2882 | ACTIVE | FULL | 1 | sys | sys_pool | NULL | NULL | NULL |
+---------+------------------+-------+--------------+----------+--------+--------------+-----------+-------------+--------------------+---------------------+-----------------------+----------------+
3 rows in set (0.044 sec)
查看默认的租户信息
查看租户信息
通过 DBA_OB_TENANTS 视图，可以查看租户信息。
SELECT * FROM DBA_OB_TENANTS;
从查询结果看，默认创建的租户名称（TENANT_NAME ）是 sys，租户 ID（TENANT_ID ）是 1，租户类型（TENANT_TYPE）是 SYS 租户，租户的 PRIMARY_ZONE（PRIMARY_ZONE ）是 RANDOM ，租户副本分布（LOCALITY）在 FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 ，兼容模式（COMPATIBILITY_MODE）是 MySQL，即默认创建的 SYS 租户为 MySQL 模式。
+-----------+-------------+-------------+----------------------------+----------------------------+--------------+---------------------------------------------+-------------------+--------------------+--------+---------------+--------+-------------+-------------------+------------------+----------+----------------+--------------+--------------------+--------------+----------------------------+----------+------------+-----------+
| TENANT_ID | TENANT_NAME | TENANT_TYPE | CREATE_TIME | MODIFY_TIME | PRIMARY_ZONE | LOCALITY | PREVIOUS_LOCALITY | COMPATIBILITY_MODE | STATUS | IN_RECYCLEBIN | LOCKED | TENANT_ROLE | SWITCHOVER_STATUS | SWITCHOVER_EPOCH | SYNC_SCN | REPLAYABLE_SCN | READABLE_SCN | RECOVERY_UNTIL_SCN | LOG_MODE | ARBITRATION_SERVICE_STATUS | UNIT_NUM | COMPATIBLE | MAX_LS_ID |
+-----------+-------------+-------------+----------------------------+----------------------------+--------------+---------------------------------------------+-------------------+--------------------+--------+---------------+--------+-------------+-------------------+------------------+----------+----------------+--------------+--------------------+--------------+----------------------------+----------+------------+-----------+
| 1 | sys | SYS | 2025-06-16 17:12:20.944405 | 2025-06-16 17:12:20.944405 | RANDOM | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | NULL | MYSQL | NORMAL | NO | NO | PRIMARY | NORMAL | 0 | NULL | NULL | NULL | NULL | NOARCHIVELOG | DISABLED | 1 | 4.3.1.0 | 1 |
+-----------+-------------+-------------+----------------------------+----------------------------+--------------+---------------------------------------------+-------------------+--------------------+--------+---------------+--------+-------------+-------------------+------------------+----------+----------------+--------------+--------------------+--------------+----------------------------+----------+------------+-----------+
1 row in set (0.040 sec)
查看租户的资源单元部署位置
通过以下语句，查看当前已创建租户资源单元所在设备 IP 信息。
SELECT a.TENANT_NAME,a.TENANT_ID,b.SVR_IP FROM DBA_OB_TENANTS a,GV$OB_UNITS b WHERE a.TENANT_ID=b.TENANT_ID;
从查询结果可以看出， SYS 租户对应的 ID 为 1。
+-------------+-----------+--------------+
| TENANT_NAME | TENANT_ID | SVR_IP |
+-------------+-----------+--------------+
| sys | 1 | 10.43.51.60 |
| sys | 1 | 10.43.231.92 |
| sys | 1 | 10.43.139.79 |
+-------------+-----------+--------------+
3 rows in set (0.012 sec)
查询数据库列表
可以通过如下 SQL，查询已存在的数据库的相关信息。
SELECT
o.CREATED AS GMT_CREATE,
o.OBJECT_ID AS DATABASE_ID,
d.DATABASE_NAME,
c.ID AS COLLATION_TYPE,
NULL AS PRIMARY_ZONE,
0 AS READ_ONLY
FROM
oceanbase.DBA_OB_DATABASES d
JOIN oceanbase.DBA_OBJECTS o
JOIN information_schema.collations c ON d.DATABASE_NAME = o.OBJECT_NAME
AND d.COLLATION = c.COLLATION_NAME
WHERE
o.OBJECT_TYPE = 'DATABASE';
输出结果如下：
+---------------------+-------------+--------------------+----------------+--------------+-----------+
| GMT_CREATE | DATABASE_ID | DATABASE_NAME | COLLATION_TYPE | PRIMARY_ZONE | READ_ONLY |
+---------------------+-------------+--------------------+----------------+--------------+-----------+
| 2025-06-16 17:12:21 | 201001 | oceanbase | 45 | NULL | 0 |
| 2025-06-16 17:12:21 | 201002 | information_schema | 45 | NULL | 0 |
| 2025-06-16 17:12:21 | 201003 | mysql | 45 | NULL | 0 |
| 2025-06-16 17:12:21 | 201004 | __recyclebin | 45 | NULL | 0 |
| 2025-06-16 17:12:21 | 201005 | __public | 45 | NULL | 0 |
| 2025-06-16 17:12:21 | 201006 | SYS | 45 | NULL | 0 |
| 2025-06-16 17:12:21 | 201007 | LBACSYS | 45 | NULL | 0 |
| 2025-06-16 17:12:21 | 201008 | ORAAUDITOR | 45 | NULL | 0 |
| 2025-06-16 17:12:21 | 500001 | test | 45 | NULL | 0 |
+---------------------+-------------+--------------------+----------------+--------------+-----------+
9 rows in set (0.068 sec)
查看租户白名单
可以看出，默认的租户白名单为 %。
SHOW VARIABLES LIKE 'ob_tcp_invited_nodes';
输出结果如下：
+----------------------+-------+
| Variable_name | Value |
+----------------------+-------+
| ob_tcp_invited_nodes | % |
+----------------------+-------+
1 row in set (0.004 sec)
查看租户系统变量
由于当前安装的是 OceanBase 数据库开源版，而开源版仅支持 MySQL 模式，故本文档仅提供 MySQL 模式下租户系统变量的查询方法。
查询Session 级别变量值
通过 INFORMATION_SCHEMA.SESSION_VARIABLES 视图查询 ob_query_timeout 的 Session 级别变量值。
SELECT * FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE VARIABLE_NAME = 'ob_query_timeout';
输出结果如下：
+------------------+----------------+
| VARIABLE_NAME | VARIABLE_VALUE |
+------------------+----------------+
| ob_query_timeout | 10000000 |
+------------------+----------------+
1 row in set (0.004 sec)
查询 Global 级别变量值
通过 INFORMATION_SCHEMA.GLOBAL_VARIABLES 视图查询 ob_query_timeout 的 Global 级别变量值。
SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME = 'ob_query_timeout';
输出结果如下：
+------------------+----------------+
| VARIABLE_NAME | VARIABLE_VALUE |
+------------------+----------------+
| ob_query_timeout | 10000000 |
+------------------+----------------+
1 row in set (0.005 sec)
查看集群配置项
通过 GV$OB_PARAMETERS 视图，查询集群的配置项。
SELECT * FROM GV$OB_PARAMETERS WHERE NAME LIKE '%syslog_level%';
输出结果如下：
+--------------+----------+-------+---------+-----------+--------------+-----------+-------+------------------------------------------------------------------------------------------------------------------------------+----------+-------------------+---------------+-----------+
| SVR_IP | SVR_PORT | ZONE | SCOPE | TENANT_ID | NAME | DATA_TYPE | VALUE | INFO | SECTION | EDIT_LEVEL | DEFAULT_VALUE | ISDEFAULT |
+--------------+----------+-------+---------+-----------+--------------+-----------+-------+------------------------------------------------------------------------------------------------------------------------------+----------+-------------------+---------------+-----------+
| 10.43.51.60 | 2882 | zone2 | CLUSTER | NULL | syslog_level | STRING | WDIAG | specifies the current level of logging. There are DEBUG, TRACE, WDIAG, EDIAG, INFO, WARN, ERROR, seven different log levels. | OBSERVER | DYNAMIC_EFFECTIVE | WDIAG | YES |
| 10.43.231.92 | 2882 | zone3 | CLUSTER | NULL | syslog_level | STRING | WDIAG | specifies the current level of logging. There are DEBUG, TRACE, WDIAG, EDIAG, INFO, WARN, ERROR, seven different log levels. | OBSERVER | DYNAMIC_EFFECTIVE | WDIAG | YES |
| 10.43.139.79 | 2882 | zone1 | CLUSTER | NULL | syslog_level | STRING | WDIAG | specifies the current level of logging. There are DEBUG, TRACE, WDIAG, EDIAG, INFO, WARN, ERROR, seven different log levels. | OBSERVER | DYNAMIC_EFFECTIVE | WDIAG | YES |
+--------------+----------+-------+---------+-----------+--------------+-----------+-------+------------------------------------------------------------------------------------------------------------------------------+----------+-------------------+---------------+-----------+
3 rows in set (0.007 sec)