DROP RESOURCE POOL
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
Drop the specified resource pool.
Syntax
DROP RESOURCE POOL pool_name
Remarks
-
pool_
: The name of a resource pool.name -
DROP POOL
privileges are required for dropping a resource pool. -
Refer to the Permission Matrix for the required permission.
Warning
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.
You cannot drop the built-in resource pools.
This command must be run on the master aggregator (see Node Requirements for SingleStore Commands).
Example
This example assumes that the resource pool test_
exists and that you want to drop it.
Before dropping test_
, set the current resource pool to a value other than test_
:
SET resource_pool = default_pool;
Then drop the test_
:
DROP RESOURCE POOL test_pool;
Related Topics
Last modified: January 25, 2023