Increasingly slower read operations
Version:
Read operations take a prolonged time, which impacts system performance.
SSTables reduce read capacity because records might be spread across several SSTables, as a result of frequent write operations, modifications, and deletions.
-
Check the number of SSTables per column family (table) by using the
nodetool tablestats
command. -
Analyze the outcome to determine the root cause of the issue.
Depending on thenodetool tablestats
outcome, you might want to perform such actions as adjusting your compaction throughput, expanding the memory size for file caching, and so on. For more information, see the Apache Cassandra documentation.
- Troubleshooting Cassandra
Identify the root cause of degraded performance by completing corresponding monitoring activities. Learn about the most commonly encountered Cassandra issues and how to address them.