Note
This statement is available starting from OceanBase Database V4.3.5 BP3.
Purpose
This statement is used to drop a throttling rule.
Privilege requirements
To execute the DROP CONCURRENT_LIMITING_RULE statement, the current user must have the DROP privilege. For more information about the privileges of OceanBase Database, see Privilege classification in MySQL mode.
Syntax
DROP CONCURRENT_LIMITING_RULE [ IF EXISTS ] `ccl_rule_name1` [, `ccl_rule_name2`, ...]
where ccl_rule_name specifies the name of the throttling rule.
Examples
Note
When a throttling rule is dropped, the SQL statements in the waiting queue of the rule are executed normally.
Execute the following command to drop the throttling rules sql1_keywords_ccl_rule and sql2_keywords_ccl_rule.
obclient> DROP CONCURRENT_LIMITING_RULE `sql1_keywords_ccl_rule`, `sql2_keywords_ccl_rule`;