cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ben Bromhead <...@instaclustr.com>
Subject Re: check active queries on cluster
Date Mon, 01 Jun 2015 17:57:16 GMT
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

Mime
View raw message