DROP RESOURCE POOL
MemSQL Helios does not support this command.
Drop the specified resource pool.
DROP RESOURCE POOL pool_name
pool_name: The name of a resource pool.
SUPERprivileges are required for dropping a resource pool.
Open connections to a database are assigned to a specific resource pool (or
default_pool if no other pool is selected). Before dropping a resource pool, you should set
resource_pool to another value; otherwise only DDL commands can be run from those connections until a new
resource_pool value has been set.
This command must be run on the master aggregator (see Node Requirements for MemSQL Commands).
This example assumes that the resource pool
test_pool exists and that you want to drop it.
test_pool, set the current resource pool to a value other than
SET resource_pool = default_pool;
Then drop the
DROP RESOURCE POOL test_pool;
- For more information about using resource pools to specify resource limits, see Setting Resource Limits.