cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Léo FERLIN SUTTON <lfer...@mailjet.com.INVALID>
Subject Re: How to find which table partitions having the more reads per sstables ?
Date Mon, 16 Mar 2020 10:29:13 GMT
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 <coolkiran2006@gmail.com> 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éo 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 can
> 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:
> >>
> >> 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
>
>

Mime
View raw message