I ntroducon to MemSQL Feedback-driven Workload Manager MemSQL automacally manages cluster workloads funcons that limit execuon of queries that require fully-distributed execuon to ensure that they are matched with available system resources. Using built-in ML funcons, workload management intelligently esmates the number of connecons and threads needed to execute queries that require reshuffle and broadcast operaons, and admits the query only if workload management can assign the necessary resources. Workload management also esmates the amount of memory required to execute queries and only runs queries if sufficient memory is expected to be available. Queries that are not immediately executed are queued and are executed when system resources become available. Workload management improves overall query execuon efficiency and prevents workload surges from overwhelming the system. It allows queries to run successfully when the system is low on connecons, threads, or memory. Resource pools include the following: ●Memory Percentage: This is the percentage of memory resources allocated to the pool ●Query Timeout : The number of seconds specifying the me aer which a query running in the pool will be automacally terminated ●So and Hard CPU Limit Percentage: This is the percentage of CPU resources allocated to the pool ●Maximum Concurrency: The maximum number of concurrent SQL queries that are allowed to run cluster-wide across all aggregators 23

Technical Introduction to MemSQL - Page 23 Technical Introduction to MemSQL Page 22 Page 24