From user-return-65397-archive-asf-public=cust-asf.ponee.io@cassandra.apache.org Mon Mar 16 10:29:31 2020 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [207.244.88.153]) by mx-eu-01.ponee.io (Postfix) with SMTP id 65EF9180647 for ; Mon, 16 Mar 2020 11:29:31 +0100 (CET) Received: (qmail 83026 invoked by uid 500); 16 Mar 2020 10:29:28 -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 83016 invoked by uid 99); 16 Mar 2020 10:29:28 -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, 16 Mar 2020 10:29:28 +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 E97691809C6 for ; Mon, 16 Mar 2020 10:29:27 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 0.001 X-Spam-Level: X-Spam-Status: No, score=0.001 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, HTML_MESSAGE=0.2, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (1024-bit key) header.d=mailjet.com Received: from mx1-he-de.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id 0PVbWxmg2WPk for ; Mon, 16 Mar 2020 10:29:25 +0000 (UTC) Received-SPF: Pass (mailfrom) identity=mailfrom; client-ip=2a00:1450:4864:20::444; helo=mail-wr1-x444.google.com; envelope-from=lferlin@mailjet.com; receiver= Received: from mail-wr1-x444.google.com (mail-wr1-x444.google.com [IPv6:2a00:1450:4864:20::444]) by mx1-he-de.apache.org (ASF Mail Server at mx1-he-de.apache.org) with ESMTPS id CC0557DE33 for ; Mon, 16 Mar 2020 10:29:24 +0000 (UTC) Received: by mail-wr1-x444.google.com with SMTP id y2so4987500wrn.11 for ; Mon, 16 Mar 2020 03:29:24 -0700 (PDT) X-ASF-DKIM-Sig: v=1; a=rsa-sha256; c=relaxed/relaxed; d=mailjet.com; s=google; h=mime-version:references:in-reply-to:from:date:message-id:subject:to; bh=aKThY+6HxSTZWdVbJaXun3Gqvnah/HG/SkTzvuLkJqc=; b=iaDg2YjgIthxUMhsmOlkDc5ID0L7P23mU50w2Z39Z22uVA7AAPDmyd5kowO97vQbFG /b7nRKyY3+mecVIx0N2+RWBA4LWaW0i0CFfjFJ1jDwF3yf2Rk8BOexWfelAfBaI6OaMF j2eCXI1ySfc2HMg77Ot0i5ntUIu5RYET1M9jQ= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to; bh=aKThY+6HxSTZWdVbJaXun3Gqvnah/HG/SkTzvuLkJqc=; b=O1O1gsMZuSU23JQcPSEOkRrfdCDuD/IcfaxqmGMI2CjCSCzMu1lviOwD89x/DWKYeB oNrWTaGIy3Y+vyVOihRUiLpWlUfrrs0GBC/n9LVLU0BsYhDaWWCdqCwDy993cw2hyz4Q noHIMxVa5HQ4O8EIT6TA1OuS3BgZRr1j73OBWRTUUq6TDo4w9ijpPy1UxWhcyAuZcpcQ /+f0PuTR6OX5mlL+3e1wB85pmVjPwcI0zKFGcjlC8xX3NlK0GzSJPnw3WysR4zcm/x3u baFsXv60DtTyaqnJXIpfjjKsQxcJ9PByQtanWNL7nxA79JLD221LruWmlNhsBMefWNAr cLtg== X-Gm-Message-State: ANhLgQ2VsSfTS5cLkrCmNBdq754wR2W5rb6phnekwG9JyWdXmLNhQYtY AXpYb44uQb/LAwU5a7LjTtXT8i2XM6EhLFMeKhRXBgRfRiM= X-Google-Smtp-Source: ADFU+vuSdU9WVZGema143M2yAT4E39GEJgOQ5E0PhX/5TDzh+t2PM2SJKPbGbVt+u723QN2pT6upewV0FzPTaWGALdw= X-Received: by 2002:a5d:5545:: with SMTP id g5mr18815087wrw.290.1584354564116; Mon, 16 Mar 2020 03:29:24 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: =?UTF-8?Q?L=C3=A9o_FERLIN_SUTTON?= Date: Mon, 16 Mar 2020 11:29:13 +0100 Message-ID: Subject: Re: How to find which table partitions having the more reads per sstables ? To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary="000000000000fe263405a0f64aca" --000000000000fe263405a0f64aca Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable I'm sure there is a way to find it in Opscenter but I've never used it so I don't know. The easiest way for you would probably be to use Jconsole if you want a quick answer. Here is the path where you will find the metric : 1. Mbeans tab 2. Click on org.apache.cassandra.metrics 3. Click on Table 4. You should have a list of folder at the end. Each one is a Keyspace. 1. For each Keyspace. Click on the folder. You will get a list of tables 2. For each table look for `SSTablesPerReadHistogram` and then the Attrbute `Count` should give you the value. In the future you should try to collect the cassandra metrics via jmx (or another method), but opscenter is probably able to do it for you. On Mon, Mar 16, 2020 at 10:12 AM Kiran mk wrote: > Hi Leo, > > Thanks for replying. Can you please point me to link or steps to > configure MBean. Is there any options to find in Opscenter too ? > > Best Regards, > Kiran.M.K. > > On Mon, Mar 16, 2020 at 2:20 PM L=C3=A9o FERLIN SUTTON > wrote: > > > > You can look up this Mbean : SSTablesPerReadHistogram (via jmx) > > > > You will have one metric per table, try to find the biggest one. You ca= n > find more info here : > http://cassandra.apache.org/doc/latest/operating/metrics.html#table-metri= cs > > > > On Mon, Mar 16, 2020 at 9:11 AM Kiran mk > wrote: > >> > >> Hi All, > >> > >> I am trying to understand reads per sstables. How to find which > >> table partitions having the more reads per sstables in Cassandra? > >> > >> > >> -- > >> Best Regards, > >> Kiran.M.K. > >> > >> --------------------------------------------------------------------- > >> To unsubscribe, e-mail: user-unsubscribe@cassandra.apache.org > >> For additional commands, e-mail: user-help@cassandra.apache.org > >> > > > -- > Best Regards, > Kiran.M.K. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-unsubscribe@cassandra.apache.org > For additional commands, e-mail: user-help@cassandra.apache.org > > --000000000000fe263405a0f64aca Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
I'm sure there is a way to find it in Opscenter b= ut I've never used it so I don't know.

