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 <coolkiran2...@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
> <lfer...@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 <coolkiran2...@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-unsubscr...@cassandra.apache.org
> >> For additional commands, e-mail: user-h...@cassandra.apache.org
> >>
>
>
> --
> Best Regards,
> Kiran.M.K.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org
> For additional commands, e-mail: user-h...@cassandra.apache.org
>
>
