Note
This view was introduced in OceanBase Database V4.3.4.
Purpose
This view displays the information of I/O access resources 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 of the OBServer node. |
| ENDPOINT | varchar(256) | NO | The endpoint of shared storage. If the shared-nothing (SN) mode is used, this field is empty. |
| PATH | varchar(1024) | NO | The path of object storage. If the SN mode is used, this field displays the local path. The following types are typically used for this field: local://, oss://, file://, and s3://. |
| CLASS_ID | bigint(20) | NO | The ID used for tagging. The meaning of this field varies based on the purpose of the object storage bucket.
|
| TYPE | varchar(32) | NO | The metric type, which can be one of the following types:
|
| REQUIREMENT | bigint(20) | NO | The resources required by the server. |
| ASSIGN | bigint(20) | NO | The upper limit of the resources specified by the throttling algorithm for the server. |
Sample query
In the sys tenant, you can query the applied and allocated quotas of object storage metrics for clog storage and data storage scenarios on the current OBServer node. For backup and restore, data import, and data export scenarios, you can query the applied and allocated quotas of object storage metrics for all tenants on the current OBServer node.
obclient> SELECT * FROM oceanbase.V$OB_SHARED_STORAGE_QUOTA;