Note
This view is available starting with V4.2.1.
Purpose
This view displays the configuration information of the WR feature.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The tenant ID.
|
| SNAP_INTERVAL | varchar(64) | NO | The interval between two snapshots, in the DD HH:mm:SS format for easy reading. |
| RETENTION | varchar(64) | NO | The retention period of a snapshot, in the DD HH:mm:SS format for easy reading. |
| TOPNSQL | bigint(20) | NO | The topN SQL statements stored. |
Sample query
Query WR-related configuration information.
obclient [oceanbase]> SELECT * FROM oceanbase.CDB_WR_CONTROL LIMIT 1\G
The query result is as follows:
*************************** 1. row ***************************
TENANT_ID: 1
SNAP_INTERVAL: +0 01:00:00
RETENTION: +7 00:00:00
TOPNSQL: 30
1 row in set (0.037 sec)