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 98833185D6 for ; Tue, 8 Mar 2016 17:28:38 +0000 (UTC) Received: (qmail 3624 invoked by uid 500); 8 Mar 2016 17:28:37 -0000 Delivered-To: apmail-hbase-user-archive@hbase.apache.org Received: (qmail 3557 invoked by uid 500); 8 Mar 2016 17:28:37 -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 3545 invoked by uid 99); 8 Mar 2016 17:28:36 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 08 Mar 2016 17:28:36 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 45D03C2E99 for ; Tue, 8 Mar 2016 17:28:36 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.299 X-Spam-Level: * X-Spam-Status: No, score=1.299 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, HEADER_FROM_DIFFERENT_DOMAINS=0.001, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H2=-0.001, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd1-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx2-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id DniXYaQYGvkN for ; Tue, 8 Mar 2016 17:28:33 +0000 (UTC) Received: from mail-oi0-f44.google.com (mail-oi0-f44.google.com [209.85.218.44]) by mx2-lw-eu.apache.org (ASF Mail Server at mx2-lw-eu.apache.org) with ESMTPS id 05F6E5FBA9 for ; Tue, 8 Mar 2016 17:28:33 +0000 (UTC) Received: by mail-oi0-f44.google.com with SMTP id m82so15755806oif.1 for ; Tue, 08 Mar 2016 09:28:32 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:sender:in-reply-to:references:date:message-id:subject :from:to; bh=SWsSEMbcwQFl9mn1S3XsjFdP3MoFf/BK0hDYiDu9ZpU=; b=nB3jcpXbGK8yeFs3y+xR1hzEIHg4M2zvWw7rizLyGMS51Pa7PQyR7pVvU13nVaUZI4 9PozO10uXtM8bJJgSoRGpVX01ZK4ApGvElAcZA/g5se66si6BAnQOHBQlGTab/BnMrd/ +XzlfSOUNBn0oMAYgWsVYst48T83ukY8TIdkbIa0HP7APOGEjgVNtKk1jk4QbJZMqE8P slITThdJWAIFxHadp2ZQeM0MHnTabW9brTeEzdpWTRdqonnYG7x7trG6bnTBY0pdRJH/ pGKZop9Flp/p4E+qzsG5TBK7vqzKQ2iPd8ngqh6sRjvoOX7y0YQix55zv3YO9T19eaD7 +EVw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:sender:in-reply-to:references:date :message-id:subject:from:to; bh=SWsSEMbcwQFl9mn1S3XsjFdP3MoFf/BK0hDYiDu9ZpU=; b=B3VXrs65phCwzJBHHDQq3LwSKKgt1Dvg5+9wob3Fn/xREpxK/XSesT6mCF7BSrkVmB tDqLc8uJ4NOH3xZbM/bugkdk7iytaZfGDq+01R2wAi5dHmVyHIF6L8Or0U/jdbfKJVPZ eNXJlUqdbG4sfRrp6AzR2BxIOK/xxquOHcjVBv9FiAJUs4+I43EduRPlddwxIY1HDj7O tD6pyCb+egY5ttc5m+gqxDJwpjXv1BSBvs9yxL1IBo24wtbGY67hd/hZ6ubquUNYeBqq Mv56dIn9jdv68UCy3QwxItdjBOidGACxg4+qas9NdBNu39bLO5Am3AAUGczmhwp/eBLz dcDA== X-Gm-Message-State: AD7BkJJraZL/71kCuGdE0ZHO0CS4cSstpDUdpzW1dDHD+FQnCwwqFaVlZEdrBk3ORsbL5ofriWJYDYbQ5Ot2Pg== MIME-Version: 1.0 X-Received: by 10.202.71.140 with SMTP id u134mr18059657oia.75.1457458111775; Tue, 08 Mar 2016 09:28:31 -0800 (PST) Sender: saint.ack@gmail.com Received: by 10.182.233.193 with HTTP; Tue, 8 Mar 2016 09:28:31 -0800 (PST) In-Reply-To: <1EFFC0EDF85B044A99A02C925FDA3755200DBBDB@HQITEXCH07.pclc0.merkle.local> References: <1ccdad83-523d-4621-b386-a59438e482c1@me.com> <1EFFC0EDF85B044A99A02C925FDA3755200DBBDB@HQITEXCH07.pclc0.merkle.local> Date: Tue, 8 Mar 2016 09:28:31 -0800 X-Google-Sender-Auth: UcKEWMN_h1l2K7qsdpE80d2nikM Message-ID: Subject: Re: HBase poor write performance From: Stack To: Hbase-User Content-Type: multipart/alternative; boundary=001a113e51620709ad052d8ce9f4 --001a113e51620709ad052d8ce9f4 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable On Tue, Mar 8, 2016 at 8:49 AM, Frank Luo wrote: > Akmal, > > We have been suffering the issue for two years now without a good > solution. From what I learned, it is not really a good idea to do heavy > online hbase puts. The first thing you encounter will be performance caus= ed > by compact no matter how you tune parameters. Then later on you will see > job failures because hbase operation timeouts and/or region server crashe= s. > > Light writes, heavy reads are generally OK. > > What version are you running Frank? Yes, bulk load is >>> than Puts via API but I'd be interested in what 'light' means for you. Thanks, St.Ack > For heavy puts, the best practice is to prepare tables offline, then turn > it on for reads. > > If online heavy puts not avoidable, you might get the best out of it if > you manage compact/split by yourself. Meaning when # of files per region > reaches certain number, stops writing, performs compacts and splits with > large regions; then resume writing. > > I hope it helps. > > Frank Luo > > From: Akmal Abbasov [mailto:akmal.abbasov@icloud.com] > Sent: Tuesday, March 08, 2016 10:29 AM > To: user@hbase.apache.org > Subject: HBase poor write performance > > Hi, > I'm testing HBase to choose the right hardware configurations for a heavy > write use case. I'm testing using YCSB. > The cluster consist of 2 masters, and 5 regionservers(4 cores, 14GB ram, > 4x512GB SSD). > I've created a new table in HBase, presplit it to 50 regions. I'm running > 3 clients each running 50 threads, to insert data. > I'm using the default HBase settings. After running few tests, I can see > that the cluster is underutilized, in fact memory usage is around 30%. > The main problem I see for now is compactions, compactionQueueLength is > growing very fast, and compaction process is always running. > I found that there are hbase.regionserver.thread.compaction.small and > hbase.regionserver.thread.compaction.large but couldn't find information > regarding their default values. > I am also planing to increase the regions number and the memstore size to > increase utilization of the cluster and performance. > Which other settings should be tuned to improve both utilization and > performance? > Thank you. > > > I'm using HBase 0.98.7 and regionserver heap size is 7GB. > > > Regards, Akmal > > This email and any attachments transmitted with it are intended for use b= y > the intended recipient(s) only. If you have received this email in error, > please notify the sender immediately and then delete it. If you are not t= he > intended recipient, you must not keep, use, disclose, copy or distribute > this email without the author=E2=80=99s prior permission. We take precaut= ions to > minimize the risk of transmitting software viruses, but we advise you to > perform your own virus checks on any attachment to this message. We canno= t > accept liability for any loss or damage caused by software viruses. The > information contained in this communication may be confidential and may b= e > subject to the attorney-client privilege. > --001a113e51620709ad052d8ce9f4--