Check the current number of connections to MongoDb

Question

What is the command to get the number of clients connected to a particular MongoDB server

User · Answer

Connection Count by ClientIP  with Total  We use this to view the number of connections by IPAddress with a total connection count  This was really helpful in debugging an issue    just get there before hit max connections   For Mongo Shell   db currentOp true  inprog reduce  accumulator  connection    gt    ipaddress   connection client   connection client split      0     Internal   accumulator ipaddress     accumulator ipaddress     0    1  accumulator  TOTAL CONNECTION COUNT      return accumulator       TOTAL CONNECTION COUNT  0      Formatted   db currentOp true  inprog reduce     accumulator  connection    gt        ipaddress   connection client   connection client split      0     Internal       accumulator ipaddress     accumulator ipaddress     0    1      accumulator  TOTAL CONNECTION COUNT          return accumulator           TOTAL CONNECTION COUNT  0       Example return          TOTAL CONNECTION COUNT    331       192 168 253 72    8       192 168 254 42    17       127 0 0 1    3       192 168 248 66    2       11 178 12 244    2       Internal    41       3 100 12 33    86       11 148 23 34    168       81 127 34 11    1       84 147 25 17    3      the 192 x x x addresses at Atlas internal monitoring    Internal  are internal processes that don t have an external client  You can view a list of these with this   db currentOp true  inprog filter connection   gt   connection client  map connection   gt  connection desc

User · Answer

In OS X  too see the connections directly on the network interface  just do     lsof -n -i4TCP 27017  mongod     2191 inanc    7u  IPv4 0xab6d9f844e21142f  0t0  TCP 127 0 0 1 27017  LISTEN  mongod     2191 inanc   33u  IPv4 0xab6d9f84604cd757  0t0  TCP 127 0 0 1 27017- gt 127 0 0 1 56078  ESTABLISHED  stores te 18704 inanc    6u  IPv4 0xab6d9f84604d404f  0t0  TCP 127 0 0 1 56078- gt 127 0 0 1 27017  ESTABLISHED     No need to use grep etc  just use the lsof s arguments  Too see the connections on MongoDb s CLI  see  milan s answer  which I just edited

User · Answer

db runCommand     connPoolStats    1              numClientConnections    0       numAScopedConnections    0       totalInUse    0       totalAvailable    0       totalCreated    0       hosts                   replicaSets                   ok    1

User · Answer

Also some more details on the connections with  db currentOp true   Taken from  https   jira mongodb org browse SERVER-5085

User · Answer

Alternatively you can check connection status by logging into Mongo Atlas and then navigating to your cluster

User · Answer

db serverStatus   gives no of connections opend and avail but not shows the connections from which client  For more info you can use this command sudo lsof   grep mongod   grep TCP  I need it when i did replication and primary node have many client connection greater than secondary      sudo lsof   grep mongod   grep TCP mongod    5733             Al    6u     IPv4 0x08761278       0t0       TCP   28017  LISTEN  mongod    5733             Al    7u     IPv4 0x07c7eb98       0t0       TCP   27017  LISTEN  mongod    5733             Al    9u     IPv4 0x08761688       0t0       TCP 192 168 1 103 27017- gt 192 168 1 103 64752  ESTABLISHED  mongod    5733             Al   12u     IPv4 0x08761a98       0t0       TCP 192 168 1 103 27017- gt 192 168 1 103 64754  ESTABLISHED  mongod    5733             Al   13u     IPv4 0x095fa748       0t0       TCP 192 168 1 103 27017- gt 192 168 1 103 64770  ESTABLISHED  mongod    5733             Al   14u     IPv4 0x095f86c8       0t0       TCP 192 168 1 103 27017- gt 192 168 1 103 64775  ESTABLISHED  mongod    5733             Al   17u     IPv4 0x08764748       0t0       TCP 192 168 1 103 27017- gt 192 168 1 103 64777  ESTABLISHED    This shows that I currently have five connections open to the MongoDB port  27017  on my computer  In my case I m connecting to MongoDB from a Scalatra server  and I m using the MongoDB Casbah driver  but you ll see the same lsof TCP connections regardless of the client used  as long as they re connecting using TCP IP

User · Answer

