Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
HBase, mail # user - HBase: Paralel Query


Copy link to this message
-
Re: HBase: Paralel Query
Ted Yu 2013-11-27, 06:18
bq. I didn't enabled blockcache

What if you enable blockcache ?

Cheers
On Tue, Nov 26, 2013 at 8:45 PM, Job Thomas <[EMAIL PROTECTED]> wrote:

> 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
>
>