Bringing together the Apache Cassandra experts from the community and DataStax.

Want to learn? Have a question? Want to share your expertise? You are in the right place!

Not sure where to begin? Getting Started

 

question

mozartiano123 avatar image
mozartiano123 asked ·

How do I see all the active DB connections and running queries?

HI All,

studying on a lab with dse 6.0 and I could not find any way to check whether my cassandra-stress is running agains my database.

Is there any table like oracle V$session in cassandra?

Thanks

monitoring
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

1 Answer

Erick Ramirez avatar image
Erick Ramirez answered ·

Cassandra 4.0 (not yet released at the time of writing) will include a new ConnectedClient.java class which tracks connected clients. The information is stored in the new system_view.clients table which can be queried with the client stats command:

$ nodetool clientstats

I've discussed the details in question #6113.

As above, this feature is available in Cassandra 4.0 and DataStax Enterprise 6.8 and newer releases.

It isn't available in the Academy lab you're using which has DSE 6.0. You will only be able to check connections at the OS layer with Linux utilities such as netstat or lsof. Cheers!

Share
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.