Note
This view was introduced in OceanBase Database V4.3.4.
Purpose
This view displays the object storage-related information of shared storage clusters in various zones.
Note
This view applies only to shared storage (SS) mode. In shared-nothing (SN) mode, the query result of this view is empty.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| CREATE_TIME | datetime | YES | The time when the record was created. |
| MODIFY_TIME | datetime | YES | The time when the record was last modified. |
| ZONE | varchar(128) | NO | The name of the zone. |
| PATH | varchar(1024) | NO | The root path used by 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 users of object storage. The value can be ALL, indicating that object storage is used by clogs and data. |
| STORAGE_ID | bigint(20) | NO | The ID of the object storage path. Paths with the same ID are the same. |
| AUTHORIZATION | varchar(1024) | NO | The authorization information of object storage. |
| MAX_IOPS | bigint(20) | YES | The maximum IOPS of object storage. |
| MAX_BANDWIDTH | bigint(20) | YES | The maximum bandwidth of object storage, in bytes. |
| STATE | varchar(256) | NO | The status of object storage. Valid values include:
|
| EXTENSION | varchar(4096) | YES | Other information about object storage. |