Re: JMX metrics for CL

[Kyrylo Lebediev <Ky...@epam.com>]

Thank you so much, Eric!


________________________________
From: Eric Evans <jo...@gmail.com>
Sent: Wednesday, February 28, 2018 6:26:23 PM
To: user@cassandra.apache.org
Subject: Re: JMX metrics for CL



On Tue, Feb 27, 2018 at 2:26 AM, Kyrylo Lebediev <Ky...@epam.com>> wrote:

Hello!


Is it possible to get counters  from C* side regarding CQL queries executed since startup for each CL?
For example:
CL ONE: NNN queries
CL QUORUM: MMM queries
etc

It's possible to get a count of client requests.  You want the count attribute of the client-request latency histogram (closest thing to documentation here: http://cassandra.apache.org/doc/latest/operating/metrics.html#client-request-metrics).  For the scope, there are more request-types than are listed in the documentation; For each CL there is a read/write scope, ala (Read|Write)-(LOCAL-QUORUM,LOCAL-ONE,QUORUM,ONE,...).

An example dashboard:

https://grafana.wikimedia.org/dashboard/db/cassandra-client-request?panelId=1&fullscreen&orgId=1&var-datasource=eqiad%20prometheus%2Fservices&var-cluster=restbase&var-node=All&var-quantile=99p

Note: This graph suppresses series with a rate of zero for the graph time-span, so you won't see all possible request-types.



--
Eric Evans
john.eric.evans@gmail.com<ma...@gmail.com>