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)