Hello lars,
Here re the answers ,
-> I have only one region server. ( I am testing Hbase via phoenix with Hbase
in a single server).
-> All queries are fired through Phoenix only.( select Lastname from tablename
where Id=? ( Here Id is the primary key))
-> hbase.regionserver.handler.count=30(default value).
-> Hardware: Core =8
Ram =8 Gb
-> I didn't enabled blockcache.
-> Are the client in multiple threads in the process or multiple processes? - I
am not clear
Best Regards,
Job M Thomas
________________________________
From: lars hofhansl [mailto:[email protected]]
Sent: Tue 11/26/2013 11:16 PM
To: [email protected]
Subject: Re: HBase: Paralel Query
Hi Job,
first off some questions :)
How many regions are you accessing?
What type of query is this (get or scan)?
How many handlers have you configured?
What does you hardware look like (how many cores, etc)?
Is the data all in the blockcache?
If not, what does the disk IO look like?
Are the client in multiple threads in the process or multiple processes?
Sorry for all the questions, but we need a bit more data.
-- Lars
________________________________
From: Job Thomas <[email protected]>
To: [email protected]
Sent: Tuesday, November 26, 2013 12:26 AM
Subject: HBase: Paralel Query
Hi All,
How can we configure Hbase inorder to perform multythreading/parallel query
faster .
These are some bits from my analysis:
Each Thread contain 10 query ( Random)
Tread H2(Msec) Phoenix(Msec)
1 34 215
2 63 222
4 120 324
6 200 340
8 250 460
10 350 560
12 410 592
I have to find some points in the graph ploted with these values where lines
are intercepting .
So I need hbase to perform well with multythreaded condition .
Best Regards,
Job M Thomas