Outdated Version

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

SHOW RESOURCE POOLS

Lists all resource pools and their field values.

Syntax

SHOW RESOURCE POOLS

Remarks

This command can be run on any node (see Node Requirements for MemSQL Commands).

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

Example

This example shows the values for both default_pool and a user-defined resource pool named test_pool.

mysql> SHOW RESOURCE POOLS;
+--------------+----------------+--------------+
| Pool_name    | Memory_Percent | Query_Timeout|
+--------------+----------------+--------------+
| default_pool |            100 |         NULL |
| test_pool    |             70 |           40 |
+--------------+----------------+--------------+
2 rows in set (0.00 sec)