Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-15047

Slow Query Logger in Cassandra 3.11.4

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Low
    • Resolution: Not A Problem
    • Fix Version/s: 3.11.4
    • Component/s: Legacy/Observability
    • Labels:
      None
    • Severity:
      Low

      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

        Attachments

        1. logback.xml
          4 kB
          RAVI KIRAN REDDY MADIREDDY

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                rmadireddy RAVI KIRAN REDDY MADIREDDY
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: