SingleStore DB

Using the Workload Manager

Notice

SingleStore Managed Service does not support setting the engine variables that are discussed in this topic. Please log into your account at support.memsql.com and request support for this feature.

SingleStore DB’s workload manager automatically manages cluster workloads by limiting execution of queries that require fully distributed execution, to ensure that they are matched with available system resources. The workload manager improves overall query execution efficiency and prevents workload surges from overwhelming the system. When the system is low on connections, threads, or memory, queries are queued so they can run later when adequate resources are available.

Related to workload management is the concept of resource governance. Resource governance allows queries to be run in resource pools. Optionally, you can configure queries to queue in resource pools, up to a limit that you specify. For more information, see Setting Resource Limits.