mongodb learning: Client/application/ driver currently connect to Mongodb

In order to know what operations are currently running on the MongoDB services, we use this query:

  db.currentOp(true)

We can get the application server, which is connected to the MongoDB services with the below query:

 db.currentOp(true).inprog.forEach(function(x) { print(x.client) })

We want to know what is the active connection detail which is currently running in the MongoDB services

   db.currentOp(true).inprog.forEach( function(op) {
    if(op.active = true && op.client != undefined && op.clientMetadata.driver.name != "MongoDB Internal Client" && op.clientMetadata.driver.name !="NetworkInterfaceTL") {
        var miniOp = { client : op.client, description : op.desc, ns : op.ns, operation : op.op, Driver : op.clientMetadata.driver.name };
        printjson(miniOp); } } );

We want to know driver, driver version, app name , client ip , current active and current inactive connection in mongodb service

   db.aggregate([
   { $currentOp : { allUsers: true,active: true } },
  {
    $match: {
      client: { $exists: true },
      microsecs_running: {$gt: 10}
    }
  },
   {
    $project: {
      driver: "$clientMetadata.driver.name",
      version: "$clientMetadata.driver.version",
      client: "$client",
      appName: "$appName",
      position: {
        $indexOfCP: ["$client", ":"]
      }
    }
   },
   { $group : { 
       _id: {
           app : "$appName" ,
           driver: "$driver",
           version: "$version",
           client: {$substr:["$client",0,"$position"]}
       },
       count: { $sum: 1 }
   } }
])

found better version from stackoverflow Check the current number of connections to MongoDb

   db.getSiblingDB("admin").aggregate( [
   { $currentOp: { allUsers: true } }
  ,{$project:{
            "_id":0,
             driver: "$clientMetadata.driver.name",
             version: "$clientMetadata.driver.version",
              appName: "$appName"
              ,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:"$client",appname:"$appName",driver:"$driver",version:"$version"},curr_active:{$sum:"$curr_active"},curr_inactive:{$sum:"$curr_inactive"},total:{$sum:1}}}
  ,{$sort:{total:-1}}
] )

Find detail of connection detail by IP

 db.aggregate([
   { $currentOp : { allUsers: true} },
  {
    $match: {
      client: {
        $regex: "xx.xxx.xx.xxx"
       }
    }
  }
])

Reference
Check the current number of connections to MongoDb
What’s Running in My DB? A Journey with currentOp() in MongoDB

mongodb learning

Sunday, May 28, 2023

Client/application/ driver currently connect to Mongodb

No comments:

Post a Comment