I wanted to know how can we monitor the query performance in cassandra.
If there is any tool apart from Trace.
Slow query logging was added as a feature in Apache Cassandra 3.10 (CASSANDRA-12403). It is enabled by default in
cassandra.yaml and queries which take longer than 500ms are logged at
However, I'm not aware of any tools that monitors the output of this feature. You can find out more about slow query logging in my answer to question #4969.
If you're just looking for a general monitoring software for Cassandra clusters, have a look at the Metrics Collector for Apache Cassandra (MCAC). It is open-source so is free to use. You can use it to monitor dozens of metrics including read/write latencies. Cheers!
@anjay.prasad, since you haven't mentioned which version of Cassandra you're using, I am going to assume it is DataStax Enterprise (DSE) and you could leverage OpsCenter to view slow queries as mentioned here in the documentation. If you're not using using DSE, you could leverage what Erick had posted in his answer as OpsCenter doesn't support managing & monitoring OSS Apache Cassandra clusters. Cheers!
8 People are following this question.