Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 1E0A0200C59 for ; Mon, 17 Apr 2017 15:12:16 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 1CA13160BAB; Mon, 17 Apr 2017 13:12:16 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 3E1D7160B9C for ; Mon, 17 Apr 2017 15:12:15 +0200 (CEST) Received: (qmail 47786 invoked by uid 500); 17 Apr 2017 13:12:13 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 47775 invoked by uid 99); 17 Apr 2017 13:12:13 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 17 Apr 2017 13:12:13 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 59D4918F4CC for ; Mon, 17 Apr 2017 13:12:13 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.879 X-Spam-Level: * X-Spam-Status: No, score=1.879 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id c1EnrBlrLZVx for ; Mon, 17 Apr 2017 13:12:12 +0000 (UTC) Received: from mail-ua0-f169.google.com (mail-ua0-f169.google.com [209.85.217.169]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id F19CD5F29C for ; Mon, 17 Apr 2017 13:12:11 +0000 (UTC) Received: by mail-ua0-f169.google.com with SMTP id a1so72840171uaf.3 for ; Mon, 17 Apr 2017 06:12:11 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=fBC7j8pAe9NIStQ/8SOjOUWZVwJ1rK67GnfNwux5yh0=; b=Ptd3GUPdSMdO04DhYcOkep4zy/fe9lOs7/3pio4PvqITt79pD1dAvIWU6ApLEylp4i Cx030my68LWVNhJs8bt5u8UiSiq5chrNBb5pQp6K0u0vRtb7aPVVSzN1/+Xc3VodGu40 U49IKvw87xFUWMVbu2Vl71kFP2NoBTRuW68MXJIxQ7DIEN8xwXanSKNuBw/TzszZvOQm VHkBLcuoKYJz6YJ3MjMAjCr/aAiH9pUPuKu1Qi5Q4MjgOokNGo5xKauCX4ZuJPAGl47D 2+9rVgcPPjrMbm5j0xh6zsECPfZYkNxl8wrYMmhpbGNis6Sfv8brEF5pBh0YuO5OA/Ko F7Fw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to; bh=fBC7j8pAe9NIStQ/8SOjOUWZVwJ1rK67GnfNwux5yh0=; b=kQIAQwH19s2Z4zhx+VqvjckiEYR0kasx6+DanK+lR6hp+RSkDG6IV4BToOadB5XXHW 3BwfCLcjLXQnXQ454kWzpZwxy4inadQqwUWC/PK3qCZFpZYySUMQJcEVPueKHUJ5si5t F62meHZ9ycNjMh73Uunow/UYhRkTzIz7JpT00TvQxPIGKN9Kz2OmUHPV2ziy9SV1f19h tgXyZWm/UaJEebRSnJr4XwZD5Rb/MZk/uJ2fPYPEpnsZsE8+oxHPge0/+KiqMC88M6gG g1ySnHqZp0PzHji5jLncp8L9ITS7CDpsEDEdUyscC0+BalSWV9AGKX8xUYxr3UD62vtJ AYqw== X-Gm-Message-State: AN3rC/7hwcKL94AEGM+6ajpupI3JongLeJX0mZfQdm2HaU4gXoGhVk/q pJigNfFlCiL/FM4Ll4DimQXe9V1VIA== X-Received: by 10.176.9.87 with SMTP id c23mr7413855uah.22.1492434731480; Mon, 17 Apr 2017 06:12:11 -0700 (PDT) MIME-Version: 1.0 Received: by 10.103.46.72 with HTTP; Mon, 17 Apr 2017 06:12:11 -0700 (PDT) In-Reply-To: References: From: benjamin roth Date: Mon, 17 Apr 2017 15:12:11 +0200 Message-ID: Subject: Re: Counter performance To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=f403043ebcb0055182054d5c8aca archived-at: Mon, 17 Apr 2017 13:12:16 -0000 --f403043ebcb0055182054d5c8aca Content-Type: text/plain; charset=UTF-8 Do you see difference when tracing the selects? 2017-04-17 13:36 GMT+02:00 Eren Yilmaz : > Application tables use LeveledCompactionStrategy. At first, counter tables > were created by default SizeTieredCompactionStrategy, but we changed them > to LeveledCompactionStrategy then. > > > > compaction = { 'class' : 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy', > 'sstable_size_in_mb' : 512 } > > > > *From:* benjamin roth [mailto:brstgt@gmail.com] > *Sent:* Monday, April 17, 2017 12:12 PM > *To:* user@cassandra.apache.org > *Subject:* Re: Counter performance > > > > Do you have a different compaction strategy on the counter tables? > > > > 2017-04-17 10:07 GMT+02:00 Eren Yilmaz : > > We are using Cassandra (3.7) counter tables in our application, and there > are about 10 counter tables. The counter tables are in a separate keyspace > with RF=3 (total 10 nodes). The tables are read-heavy, for each web request > to the application, we read at least 20 counter values. The counter reads > are very slow comparing to the other application data reads from cassandra, > and sometimes the reads put extra heavy CPU load on some nodes. > > > > Are there any tips, or best practices for increasing the performance of > counter tables? > > > --f403043ebcb0055182054d5c8aca Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Do you see difference when tracing the selects?

2017-04-17 13:36 GMT+0= 2:00 Eren Yilmaz <Eren.Yilmaz@sebit.com.tr>:

Application tables use LeveledCompact= ionStrategy. At first, counter tables were created by default SizeTieredCom= pactionStrategy, but we changed them to LeveledCompactionStrategy then.

=C2=A0

compaction =3D { 'class' : &#= 39;org.apache.cassandra.db.compaction.LeveledCompactionStrategy&#= 39;, 'sstable_size_in_mb' : 512 }

=C2=A0

From: = benjamin roth [mailto:brstgt@gmail.com]
Sent: Monday, April 17, 2017 12:12 PM
To: u= ser@cassandra.apache.org
Subject: Re: Counter performance

=C2=A0

Do you have a different compaction strategy on the c= ounter tables?

=C2=A0

2017-04-17 10:07 GMT+02:00 Eren Yilmaz <Eren.Yilmaz@sebit.co= m.tr>:

We are using Cassandra (3.7) counter tables in our a= pplication, and there are about 10 counter tables. The counter tables are i= n a separate keyspace with RF=3D3 (total 10 nodes). The tables are read-heavy, for each web request to the application, we rea= d at least 20 counter values. The counter reads are very slow comparing to = the other application data reads from cassandra, and sometimes the reads pu= t extra heavy CPU load on some nodes.

=C2=A0

Are there any tips, or best practices for increasing= the performance of counter tables?

=C2=A0


--f403043ebcb0055182054d5c8aca--