Overview
Displays the I/O access resource information on the current OBServer node.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | IP Address of OBServer Node |
| SVR_PORT | bigint(20) | NO | Port number of the OBServer node |
| ENDPOINT | varchar(256) | NO | Endpoint for shared storage. |
| PATH | varchar(1024) | NO | The path of the object storage. The commonly used types are: local://, file://, s3:// etc. |
| CLASS_ID | bigint(20) | NO | The ID used for labeling. Its meaning varies depending on the purpose of the object storage bucket:
|
| TYPE | varchar(32) | NO | Metric type. Valid values:
|
| REQUIREMENT | bigint(20) | NO | Resources required by the server |
| ASSIGN | bigint(20) | NO | The upper limits of various resources specified by the server throttling algorithm |
Sample query
In a user tenant, query the applied-for and restricted quotas for various object storage metrics on the current OBServer node for scenarios such as clog storage and data storage. For scenarios such as backup and recovery, data import, and export, query the applied-for and restricted quotas for various object storage metrics on the current OBServer node of this tenant.
obclient> SELECT * FROM oceanbase.V$OB_SHARED_STORAGE_QUOTA;