cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From DE VITO Dominique <>
Subject RE: Log Slow Queries
Date Thu, 18 Jun 2015 11:21:40 GMT
Hi Carlos,

Different possibilities (to log slow queries).

1)      A probabilistic way to catch slow queries (probabilistic, but with detailed info)
=> look for “nodetool settraceprobability” like in

2)      Catch slow queries in the driver (it’s a recent feature, available for newest drivers
only) => see

3)      Catch slow queries on server-side (but only with C* 2.1) => see slides 15-17 "Lesser
Known Features of Cassandra 2.1"

On our side, we are more keen to use (2) – which has the best ROI (IMHO).



De : Carlos Alonso []
Envoyé : jeudi 18 juin 2015 12:33
À :
Objet : Log Slow Queries

Hi guys.

I'm facing slow read requests from time to time, I've spotted the keyspace/cf where this is
happening but I can't see anything obvious (single partition slice query, no tombstones, ...)
anything else where to look at?

I'd like to have the slow queries logged to either log or saved to a particular column family
to analyse them later. I've googled about this and the only 'easy' solution available out
there seems to be DataStax Enterprise.

What are you guys using?

Carlos Alonso | Software Engineer | @calonso<>
View raw message