ContextQMD
Back to Cadence

View Cassandra full query logs

docs/howtos/cassandra-fql.md

1.4.0857 B
Original Source

View Cassandra full query logs

  1. Run cadence components via docker compose
docker compose docker/docker-compose.yml up
  1. First enable fql via nodetool (ref)
docker exec $(docker inspect --format="{{.Id}}" docker-cassandra-1) nodetool enablefullquerylog --path /tmp/cassandra_fql
  1. Check /tmp/cassandra_fql folder exists
docker exec $(docker inspect --format="{{.Id}}" docker-cassandra-1) ls /tmp/cassandra_fql

  1. Run some workflows to generate queries (optional)

  2. Inspect the full query log dump via fqltool (it's under tools/bin in default apache cassandra installation)

docker cp $(docker inspect --format="{{.Id}}" docker-cassandra-1):/tmp/cassandra_fql/ /tmp/cassandra_fql/ && fqltool dump /tmp/cassandra_fql | less