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
