Hi Igor, If you are using java driver, you can log slow queries on client side using QueryLogger. https://docs.datastax.com/en/developer/java-driver/2.1/manual/logging/
Slow Query logger for server was introduced in C* 3.10 version. Details: https://issues.apache.org/jira/browse/CASSANDRA-12403 Regards, Bhuvan On Sun, Feb 19, 2017 at 12:59 AM, Igor Leão <igor.l...@ubee.in> wrote: > Hi there, > > I'm wondering how to log queries from Cassandra. These queries can be > either slow queries or all queries. The only constraint is that I should do > this on server side. > > I tried using `nodetool settraceprobability`, which writes all queries to > the keyspace `system_traces`. When I try to see which queries are slower > than a given number, I get: > > Result: ```InvalidRequest: code=2200 [Invalid query] message="No secondary > indexes on the restricted columns support the provided operators: "``` > Query: `select * from events where source_elapsed >= 1000;` > > My goal is to debug performance issues in a production database. I want to > know which queries are degrading the performance of the db. > > Thanks in advance! > > > > > > >
