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 ?