Return-Path: X-Original-To: apmail-hbase-user-archive@www.apache.org Delivered-To: apmail-hbase-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 16E9DDB2F for ; Tue, 13 Nov 2012 00:29:50 +0000 (UTC) Received: (qmail 7232 invoked by uid 500); 13 Nov 2012 00:29:43 -0000 Delivered-To: apmail-hbase-user-archive@hbase.apache.org Received: (qmail 7129 invoked by uid 500); 13 Nov 2012 00:29:43 -0000 Mailing-List: contact user-help@hbase.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hbase.apache.org Delivered-To: mailing list user@hbase.apache.org Received: (qmail 6789 invoked by uid 99); 13 Nov 2012 00:29:42 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 13 Nov 2012 00:29:42 +0000 X-ASF-Spam-Status: No, hits=-2.3 required=5.0 tests=RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of bijieshan@huawei.com designates 119.145.14.64 as permitted sender) Received: from [119.145.14.64] (HELO szxga01-in.huawei.com) (119.145.14.64) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 13 Nov 2012 00:29:38 +0000 Received: from 172.24.2.119 (EHLO szxeml207-edg.china.huawei.com) ([172.24.2.119]) by szxrg01-dlp.huawei.com (MOS 4.3.4-GA FastPath queued) with ESMTP id ASR03881; Tue, 13 Nov 2012 08:29:16 +0800 (CST) Received: from SZXEML432-HUB.china.huawei.com (10.72.61.60) by szxeml207-edg.china.huawei.com (172.24.2.56) with Microsoft SMTP Server (TLS) id 14.1.323.3; Tue, 13 Nov 2012 08:29:15 +0800 Received: from szxeml545-mbx.china.huawei.com ([169.254.1.6]) by SZXEML432-HUB.china.huawei.com ([10.72.61.60]) with mapi id 14.01.0323.003; Tue, 13 Nov 2012 08:29:07 +0800 From: Bijieshan To: "user@hbase.apache.org" CC: Zhouxunmiao Subject: RE: scan is slower after bulk load Thread-Topic: scan is slower after bulk load Thread-Index: AQHNwOOWVUVSg2VQzES6b7UvTDJNkJflwIsAgAAQ9ICAABY8gIABAT8X Date: Tue, 13 Nov 2012 00:29:06 +0000 Message-ID: <12FBA326CCB5D446B61A2DDDCB41E420301FA82C@szxeml545-mbx.china.huawei.com> References: <50A10B4C.5060709@uci.cu> , In-Reply-To: Accept-Language: en-US, zh-CN Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.46.23.75] Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-CFilter-Loop: Reflected X-Virus-Checked: Checked by ClamAV on apache.org I think one possible reason is block caching. Have you turned the block cac= hing off during scanning? Regards, Jieshan ________________________________________ From: Mohammad Tariq [dontariq@gmail.com] Sent: Tuesday, November 13, 2012 1:04 To: user@hbase.apache.org Subject: Re: scan is slower after bulk load may be because bulk load writes to the same region thus putting the entire load on a single region server. Regards, Mohammad Tariq On Mon, Nov 12, 2012 at 9:15 PM, Michael Segel w= rote: > Just a guess... have you done any compactions on the table post bulk load= ? > > On Nov 12, 2012, at 8:44 AM, Marcos Ortiz wrote: > > > Regards, Amit. > > Did you tuned the RegionServer where you has that data range hosted? > > Why do you say that scans are slower after a bulk load? > > Did you test it before bulk load? > > > > HBase version? > > > > On 11/12/2012 09:39 AM, Amit Sela wrote: > >> Hi all, > >> > >> Anyone has any idea why scanning over specific range in a table is abo= ut > >> 20% slower if that data (that specific range) was just inserted into > HBase > >> using bulk load ? > >> > >> I do the bulk load programmatically with LoadIncrementalHFiles. > >> > >> Thanks. > >> > > > > -- > > > > Marcos Luis Ort=EDz Valmaseda > > about.me/marcosortiz > > @marcosluis2186 > > > > > > > > 10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE LAS CIENCIAS > INFORMATICAS... > > CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION > > > > http://www.uci.cu > > http://www.facebook.com/universidad.uci > > http://www.flickr.com/photos/universidad_uci > >