Slow Query Logger Cassandra on server side in Cassandra 3.11.4

Question

As per

https://issues.apache.org/jira/browse/CASSANDRA-12403

I tried to enable slow query logging with below steps on Cassandra 3.11.4 , but not able to query them any idea what is the issue, or am i missing any step .

`/nodetool getlogginglevels
 Logger Name                                        Log Level
 ROOT                                                    INFO
 com.thinkaurelius.thrift                               ERROR
 org.apache.cassandra                                   DEBUG
 org.apache.cassandra.db                                DEBUG
 org.apache.cassandra.db.monitoring                     DEBUG


In cassandra.yaml 

# can be identified. Set this value to zero to disable slow query logging. slow_query_log_timeout_in_ms: 500

cat logback.xml [deafult logback xml][1]

[1]: https://github.com/apache/cassandra/blob/trunk/conf/logback.xml

Answer 1

Step is correct, you should check system.log for any logged slow queries. Also, you need to check system_traces keyspace where session and event table created.