cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Romain Hardouin <romainh...@yahoo.fr.INVALID>
Subject Re: Connections info
Date Fri, 05 Oct 2018 11:49:06 GMT
 Note that one "user"/application can open multiple connections. You have also the number of
Thrift connections available in JMX if you run a legacy application.
Max is right, regarding where they're come from you can use lsof. For instance on AWS - but
you can adapt it for your needs:
IP=...REGION=...
ssh $IP "sudo lsof -i -n | grep 9042 | grep -Po '(?<=->)[^:]+' | sort -u" | xargs -P
20 -I '{}' aws --output json --region $REGION ec2 describe-instances --filter Name=private-ip-address,Values={}
--query 'Reservations[].Instances[*].Tags[*]' | jq '.[0][0] | map(select(.Key == "Name"))
| .[0].Value' | sort | uniq -c
You'll have number of instances grouped by AWS name :      3 "name_ABC"     15 "name_example" 
   37 "name_test"
Best,Romain
    Le vendredi 5 octobre 2018 à 06:28:51 UTC+2, Max C. <mc_cassandra@core43.com> a
écrit :  
 
 Looks like the number of connections is available in JMX as:
org.apache.cassandra.metrics:type=Client,name=connectedNativeClients
http://cassandra.apache.org/doc/4.0/operating/metrics.html
"Number of clients connected to this nodes native protocol server”
As for where they’re coming from — I’m not sure how to get that from JMX.  Maybe you’ll
have to use “lsof” or something to get that. 
- Max


On Oct 4, 2018, at 8:57 pm, Abdul Patel <abd786.ap@gmail.com> wrote:
Hi All,
Can we get number of users connected to each node in cassandra?Also can we get from whixh
app node they are connecting from?

  
Mime
View raw message