DROP RESOURCE POOL
On this page
Drop the specified resource pool.
DROP RESOURCE POOL pool_name
pool_: The name of a resource pool.
DROP POOLprivileges are required for dropping a resource pool.
Refer to the Permission Matrix for the required permission.
Open connections to a database are assigned to a specific resource pool (or
default_ if no other pool is selected).
resource_ to another value; otherwise only DDL commands can be run from those connections until a new
resource_ value has been set.
This command must be run on the master aggregator (see Node Requirements for SingleStoreDB Commands).
This example assumes that the resource pool
test_ exists and that you want to drop it.
test_, set the current resource pool to a value other than
SET resource_pool = default_pool;
Then drop the
DROP RESOURCE POOL test_pool;
Last modified: January 25, 2023