Kunal Khatua created DRILL-3896: ----------------------------------- Summary: Allow for dynamic allocation of resources during execution of concurrent queries Key: DRILL-3896 URL: https://issues.apache.org/jira/browse/DRILL-3896 Project: Apache Drill Issue Type: Improvement Components: Query Planning & Optimization Reporter: Kunal Khatua
With increasing number of concurrent queries, we often have to tune the Drill session settings like `planner.width.max_per_node` to reduce committing of resources. Most RDBMS systems dynamically allocate resources as more concurrent queries are running on the system. A proposal would be to have a flag that enable/disables this dynamic allocation, along with a min/max of the resource. For e.g., on a 10-node setup, the first 4 queries can concurrently run with `planner.width.max_per_node`=23 (default for a 32 core/node system), and every additional 4 queries can reduce this setting for those session by about 2.. down to a minimum value of 6. -- This message was sent by Atlassian JIRA (v6.3.4#6332)