[GitHub] [incubator-druid] jp707049 commented on issue #9017: help understanding some basics to overcome query lag

[GitBox <gi...@apache.org>]

jp707049 commented on issue #9017: help understanding some basics to overcome query lag
URL: https://github.com/apache/incubator-druid/issues/9017#issuecomment-565233603
 
 
   Hello AvinoamBN,
   
   - Have a look at this for heap sizing: https://druid.apache.org/docs/latest/operations/basic-cluster-tuning.html
   How can i find out why did this query take 13 seconds to complete?
   - Each druid services and emit metrics: https://druid.apache.org/docs/latest/operations/metrics.html
   - You can enable metrics emission by following: https://druid.apache.org/docs/latest/configuration/index.html#enabling-metrics and https://druid.apache.org/docs/latest/configuration/index.html#emitting-metrics
   How can i find out what and where is the bottle-neck?
   - For initial steps to find bottle-neck, make sure you have set the runtime.properties correctly in both broker and historical.
   - There can be many factors affecting the query performance such as, segment sizing, number of historical nodes, high volume of data in query response, the type of query being executed (whether you can use/modify the query, check for topN, groupBy and timeseries)
   
   Hope this helps you figure out some things. :)

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org