Note
This view was introduced in OceanBase Database V4.3.4.
Purpose
This view displays the I/O access resource information on all OBServer nodes.
Columns
| Columns | Type | Nullable? | Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | The IP address of the OBServer node. |
| SVR_PORT | bigint(20) | NO | The port of the OBServer node. |
| ENDPOINT | varchar(256) | NO | The endpoint of shared storage. This field is empty in a shared-nothing (SN) mode. |
| PATH | varchar(1024) | NO | The path in object storage. This field displays the local path in an SN mode. The path can be of the following types: local://, oss://, file://, and s3://. |
| CLASS_ID | bigint(20) | NO | The ID used for labeling. The meaning of this field varies depending on the purpose of the bucket in object storage:
|
| TYPE | varchar(32) | NO | The metric type, which can be one of the following types:
|
| REQUIREMENT | bigint(20) | NO | The required resources for the server. |
| ASSIGN | bigint(20) | NO | The upper limit of the resources specified for the server by the throttling algorithm. |
Sample query
In the sys tenant, query the application and maximum quotas of all metrics of object storage on all OBServer nodes for clog storage and data storage scenarios. For backup and restore, data import, and data export scenarios, query the application and maximum quotas of all metrics of object storage on all OBServer nodes of all tenants.
obclient> SELECT * FROM oceanbase.GV$OB_SHARED_STORAGE_QUOTA;