[CASSANDRA-15047] Slow Query Logger in Cassandra 3.11.4

• Type: Bug
• Status: Resolved
• Priority: Low
• Resolution: Not A Problem
• Fix Version/s: 3.11.4
• Component/s: Legacy/Observability
• Severity: Low
• Assignee: Unassigned
• Reporter: RAVI KIRAN REDDY MADIREDDY
• Created: 08/Mar/19 21:11
• Updated: 16/Apr/19 09:29
• Resolved: 11/Mar/19 21:49

Description

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 log slow query's .seems its merged in 3.10 not sure if anything changed in 3.11.4 

there was dicussion in renaming 

 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

 

slow_query_log_timeout_in_ms & log_slow_query_log_timeout_in_ms

Attached is the logback.xml i am using default logback.xml

Issue Links

• is a child of: CASSANDRA-12403 Slow query detecting