Mailing-List: contact user-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hbase.apache.org
Received-SPF: pass (nike.apache.org: domain of yuzhihong@gmail.com designates
 209.85.215.53 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <B83ECEB5BC76C5429C9BADC50B13271A2A993F@sbssvex20.suntecsbs.com>
References: <B83ECEB5BC76C5429C9BADC50B13271A2A993C@sbssvex20.suntecsbs.com>
	<1385488012.68103.YahooMailNeo@web140605.mail.bf1.yahoo.com>
	<B83ECEB5BC76C5429C9BADC50B13271A2A993F@sbssvex20.suntecsbs.com>
Date: Tue, 26 Nov 2013 22:18:35 -0800
Message-ID: 
 <CALte62zSWHbeUDk+X-Gb_swiEThc1XNL8n1f+KL3KzJ_95GtNg@mail.gmail.com>
Subject: Re: HBase: Paralel Query
From: Ted Yu <yuzhihong@gmail.com>
To: "user@hbase.apache.org" <user@hbase.apache.org>
Content-Type: multipart/alternative; boundary=001a113413c630fc3004ec229110

--001a113413c630fc3004ec229110
Content-Type: text/plain; charset=ISO-8859-1

bq. I didn't enabled blockcache

What if you enable blockcache ?

Cheers


On Tue, Nov 26, 2013 at 8:45 PM, Job Thomas <jobt@suntecgroup.com> 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:larsh@apache.org]
> Sent: Tue 11/26/2013 11:16 PM
> To: user@hbase.apache.org
> 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 <jobt@suntecgroup.com>
> To: user@hbase.apache.org
> 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
>
>

--001a113413c630fc3004ec229110--