You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Srinath Perera <sr...@wso2.com> on 2013/11/11 03:25:38 UTC
Tracing Queries at Cassandra Server
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
Re: Tracing Queries at Cassandra Server
Posted by Srinath Perera <sr...@wso2.com>.
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 <ts...@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 <sr...@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
Re: Tracing Queries at Cassandra Server
Posted by Takenori Sato <ts...@cloudian.com>.
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 <sr...@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
>
>
>