I'm using Cassandra with Kundera. My question is easy... Is any way to log all queries / request to Cassandra ? I'd like to know what exactly happens on server site :)
Regards
Tom
Asked
Active
Viewed 2,286 times
2 Answers
4
Enable DEBUG logging for org.apache.cassandra.thrift.CassandraServer
jbellis
- 19,347
- 2
- 38
- 47
-
1That doesn't print the CQL, at least in Cassandra 2 – David Tinker Oct 03 '14 at 11:50
-
Where I need to add this line? In /etc/cassandra/cassandra.yaml? – Artem Apr 10 '16 at 21:41
1
Enable DEBUG logging for org.apache.cassandra.transport.Message:
log4j.logger.org.apache.cassandra.transport.Message=DEBUG
This logs only PreparedStatements!!
for example:
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
Mortinke
- 31
- 4