Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

phoenix.query.threadPoolSize - how to decide the right pool size

phoenix.query.threadPoolSize - how to decide the right pool size

New Contributor

I am working on tuning the Phoenix and HBase and came across phoenix.query.threadPoolSize property.

As per the documentation at https://phoenix.apache.org/tuning.html , it says - Number of threads in client side thread pool executor. As the number of machines/cores in the cluster grows, this value should be increased.

Request some help to understand this better.

My questions -

1. Is the thread pool created where sqlline-thin.py is running i.e on the client machine OR on the machine running the PhoenixQueryserver OR the region servers ?

2. Is the recommendation to add more cores to this client machine as the number of machine/cores in the cluster grow so that the pool size can be increased ?

3. how to decide on the right pool size and configure phoenix.query.threadPoolSize 

4. Does the client spin up and use any threads on the region servers to speed up the work ?

Don't have an account?
Coming from Hortonworks? Activate your account here