[
https://issues.apache.org/jira/browse/CASSANDRA-15047?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16788343#comment-16788343
]
RAVI KIRAN REDDY MADIREDDY edited comment on CASSANDRA-15047 at 3/8/19 10:25 PM:
---------------------------------------------------------------------------------
[~cnlwsu] : here is the requested info, i have lot of queries which are
eligible to get logged as slow queries
{code:java}
root@cassandra-1-1znef:/var/log/cassandra# nodetool proxyhistograms
proxy histograms
Percentile Read Latency Write Latency Range Latency CAS Read
Latency CAS Write Latency View Write Latency
(micros) (micros) (micros)
(micros) (micros) (micros)
50% 654.95 943.13 454.83
0.00 0.00 0.00
75% 785.94 1955.67 943.13
0.00 0.00 0.00
95% 2346.80 5839.59 5839.59
0.00 0.00 0.00
98% 4866.32 8409.01 17436.92
0.00 0.00 0.00
99% 7007.51 10090.81 17436.92
0.00 0.00 0.00
Min 51.01 263.21 182.79
0.00 0.00 0.00
Max 89970.66 74975.55 17436.92
0.00 0.00 0.00
root@cassandra-1-1znef:/var/log/cassandra# cassandra -v
3.11.4
root@cassandra-1-1znef:/var/log/cassandra# 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
root@cassandra-1-1znef:/var/log/cassandra#{code}
was (Author: rmadireddy):
{code:java}
root@cassandra-1-1znef:/var/log/cassandra# nodetool proxyhistograms
proxy histograms
Percentile Read Latency Write Latency Range Latency CAS Read
Latency CAS Write Latency View Write Latency
(micros) (micros) (micros)
(micros) (micros) (micros)
50% 654.95 943.13 454.83
0.00 0.00 0.00
75% 785.94 1955.67 943.13
0.00 0.00 0.00
95% 2346.80 5839.59 5839.59
0.00 0.00 0.00
98% 4866.32 8409.01 17436.92
0.00 0.00 0.00
99% 7007.51 10090.81 17436.92
0.00 0.00 0.00
Min 51.01 263.21 182.79
0.00 0.00 0.00
Max 89970.66 74975.55 17436.92
0.00 0.00 0.00
root@cassandra-1-1znef:/var/log/cassandra# cassandra -v
3.11.4
root@cassandra-1-1znef:/var/log/cassandra# 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
root@cassandra-1-1znef:/var/log/cassandra#{code}
> Slow Query Logger in Cassandra 3.11.4
> --------------------------------------
>
> Key: CASSANDRA-15047
> URL: https://issues.apache.org/jira/browse/CASSANDRA-15047
> Project: Cassandra
> Issue Type: Bug
> Components: Legacy/Observability
> Reporter: RAVI KIRAN REDDY MADIREDDY
> Priority: Minor
> Fix For: 3.11.4
>
> Attachments: logback.xml
>
>
> 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
> {code:java}
> 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
> {code}
> In cassandra.yaml
> {code:java}
> # can be identified. Set this value to zero to disable slow query logging.
> slow_query_log_timeout_in_ms: 500{code}
>
> {code:java}
> slow_query_log_timeout_in_ms & log_slow_query_log_timeout_in_ms{code}
> Attached is the logback.xml i am using default [^logback.xml]
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
