cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sebastian Martinka <sebastian.marti...@mercateo.com>
Subject AW: check active queries on cluster
Date Mon, 01 Jun 2015 14:34:57 GMT
You could enable DEBUG logging for org.apache.cassandra.transport.Message and TRACE logging
for org.apache.cassandra.cql3.QueryProcessor in the log4j-server.properties file:

log4j.logger.org.apache.cassandra.transport.Message=DEBUG
log4j.logger.org.apache.cassandra.cql3.QueryProcessor=TRACE

Afterwards you get the following output from all PreparedStatements in the system.log file:

DEBUG [Native-Transport-Requests:167] 2015-06-01 15:56:15,186 Message.java (line 302) Received:
PREPARE INSERT INTO dba_test.cust_view (leid, vid, geoarea, ver) VALUES (?, ?, ?, ?);, v=2
TRACE [Native-Transport-Requests:167] 2015-06-01 15:56:15,187 QueryProcessor.java (line 283)
Stored prepared statement 61956319a6d7c84c25414c96edf6e38c with 4 bind markers
DEBUG [Native-Transport-Requests:167] 2015-06-01 15:56:15,187 Tracing.java (line 159) request
complete
DEBUG [Native-Transport-Requests:167] 2015-06-01 15:56:15,187 Message.java (line 309) Responding:
RESULT PREPARED 61956319a6d7c84c25414c96edf6e38c [leid(dba_test, cust_view), org.apache.cassandra.db.marshal.UTF8Type][vid(dba_test,
cust_view), org.apache.cassandra.db.marshal.UTF8Type][geoarea(dba_test, cust_view), org.apache.cassandra.db.marshal.UTF8Type][ver(dba_test,
cust_view), org.apache.cassandra.db.marshal.LongType] (resultMetadata=[0 columns]), v=2


Von: Robert Coli [mailto:rcoli@eventbrite.com]
Gesendet: Freitag, 17. April 2015 19:23
An: user@cassandra.apache.org
Betreff: Re: check active queries on cluster

On Thu, Apr 16, 2015 at 11:10 PM, Rahul Bhardwaj <rahul.bhardwaj@indiamart.com<mailto:rahul.bhardwaj@indiamart.com>>
wrote:
We want to track active queries on cassandra cluster. Is there any tool or way to find all
active queries on cassandra ?

You can get a count of them with :

 https://issues.apache.org/jira/browse/CASSANDRA-5084

=Rob

Mime
View raw message