FrankChen021 commented on issue #11341: URL: https://github.com/apache/druid/issues/11341#issuecomment-857512939
> Does it mean that the numThreads per peon cannot exceed 2? It depends on how many bytes your machine provides. Since the `-Xmx` is set to 5GiB, I assume that there're at least 30 * 5 = 150GiB memory available on your machine. And the direct memory Druid needs can be calculated by following formula: ``` Direct Memory: (druid.processing.numThreads + druid.processing.numMergeBuffers + 1) * druid.processing.buffer.sizeBytes ``` In this case, the SQL is translated into a timer-series query, you could increase `numThreads` and `sizeBytes` to see it helps. If group-by query is heavily used, you could also increase `numMergeBuffers`. -- 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: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