The= easiest way for you would probably be to use Jconsole if you want a quick = answer.

Here is the path where you will find the m= etric :
  1. Mbeans tab
  2. Click on org.apache.cassandra.= metrics
  3. Click on Table
  4. You should have a list of folder at = the end. Each one is a Keyspace.
    1. For each Keyspace. Click on th= e folder. You will get a list of tables=C2=A0=C2=A0
    2. For each table = look for `SSTablesPerReadHistogram` and then the Attrbute `Count` should gi= ve you the value.

In the future you= should=C2=A0try to collect the cassandra metrics via jmx (or another metho= d), but opscenter is probably able to do it for you.

On Mon, Mar 16, 2020 at= 10:12 AM Kiran mk <coolkiran= 2006@gmail.com> wrote:
Hi Leo,

Thanks for replying.=C2=A0 Can you please point me to link or steps to
configure MBean.=C2=A0 Is there any options to find in Opscenter too ?

Best Regards,
Kiran.M.K.

On Mon, Mar 16, 2020 at 2:20 PM L=C3=A9o FERLIN SUTTON
<lferlin@mailjet.com.invalid> wrote:
>
> You can look up this Mbean : SSTablesPerReadHistogram (via jmx)
>
> You will have one metric per table, try to find the biggest one. You c= an find more info here : = http://cassandra.apache.org/doc/latest/operating/metrics.html#table-metrics=
>
> On Mon, Mar 16, 2020 at 9:11 AM Kiran mk <coolkiran2006@gmail.com> wrote:<= br> >>
>> Hi All,
>>
>> I am trying to understand=C2=A0 reads per sstables.=C2=A0 How to f= ind which
>> table partitions having the more reads per sstables in Cassandra?<= br> >>
>>
>> --
>> Best Regards,
>> Kiran.M.K.
>>
>> ------------------------------------------------------------------= ---
>> To unsubscribe, e-mail: user-unsubscribe@cassandra.apache.org<= br> >> For additional commands, e-mail: user-help@cassandra.apache.org
>>


--
Best Regards,
Kiran.M.K.

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@cassandra.apache.org
For additional commands, e-mail: user-help@cassandra.apache.org

--000000000000fe263405a0f64aca--