cassandracassandra-3.0

Is it possible to enable query logging in Cassandra 3.11?


Specifically, Cassandra 3.11.4?

I don't care about performance as this is not currently a production system (in the fullest sense). So for instance, I don't require FQL's performant features that are available in 4.0, which sound like they may be suitable for logging on production systems.

What I would like is some way to do query logging, so I can debug what queries my application is sending to my system (which seem to be incorrect).


Solution

  • Yes it’s possible Enable nodetool settraceprobability 1.0 You can find the query in system_traces.events table

    Other option is increasing the logging levels to all and grep “native transport request -Id