I tried to see all connections for mongo database by following command   netstat -anp --tcp --udp   grep mongo   This command can show every tcp connection for mongodb in more detail   tcp        0      0 10 26 2 185 27017           10 26 2 1 2715              ESTABLISHED 1442   mongod        tcp        0      0 10 26 2 185 27017           10 26 2 1 1702              ESTABLISHED 1442   mongod   tcp        0      0 10 26 2 185 27017           10 26 2 185 39506           ESTABLISHED 1442   mongod        tcp        0      0 10 26 2 185 27017           10 26 2 185 40021           ESTABLISHED 1442   mongod        tcp        0      0 10 26 2 185 27017           10 26 2 185 39509           ESTABLISHED 1442   mongod  tcp        0      0 10 26 2 185 27017           10 26 2 184 46062           ESTABLISHED 1442   mongod        tcp        0      0 10 26 2 185 27017           10 26 2 184 46073           ESTABLISHED 1442   mongod        tcp        0      0 10 26 2 185 27017           10 26 2 184 46074           ESTABLISHED 1442   mongod

User · Answer

You can just use   db serverStatus   connections   Also  this function can help you spot the IP addresses connected to your Mongo DB  db currentOp true  inprog forEach function x    print x client

User · Answer

Connect with your mongodb instance from local system   sudo mongo  mongodb   MONGO HOST IP 27017  --authenticationDatabase admin   It ll let you know all connected clients and their details      db currentOp true

User · Answer

connect to the admin database and run db serverStatus      gt  var status   db serverStatus    gt  status connections      current    21   available    15979   gt     You can directly get by querying   db serverStatus   connections   To understand what does MongoDb s db serverStatus   connections response mean  read the documentation here      connections        connections          current     lt num gt       available     lt num gt       totalCreated    NumberLong  lt num gt                connections     A document that reports on the status of the connections  Use these values to assess the current load and capacity requirements of the server           connections current     The number of incoming connections from clients to the database server   This number includes the current shell session  Consider the value of connections available to add more context to this datum           The value will include all incoming connections including any shell connections or connections from other servers  such as replica set members or mongos instances           connections available     The number of unused incoming connections available  Consider this value in combination with the value of connections current to understand the connection load on the database  and the UNIX ulimit Settings document for more information about system thresholds on available connections           connections totalCreated     Count of all incoming connections created to the server  This number includes connections that have since closed

User · Answer

Connect to MongoDB using mongo-shell and run following command   db serverStatus   connections   e g   mongo gt  db serverStatus   connections    current    3   available    816   totalCreated    NumberLong 1270

User · Answer

Sorry because this is an old post and currently there is more options than before   db getSiblingDB  admin   aggregate          currentOp    allUsers  true  idleConnections  true  idleSessions  true          project                 id  0             client   arrayElemAt     split    client         0                 curr active   cond    eq    active  true   1 0               curr inactive   cond    eq    active  false   1 0                          match  client   ne  null         group   id   client  curr active   sum   curr active   curr inactive   sum   curr inactive   total   sum 1         sort  total -1         Output example       id     xxx xxx xxx 78    curr active    0   curr inactive    1428   total    1428       id     xxx xxx xxx 76    curr active    0   curr inactive    1428   total    1428       id     xxx xxx xxx 73    curr active    0   curr inactive    1428   total    1428       id     xxx xxx xxx 77    curr active    0   curr inactive    1428   total    1428       id     xxx xxx xxx 74    curr active    0   curr inactive    1428   total    1428       id     xxx xxx xxx 75    curr active    0   curr inactive    1428   total    1428       id     xxx xxx xxx 58    curr active    0   curr inactive    510   total    510       id     xxx xxx xxx 57    curr active    0   curr inactive    459   total    459       id     xxx xxx xxx 55    curr active    0   curr inactive    459   total    459       id     xxx xxx xxx 56    curr active    0   curr inactive    408   total    408       id     xxx xxx xxx 47    curr active    1   curr inactive    11   total    12       id     xxx xxx xxx 48    curr active    1   curr inactive    7   total    8       id     xxx xxx xxx 51    curr active    0   curr inactive    8   total    8       id     xxx xxx xxx 46    curr active    0   curr inactive    8   total    8       id     xxx xxx xxx 52    curr active    0   curr inactive    6   total    6       id     127 0 0 1    curr active    1   curr inactive    0   total    1       id     xxx xxx xxx 3    curr active    0   curr inactive    1   total    1

[mongodb] Check the current number of connections to MongoDb

Examples related to mongodb