TiDBTiDB Docs Dash 2024

Jan 9 - Jan 12 (UTC)
Join us to improve docs and win a prize!
Sign InTry Free

DROP RESOURCE GROUP

You can use the DROP RESOURCE GROUP statement to drop a resource group.

Synopsis

DropResourceGroupStmt
DROPRESOURCEGROUPIfExistsResourceGroupName
IfExists
IFEXISTS
ResourceGroupName
Identifier

Examples

Drop a resource group named rg1.

DROP RESOURCE GROUP IF EXISTS rg1;
Query OK, 0 rows affected (0.22 sec)
CREATE RESOURCE GROUP IF NOT EXISTS rg1 RU_PER_SEC = 500 BURSTABLE;
Query OK, 0 rows affected (0.08 sec)
SELECT * FROM information_schema.resource_groups WHERE NAME ='rg1';
+------+------------+----------+-----------+ | NAME | RU_PER_SEC | PRIORITY | BURSTABLE | +------+------------+----------+-----------+ | rg1 | 500 | MEDIUM | YES | +------+------------+----------+-----------+ 1 row in set (0.01 sec)
DROP RESOURCE GROUP IF EXISTS rg1;
Query OK, 1 rows affected (0.09 sec)
SELECT * FROM information_schema.resource_groups WHERE NAME ='rg1';
Empty set (0.00 sec)

MySQL compatibility

MySQL also supports DROP RESOURCE GROUP, but TiDB does not support the FORCE parameter.

See also

Was this page helpful?

Download PDFRequest docs changesAsk questions on Discord
Playground
New
One-stop & interactive experience of TiDB's capabilities WITHOUT registration.
Products
TiDB
TiDB Dedicated
TiDB Serverless
Pricing
Get Demo
Get Started
© 2024 PingCAP. All Rights Reserved.
Privacy Policy.