You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Kiran mk <co...@gmail.com> on 2020/03/16 08:11:00 UTC
How to find which table partitions having the more reads per sstables ?
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
Re: How to find which table partitions having the more reads per
sstables ?
Posted by Hossein Ghiyasi Mehr <gh...@gmail.com>.
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 <http://www.vafatech.com> : A Total Solution for Data Gathering &
Analysis*
*-------------------------------------------------------*
On Mon, Mar 16, 2020 at 11:41 AM Kiran mk <co...@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
>
>
Re: How to find which table partitions having the more reads per
sstables ?
Posted by Kiran mk <co...@gmail.com>.
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 <lf...@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 <lf...@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 <co...@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
>>> <lf...@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 <co...@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
>>>
>>>
Re: How to find which table partitions having the more reads per
sstables ?
Posted by Léo FERLIN SUTTON <lf...@mailjet.com.INVALID>.
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 <lf...@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 <co...@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
>> <lf...@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 <co...@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
>>
>>
Re: How to find which table partitions having the more reads per
sstables ?
Posted by Léo FERLIN SUTTON <lf...@mailjet.com.INVALID>.
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 <co...@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
> <lf...@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 <co...@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
>
>
Re: How to find which table partitions having the more reads per
sstables ?
Posted by Kiran mk <co...@gmail.com>.
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
<lf...@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 <co...@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
Re: How to find which table partitions having the more reads per
sstables ?
Posted by Léo FERLIN SUTTON <lf...@mailjet.com.INVALID>.
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 <co...@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
>
>
Re: How to find which table partitions having the more reads per sstables ?
Posted by Alex Ott <al...@gmail.com>.
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-unsubscribe@cassandra.apache.org
For additional commands, e-mail: user-help@cassandra.apache.org
Re: How to find which table partitions having the more reads per
sstables ?
Posted by Erick Ramirez <er...@datastax.com>.
>
> 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
<http://cassandra.apache.org/doc/latest/operating/audit_logging.html> if
your cluster is running OSS C*. If your cluster is running DataStax
Enterprise, see Database auditing
<https://docs.datastax.com/en/security/6.7/security/secAuditTOC.html> for
details. Cheers!
GOT QUESTIONS? Apache Cassandra experts from the community and DataStax
have answers! Share your expertise on https://community.datastax.com/.