Note
This view is available starting with V4.3.4.
Purpose
This view displays the IO access resource information on the current OBServer node.
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 a local path. The following types are typically used for this path: 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 object storage bucket:
|
| TYPE | varchar(32) | NO | The type of the metric. The following types are supported:
|
| 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
For scenarios such as clog storage and data storage under a user tenant, query the requested and limited quotas for object storage metrics on the current OBServer node. For scenarios such as backup and restore, data import, and data export, query the requested and limited quotas for object storage metrics on the current OBServer node.
obclient> SELECT * FROM oceanbase.V$OB_SHARED_STORAGE_QUOTA;