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:34:09 GMT
>From what I see in the opscenter documentation you can probably get what
you want via the Ops Center Dashboard :

TBL: SSTables per Read (percentiles) [cf-sstables-per-read]The min, median,
max, 90th, and 99th percentile of how many SSTables are accessed during a
read. Includes sstables that undergo bloom-filter checks, even if no data
is read from the sstable.

Here is the documentation :
https://docs.datastax.com/en/opscenter/6.5/opsc/online_help/opscCfPerformanceMetrics_r.html

https://docs.datastax.com/en/dse/6.7/dse-admin/opsc/online_help/opscUsingPerformanceMetrics_c.html

https://docs.datastax.com/en/dse/6.7/dse-admin/datastax_enterprise/operations/opsOpscenterDashboardMetrics.html

Regards,

Leo

On Mon, Mar 16, 2020 at 11:29 AM Léo FERLIN SUTTON <lferlin@mailjet.com>
wrote:

> 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