Join the MemSQL Community Today
Get expert advice, develop skills, and connect with others.

Workload Management and Resource Governance

Workload Management

MemSQL’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.

For more information on the workload manager, see this guide.

Resource Governance

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 on resource governance, see this guide.