question

mozartiano123 avatar image
mozartiano123 asked Erick Ramirez edited

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
Toggle Comment visibility. Current Visibility: Viewable by all users

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 Erick Ramirez edited

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
Toggle Comment visibility. Current Visibility: Viewable by all users

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