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.
SHOW RESOURCE POOLS
On this page
Note
This command is not available in all editions of SingleStore.
Lists all resource pools and their field values.
Syntax
SHOW RESOURCE POOLS
Remarks
-
This command can be run on any node (see Cluster Management Commands).
-
Refer to the Permission Matrix for the required permission.
Example
The CREATE RESOURCE POOL topic provides an example of using SHOW RESOURCE POOLS
.
Related Topics
-
For more information about using resource pools to specify resource limits, see Set Resource Limits.
Last modified: January 10, 2023