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

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?

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

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

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

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*

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

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

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

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 ?

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

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

>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

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

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.

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

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

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

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

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

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

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: