Outdated Version

You are viewing an older version of this section. View current production version.

DROP RESOURCE POOL

Drop the specified resource pool.

Syntax

DROP RESOURCE POOL pool_name

Remarks

  • pool_name: The name of a resource pool.
  • SUPER privileges are required for dropping a resource pool.
Warning

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.

You cannot drop the default_pool resource pool. You also cannot drop a pool that is the default startup pool for a user.

This command must be run on the master aggregator (see Node Requirements for MemSQL Commands).

For more information about using resource pools to specify resource limits, see Setting Resource Limits.

Example

This example sets the current resource pool to a different value before dropping it.

mysql> SET resource_pool = default_pool;
Query OK, 0 rows affected (0.00 sec)

mysql> DROP RESOURCE POOL test_pool;
Query OK, 0 rows affected (0.01 sec)

mysql> select @@resource_pool;
+-----------------+
| @@resource_pool |
+-----------------+
| default_pool    |
+-----------------+
1 row in set (0.00 sec)