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