Note
This view is available starting with V4.3.4.
Purpose
This view displays IO access resource information on all OBServer nodes.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | The IP address of the OBServer node. |
| SVR_PORT | bigint(20) | NO | The port number of the OBServer node. |
| ENDPOINT | varchar(256) | NO | The endpoint of the shared storage. In Shared-Nothing (SN) mode, this field is empty. |
| PATH | varchar(1024) | NO | The path of the object storage. In SN mode, it displays as the local path. Typical path types include: local://, oss://, file://, and s3://. |
| CLASS_ID | bigint(20) | NO | The ID for labeling. The meaning of this field varies based on the purpose of the object storage bucket:
|
| TYPE | varchar(32) | NO | The type of the metric. Valid values:
|
| REQUIREMENT | bigint(20) | NO | The required resources for the server. |
| ASSIGN | bigint(20) | NO | The upper limit of the resources specified by the throttling algorithm. |
Sample query
In a user tenant, query the requested and limited quotas of object storage metrics on all OBServer nodes for scenarios such as clog storage and data storage. For scenarios such as backup and restore, data import, and export, query the requested and limited quotas of object storage metrics on all OBServer nodes for the tenant.
obclient> SELECT * FROM oceanbase.GV$OB_SHARED_STORAGE_QUOTA;