Re: How to find which table partitions having the more reads per sstables ?

[Alex Ott]

There is also nodetool toppartitions: 
https://docs.datastax.com/en/dse/5.1/dse-admin/datastax_enterprise/tools/nodetool/toolsToppartitions.html

Erick Ramirez  at "Mon, 16 Mar 2020 22:44:44 +1100" wrote:
 ER> How to find which table partitions having the more reads per sstables 
in Cassandra?

 ER> Your question is unclear. Do you want to know which tables are read the 
most? If so, you'll need to run nodetool tablestats and parse/sort
 ER> the output to get the top tables based on read count.

 ER> But if you want to know which are the "hottest" partitions, you'll need to 
have audit logging enabled to catch the incoming CQL. See Audit
 ER> Logging if your cluster is running OSS C*. If your cluster is running 
DataStax Enterprise, see Database auditing for details. Cheers!

 ER> GOT QUESTIONS? Apache Cassandra experts from the community and DataStax 
have answers! Share your expertise on 
 ER> https://community.datastax.com/.



-- 
With best wishes,Alex Ott
Principal Architect, DataStax
http://datastax.com/

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

Re: To find top 10 tables with top 10 sstables per read and top 10 tables with top tombstones per read ?

[Hossein Ghiyasi Mehr]

I think it's better to change you solution for your purpose. Tables,
partitions , tombstones, statistics, sstables, query and monitoring in
Cassandra are different! You need noSQL concept before doing anything.
Best regards,
*---*
*VafaTech  : A Total Solution for Data Gathering &
Analysis*
*---*


On Mon, Mar 16, 2020 at 1:02 PM Kiran mk  wrote:

> Hi All,
>
> Is there a way to find top 10 tables with top 10 sstables per read and
> top 10 tables with top tombstones per read in Cassandra?
>
> As In Opscenter everytime we have to select the tables to find whats
> the tombstones per read.  There are chances that we might miss
> considering the tables which has more tombstones per read.
>
> Can you please suggest
>
> --
> Best Regards,
> Kiran.M.K.
>
> -
> To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org
> For additional commands, e-mail: user-h...@cassandra.apache.org
>
>

Re: How to find which table partitions having the more reads per sstables ?

[Hossein Ghiyasi Mehr]

You can get read count per table (Total and TPS) in JMX.
If you want to find hot partitions, you can use nodetool toppartitions
without paying money!
*---*
*VafaTech  : A Total Solution for Data Gathering &
Analysis*
*---*


On Mon, Mar 16, 2020 at 11:41 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-unsubscr...@cassandra.apache.org
> For additional commands, e-mail: user-h...@cassandra.apache.org
>
>

Re: How to find which table partitions having the more reads per sstables ?

[Erick Ramirez]

>
> How to find which table partitions having the more reads per sstables in
> Cassandra?
>

Your question is unclear. Do you want to know which tables are read the
most? If so, you'll need to run nodetool tablestats and parse/sort the
output to get the top tables based on read count.

But if you want to know which are the "hottest" partitions, you'll need to
have audit logging enabled to catch the incoming CQL. See Audit Logging
 if
your cluster is running OSS C*. If your cluster is running DataStax
Enterprise, see Database auditing
 for
details. Cheers!

GOT QUESTIONS? Apache Cassandra experts from the community and DataStax
have answers! Share your expertise on https://community.datastax.com/.

Re: To find top 10 tables with top 10 sstables per read and top 10 tables with top tombstones per read ?

[Erick Ramirez]

There's no out-of-the-box way of doing it so you'll need to scrape the
output of nodetool tablestats on each node to get the top tables and top
partitions. You should be able to do it with some simple shell scripting.
Cheers!

Re: How to find which table partitions having the more reads per sstables ?

[Kiran mk]

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 
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 
> 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 
>> 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
>>>  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 
>>> 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
>>>
>>>

Re: How to find which table partitions having the more reads per sstables ?

[Léo FERLIN SUTTON]

>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 
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  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
>>  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 
>> 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
>>
>>

Re: How to find which table partitions having the more reads per sstables ?

[Léo FERLIN SUTTON]

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éo 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 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 
> 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
>
>

To find top 10 tables with top 10 sstables per read and top 10 tables with top tombstones per read ?

[Kiran mk]

Hi All,

Is there a way to find top 10 tables with top 10 sstables per read and
top 10 tables with top tombstones per read in Cassandra?

As In Opscenter everytime we have to select the tables to find whats
the tombstones per read.  There are chances that we might miss
considering the tables which has more tombstones per read.

Can you please suggest

-- 
Best Regards,
Kiran.M.K.

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

Re: How to find which table partitions having the more reads per sstables ?

[Kiran mk]

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
 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  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

Re: How to find which table partitions having the more reads per sstables ?

[Léo FERLIN SUTTON]

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  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
>
>

How to find which table partitions having the more reads per sstables ?

[Kiran mk]

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