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)

Reply via email to