Note
This view is available starting with V4.0.0.
Purpose
This view displays information about all OBServer nodes.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | The IP address of the server. |
| SVR_PORT | bigint(20) | NO | The port number of the server. |
| ZONE | varchar(128) | NO | The name of the zone. |
| SQL_PORT | bigint(20) | NO | The SQL port. |
| CPU_CAPACITY | bigint(20) | NO | The total CPU capacity of the node. |
| CPU_CAPACITY_MAX | double | NO | The oversold value of the total CPU capacity of the node. It is controlled by the resource_hard_limit parameter: CPU_CAPACITY_MAX = CPU_CAPACITY * resource_hard_limit |
| CPU_ASSIGNED | double | NO | The total number of CPU cores already allocated to the OBServer node. It is the sum of the MIN_CPU specifications of all units on the OBServer node. Constraint: CPU_ASSIGNED <= CPU_CAPACITY |
| CPU_ASSIGNED_MAX | double | NO | The upper limit of the CPU cores already allocated to the OBServer node. It is the sum of the MAX_CPU specifications of all units on the OBServer node. Constraint: CPU_ASSIGNED_MAX <= CPU_CAPACITY_MAX |
| MEM_CAPACITY | bigint(20) | NO | The total amount of memory available for allocation to tenants on the OBServer node, calculated as memory_limit - system_memory, in bytes. |
| MEM_ASSIGNED | bigint(20) | NO | The amount of memory already allocated to the OBServer node, which is the sum of the MEMORY_SIZE specifications of all units on the OBServer node, in bytes. Constraint: MEM_ASSIGNED <= MEM_CAPACITY |
| LOG_DISK_CAPACITY | bigint(20) | NO | The total size of the log disk space, in bytes. |
| LOG_DISK_ASSIGNED | bigint(20) | NO | The size of the log disk space already allocated, which is the sum of the LOG_DISK_SIZE specifications of all units on the OBServer node, in bytes. |
| LOG_DISK_IN_USE | bigint(20) | NO | The size of the log disk space already used, in bytes. |
| DATA_DISK_CAPACITY | bigint(20) | NO | The total size of the data disk space on the OBServer node, in bytes. |
| DATA_DISK_ASSIGNED | bigint(20) | YES | The value of this field is NULL, indicating that it is undefined and the unit can compete for disk space of other tenants. |
| DATA_DISK_IN_USE | bigint(20) | NO | The size of the data disk space already used on the OBServer node, in bytes. |
| DATA_DISK_HEALTH_STATUS | varchar(20) | NO | The health status of the data disk:
|
| MEMORY_LIMIT | bigint(20) | NO | The total amount of memory available on the OBServer node, in bytes. |
| DATA_DISK_ALLOCATED | bigint(20) | NO | The size of the data disk space already allocated to the OBServer node, in bytes
NoteThis column is available starting with V4.2.0. |
| DATA_DISK_ABNORMAL_TIME | timestamp(6) | NO | The last time when the data disk was in an abnormal state (WARNING or ERROR). |
| SSL_CERT_EXPIRED_TIME | timestamp(6) | NO | The time when the SSL certificate used by the current OBServer node expires, along with the UTC time, in microseconds. |
| SS_DATA_DISK_OPERATION_SUGGESTED | varchar(32) | YES | The value of this field is NULL. |
| SS_DATA_DISK_SIZE_SUGGESTED | bigint(20) | YES | The value of this field is NULL.
Note
|
Sample query
Query the information of all OBServer nodes.
obclient> SELECT * FROM oceanbase.GV$OB_SERVERS\G
The query result is as follows:
*************************** 1. row ***************************
SVR_IP: 172.xx.xxx.xxx
SVR_PORT: 2882
ZONE: zone1
SQL_PORT: 2881
CPU_CAPACITY: 64
CPU_CAPACITY_MAX: 64
CPU_ASSIGNED: 8
CPU_ASSIGNED_MAX: 8
MEM_CAPACITY: 75161927680
MEM_ASSIGNED: 18253611008
LOG_DISK_CAPACITY: 179583320064
LOG_DISK_ASSIGNED: 56103010304
LOG_DISK_IN_USE: 1140850688
DATA_DISK_CAPACITY: 179593805824
DATA_DISK_ASSIGNED: NULL
DATA_DISK_IN_USE: 174063616
DATA_DISK_HEALTH_STATUS: NORMAL
MEMORY_LIMIT: 107374182400
DATA_DISK_ALLOCATED: 179593805824
DATA_DISK_ABNORMAL_TIME: NULL
SSL_CERT_EXPIRED_TIME: NULL
SS_DATA_DISK_OPERATION_SUGGESTED: NULL
SS_DATA_DISK_SIZE_SUGGESTED: NULL
*************************** 2. row ***************************
SVR_IP: 172.xx.xxx.xxx
SVR_PORT: 2882
ZONE: zone2
SQL_PORT: 2881
CPU_CAPACITY: 64
CPU_CAPACITY_MAX: 64
CPU_ASSIGNED: 8
CPU_ASSIGNED_MAX: 8
MEM_CAPACITY: 75161927680
MEM_ASSIGNED: 18253611008
LOG_DISK_CAPACITY: 179583320064
LOG_DISK_ASSIGNED: 56103010304
LOG_DISK_IN_USE: 1140850688
DATA_DISK_CAPACITY: 179593805824
DATA_DISK_ASSIGNED: NULL
DATA_DISK_IN_USE: 174063616
DATA_DISK_HEALTH_STATUS: NORMAL
MEMORY_LIMIT: 107374182400
DATA_DISK_ALLOCATED: 179593805824
DATA_DISK_ABNORMAL_TIME: NULL
SSL_CERT_EXPIRED_TIME: NULL
SS_DATA_DISK_OPERATION_SUGGESTED: NULL
SS_DATA_DISK_SIZE_SUGGESTED: NULL
*************************** 3. row ***************************
SVR_IP: 172.xx.xxx.xxx
SVR_PORT: 2882
ZONE: zone3
SQL_PORT: 2881
CPU_CAPACITY: 64
CPU_CAPACITY_MAX: 64
CPU_ASSIGNED: 8
CPU_ASSIGNED_MAX: 8
MEM_CAPACITY: 75161927680
MEM_ASSIGNED: 18253611008
LOG_DISK_CAPACITY: 179583320064
LOG_DISK_ASSIGNED: 56103010304
LOG_DISK_IN_USE: 1140850688
DATA_DISK_CAPACITY: 179593805824
DATA_DISK_ASSIGNED: NULL
DATA_DISK_IN_USE: 174063616
DATA_DISK_HEALTH_STATUS: NORMAL
MEMORY_LIMIT: 107374182400
DATA_DISK_ALLOCATED: 179593805824
DATA_DISK_ABNORMAL_TIME: NULL
SSL_CERT_EXPIRED_TIME: NULL
SS_DATA_DISK_OPERATION_SUGGESTED: NULL
SS_DATA_DISK_SIZE_SUGGESTED: NULL
3 rows in set
References
Query the information of the current OBServer node: V$OB_SERVERS.
For more information about the operations and parameters of an OBServer node, see View an OBServer node.