DataStax Academy FAQ

DataStax Academy migrated to a new learning management system (LMS) in July 2020. We are also moving to a new Cassandra Certification process so there are changes to exam bookings, voucher system and issuing of certificates.

Check out the Academy FAQ pages for answers to your questions:


question

vigneshmaheshssn_140152 avatar image
vigneshmaheshssn_140152 asked ·

How do I determine the number of active connections in a cluster?

how to find the number of active connections in a cluster

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

bettina.swynnerton avatar image
bettina.swynnerton answered ·

Hi @vigneshmaheshssn_140152,

lsof -i:9042 -i:9160 | grep ESTABLISHED

will tell you the process ids and ip addresses of the clients that are currently connected.

9042/tcp is used for native clients, if enabled

9160/tcp is used for thrift clients, if enabled

Cassandra 4.0 brings new methods and tools to get this information, see the answer to this post.

I hope this helps

4 comments 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.

is it possible to get the number of user connection through ops console ??

0 Likes 0 · ·

Hi @vigneshmaheshssn_140152,

by ops console, do you mean cqlsh? Or do you mean OpsCenter for DSE?

Before Cassandra 4, the client connections are not recorded in system tables, so you can't read this information with cqlsh with Cassandra versions 3.x

OpsCenter (a monitoring tool that. only works with DSE) has metrics for client connections.

0 Likes 0 · ·
vigneshmaheshssn_140152 avatar image vigneshmaheshssn_140152 bettina.swynnerton ♦♦ ·

Yes I am asking about dse opscenter.what is that metrics

0 Likes 0 · ·
Show more comments