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