I don't know about any specific guidelines for this options, but what I
know is that it only affects the sort operator, and it's related to direct
memory not heap memory.
On Wed, Jun 1, 2016 at 1:20 PM, John Omernik <john@omernik.com> wrote:
> I am reposting this question here as well. (I posted on the MapR Community
> forums).
>
> The default as I understand it, for the setting
> planner.memory.max_query_memory_per_node
> is 2G. The default heap memory settings in drill-env.sh is 4G and the
> default Direct memory is 8G.
>
> I guess, is there any advice on where I should set my
> planner.memory.max_query_memory_per_node
> as the other numbers scale? I.e. does this setting coordinate more with
> heap or direct or both? If I double my direct mem, should I double the
> setting? Are there any guidelines or methods for tuning this?
>
> I am currently running bits at 24 GB of Heap and 84GB of Direct, should I
> take the planner.memory.max_query_memory_per_node and x 8? to put 16G?
> Thoughts?
>
> Thanks!
>
> John
>
--
Abdelhakim Deneche
Software Engineer
<http://www.mapr.com/>
Now Available - Free Hadoop On-Demand Training
<http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available>
|