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 <lfer...@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 <lfer...@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 <coolkiran2...@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 >>> <lfer...@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 <coolkiran2...@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-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 >>> >>>
