The Built-in Resource Pools
Every workspace contains the built-in resource pools system_optimizer_pool
, default_pool
, and system_auto
.
The system_optimizer_pool
runs when enable_background_statistics_collection
is set to ON
. If the system_optimizer_pool
is running and the resource_governor_cpu_limit_mode is set to HARD
, the pool reserves 5% of CPU utilization for collection of background statistics.
By default, client connections to SingleStoreDB Cloud use the default_pool
. To use a different pool, see the next section, Setting the Value. Queries in the default_pool
can have up to 100% of available query execution memory, up to 100% CPU utilization (depending on the resource_governor_cpu_limit_mode setting), and do not have a timeout limit set or a defined number of concurrent queries.