incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Srinath Perera <srin...@wso2.com>
Subject Re: Tracing Queries at Cassandra Server
Date Tue, 12 Nov 2013 02:14:52 GMT
Thanks Takenori!

I tried adding that, but I can only see following logs. I am using 1.27,
are there new logs added in new ones?


DEBUG [Thrift:45] 2013-11-11 08:38:14,525 StorageProxy.java (line 1347)
Schemas are in agreement.
DEBUG [Thrift:1317] 2013-11-11 15:07:14,368 StorageProxy.java (line 1522)
Starting a blocking truncate operation on keyspace QpidKeySpace, CF
GlobalQueue
DEBUG [Thrift:1317] 2013-11-11 15:07:20,125 StorageProxy.java (line 1522)
Starting a blocking truncate operation on keyspace QpidKeySpace, CF
GlobalQueue
DEBUG [Thrift:1923] 2013-11-12 06:32:52,974 StorageProxy.java (line 942)
Read timeout; received 0 of 1 responses
DEBUG [Thrift:1921] 2013-11-12 06:32:52,974 StorageProxy.java (line 942)
Read timeout; received 0 of 1 responses


On Mon, Nov 11, 2013 at 8:30 AM, Takenori Sato <tsato@cloudian.com> wrote:

> In addition to CassandraServer, add StorageProxy for details as follows.
>
> log4j.logger.org.apache.cassandra.service.StorageProxy=DEBUG
> log4j.logger.org.apache.cassandra.thrift.CassandraServer=DEBUG
>
> Hope it would help.
>
>
> On Mon, Nov 11, 2013 at 11:25 AM, Srinath Perera <srinath@wso2.com> wrote:
>
>> I am talking to Cassandra using Hector. Is there a way that I can trace
>> the executed queries at the server?
>>
>> I have tired adding Enable DEBUG logging for
>> org.apache.cassandra.thrift.CassandraServer as mentioned in Cassandra vs
>> logging activity<http://stackoverflow.com/questions/9604554/cassandra-vs-logging-activity>.
>> But that does not provide much info (e.g. says slice query executed, but
>> does not give more info).
>>
>> What I look for is something like SQL tracing in MySQL, so all queries
>> executed are logged.
>>
>> --Srinath
>>
>>
>>
>


-- 
============================
Srinath Perera, Ph.D.
  Director, Research, WSO2 Inc.
  Visiting Faculty, University of Moratuwa
  Member, Apache Software Foundation
  Research Scientist, Lanka Software Foundation
  Blog: http://srinathsview.blogspot.com/
  Photos: http://www.flickr.com/photos/hemapani/
   Phone: 0772360902

Mime
View raw message