Note
This view is available starting with V4.3.5 BP3.
Purpose
This view records the throttling rules of all tenants.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The tenant ID. |
| CCL_RULE_ID | bigint(20) | NO | The throttling rule ID. |
| CCL_RULE_NAME | varchar(128) | NO | The throttling rule name. |
| AFFECT_USER_NAME | varchar(64) | NO | The user to which the throttling applies. |
| AFFECT_HOST | varchar(128) | NO | The IP address to which the throttling applies. |
| AFFECT_FOR_ALL_DATABASES | tinyint(4) | NO | Indicates whether the throttling applies to all databases. |
| AFFECT_FOR_ALL_TABLES | tinyint(4) | NO | Indicates whether the throttling applies to all tables. |
| AFFECT_DML | bigint(20) | NO | The DML statement to which the throttling applies. |
| AFFECT_DATABASE | varchar(128) | YES | The database to which the throttling applies. |
| AFFECT_TABLE | varchar(256) | YES | The table to which the throttling applies. |
| AFFECT_SCOPE | bigint(20) | NO | The throttling scope: |
| CCL_KEYWORDS | varchar(1048576) | NO | The throttling keywords. |
| MAX_CONCURRENCY | bigint(20) | NO | The maximum concurrency of throttling. |
Sample query
Query the throttling rules of all tenants.
obclient> SELECT * FROM CDB_OB_CCL_RULES;