Hi Siddharth,
Please go for following optimizations: - Increase the xceivers property to 16k in hbase site xml. Increase the region server handler count to 60. Decrease salt buckets for the tables.At least for the smaller table. It shud help. Thanks ------ Original message------ From: Siddharth Ubale Date: Wed, Nov 12, 2014 19:29 To: [email protected]; Subject:Regionserver Crashing whenever join query run_tables with 10lac rows Hi , We are using 4 node hbase cluster with phoenix with the following config: Phoenix 4.2 Hbase 0.98.7 Hadoop 2.5 We have two tables each containing 10 lac records. Whenever we run a query from any of the 4 clients ,which performs a join on these tables the region server crashes and we are unable to get any result. Our nodes are essentially 150Gb machines with 8 cores and 8 gb Ram except one which has 16 cores and 16gb ram. We are still analyzing Phoenix for our project. And we seem to have hit a roadblock. Can anyone please let us know what is the problem here ? Also, whenever we run join queries on tables having 1 lac records we can get results in 2-3 seconds. Siddharth Ubale,
