Overview
Displays the I/O access resource information on all OBServer nodes.
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:
|
| 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 across all OBServer nodes in scenarios such as clog storage and data storage. For scenarios like backup and recovery, data import, and export, query the requested and limited quotas for various object storage metrics across all tenants on all OBServer nodes.
obclient> SELECT * FROM oceanbase.GV$OB_SHARED_STORAGE_QUOTA;