You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Rahul Bhardwaj <ra...@indiamart.com> on 2015/04/17 08:10:51 UTC
check active queries on cluster
Hi All,
We want to track active queries on cassandra cluster. Is there any tool or
way to find all active queries on cassandra ?
Regards:
Rahul Bhardwaj
--
Follow IndiaMART.com <http://www.indiamart.com> for latest updates on this
and more: <https://plus.google.com/+indiamart>
<https://www.facebook.com/IndiaMART> <https://twitter.com/IndiaMART> Mobile
Channel:
<https://itunes.apple.com/WebObjects/MZStore.woa/wa/viewSoftware?id=668561641&mt=8>
<https://play.google.com/store/apps/details?id=com.indiamart.m>
<http://m.indiamart.com/>
<https://www.youtube.com/watch?v=DzORNbeSXN8&list=PL2o4J51MqpL0mbue6kzDa6eymLVUXtlR1&index=2>
Watch how IndiaMART Maximiser helped Mr. Khanna expand his business. kyunki Kaam
Yahin Banta Hai
<https://www.youtube.com/watch?v=Q9fZ5ILY3w8&feature=youtu.be>!!!
Re: check active queries on cluster
Posted by Ben Bromhead <be...@instaclustr.com>.
A warning on enabling debug and trace logging on the write path. You will
be writing information about every query to disk.
If you have any significant volume of requests going through the nodes
things will get slow pretty quickly. At least with C* < 2.1 and using the
default logging config.
On 1 June 2015 at 07:34, Sebastian Martinka <sebastian.martinka@mercateo.com
> wrote:
> 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> 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
>
>
>
--
Ben Bromhead
Instaclustr | www.instaclustr.com | @instaclustr
<http://twitter.com/instaclustr> | (650) 284 9692
AW: check active queries on cluster
Posted by Sebastian Martinka <se...@mercateo.com>.
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 <ra...@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
Re: check active queries on cluster
Posted by Robert Coli <rc...@eventbrite.com>.
On Thu, Apr 16, 2015 at 11:10 PM, Rahul Bhardwaj <
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