cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kiran mk <coolkiran2...@gmail.com>
Subject Re: How to find which table partitions having the more reads per sstables ?
Date Mon, 16 Mar 2020 10:58:09 GMT
Yes I am already collecting these.  But this does not say anything about
the partitions level.

Best Regards,
Kiran M K

On Mon, Mar 16, 2020, 4:04 PM Léo FERLIN SUTTON <lferlin@mailjet.com.invalid>
wrote:

> 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