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
| 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. This field is empty in shared-nothing (SN) mode. |
| PATH | varchar(1024) | NO | The path in object storage. This field is displayed as the local path in SN mode. Commonly used path types are: local://, oss://, file://, and s3://. |
| CLASS_ID | bigint(20) | NO | The ID for labeling. The meaning of this field varies depending 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 a user tenant, query the applied and allocated quotas of the I/O access metrics in object storage on all OBServer nodes for clog storage and data storage scenarios. Query the applied and allocated quotas of the I/O access metrics in object storage on all OBServer nodes for backup and restore, data import, and data export scenarios.
obclient> SELECT * FROM oceanbase.GV$OB_SHARED_STORAGE_QUOTA;