Overview
Displays the configuration information related to write requests.
Columns
Column |
Type |
Is NULL |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | Tenant ID.
|
| SNAP_INTERVAL | varchar(64) | NO | The interval between each snapshot, in the format of DD HH:mm:SS Easy to read |
| RETENTION | varchar(64) | NO | The retention period between each snapshot, in the format of DD HH:mm:SS Easy to read |
| TOPNSQL | bigint(20) | NO | SQL for Storing the Top N |
Sample query
Query the configuration information related to write requests.
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)