question

vigneshmaheshssn_140152 avatar image
vigneshmaheshssn_140152 asked Erick Ramirez edited

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
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

bettina.swynnerton avatar image
bettina.swynnerton answered bettina.swynnerton commented

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

vigneshmaheshssn_140152 avatar image vigneshmaheshssn_140152 commented ·

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

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

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 ♦♦ commented ·

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

0 Likes 0 ·
Show more comments