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 a user tenant, query the applied-for and restricted quotas for various object storage metrics across all OBServer nodes in scenarios such as clog storage and data storage. For scenarios like backup recovery, data import, and export, query the applied-for and restricted quotas for various object storage metrics across all OBServer nodes in the tenant.
obclient> SELECT * FROM oceanbase.GV$OB_SHARED_STORAGE_QUOTA;