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 types, mainly including the following types:
|
| 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 the sys tenant, query the requested and limited 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 requested and limited quotas for various object storage metrics on the current OBServer node for all tenants.
obclient> SELECT * FROM oceanbase.V$OB_SHARED_STORAGE_QUOTA;