CODEWITHSUNDEEP
cassandratitan
gak
gak

Reputation: 32763

Titan and Cassandra debugging and profiling queries

When using the Cassandra backend, is it possible to see the Cassandra queries are being executed from Titan, and how long each query takes? Ideally it would output to standard error, or a log file.

This can possibly help optimise the structure of my queries if I can see any inefficiencies in the way Titan is talking to Cassandra.

Upvotes: 2

Views: 1216

Answers (1)

gak
gak

Reputation: 32763

Thanks to one of the authors of Titan, an acceptable way is to enable debugging in Cassandra.

You can do this by uncommenting the DEBUG lines in the cassandra log4j-server.properties file, then restarting Cassandra:

log4j.logger.org.apache.cassandra=DEBUG
log4j.logger.org.apache.cassandra.db=DEBUG
log4j.logger.org.apache.cassandra.service.StorageProxy=DEBUG

Upvotes: 3

Related Questions