Support Questions

Find answers, ask questions, and share your expertise

HBase & Phoenix Query Server Tuning properties.

Hi,

I'm doing POC on HBase and Phoenix Query Server for next project. We would like to tune both the services for the best outcome for operations on 100million records. Right now we are using most of the default parameters which come with Hortonworks installation.

Can anyone provide the best set of tuning properties operations on 100million records?

Any help is highly appreciated and thanks in advance.

1 ACCEPTED SOLUTION

2 REPLIES 2

Some extra thoughts on top of Rajeshbabu's reply:

1. Increase the heapsize of the Phoenix Query Server via the PHOENIX_QUERYSERVER_OPTS variable hbase-env.sh

2. For writing data, make sure the addBatch() and executeBatch() API calls are used for the best performance