Note
This view was introduced in OceanBase Database V4.3.4.
Purpose
This view displays the object storage-related information of shared storage clusters on all OBServer nodes.
Note
This view is applicable only to shared storage (SS) mode. If you are using shared-nothing (SN) mode, the query result of this view is empty.
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. |
| PATH | varchar(1024) | NO | The root path for object storage. The path is usually of the following types: oss:// or s3://. |
| ENDPOINT | varchar(1024) | NO | The endpoint of object storage. |
| USED_FOR | varchar(256) | NO | The user of object storage. The value can be ALL, indicating that object storage is used for both clogs and data. |
| ZONE | varchar(128) | NO | The name of the zone. |
| STORAGE_ID | bigint(20) | NO | The ID of the object storage path. Paths with the same ID are the same. |
| MAX_IOPS | bigint(20) | NO | The maximum IOPS of object storage. |
| MAX_BANDWIDTH | bigint(20) | NO | The maximum bandwidth of object storage, in bytes. |
| CREATE_TIME | timestamp(6) | NO | The creation time of object storage. |
| AUTHORIZATION | varchar(1024) | NO | The authorization information of object storage. |
| STATE | varchar(256) | NO | The status of object storage. Valid values include:
|
| STATE_INFO | varchar(1024) | NO | The status information of object storage. |
| LAST_CHECK_TIMESTAMP | timestamp(6) | NO | The time of the last check. |
| EXTENSION | varchar(4096) | NO | Other information of object storage. |