AnsweredAssumed Answered

How do you size drill-bit processes?

Question asked by john.humphreys on Jun 5, 2017
Latest reply on Jun 6, 2017 by maprcommunity

Drill hasn't been quite as performant as I was hoping (yet, still trying).


I'm curious if the drill-bit sizing has anything to do with this.  Our admins mange the cluster-side settings though so I'm going to have to rely on asking questions over experimenting.

 

  • Our queries are finishing, they're just a little slow.  So, they are not outright failing.
  • Our Drill UI shows Maximum Direct Memory 8,589,934,592.

 

My Questions

  1. What is the default size of a drill-bit processes?
  2. What is "Maximum Direct Memory" exactly?
  3. Assuming our queries are finishing, will giving drill more memory possibly improve their performance?  If so, how do you size the memory?
  4. Can I see if drill is expending its memory in any easy way (e.g. flushing to disk or whatever it does)?

 

Thanks,

 

-John

Outcomes