As with all other database platforms, daily administration and troubleshooting of MongoDB often begins with analyzing database activity. It can be helpful to see all connections from within MongoDB, which you can do by running: db.$cmd.sys.inprog.findOne({$all:1}); or db.currentOp(true); where the “true” makes the command include idle connections. But often there's so many connections that unless you capture the output in a script file or some similar thing, it's kind of useless. Thanks to a hint given by Scott Hernandez in the mongodb-user forum, we can use the line db.currentOp(true).inprog.forEach(function(o){if( ) printjson(o)}); to show a subset that is more manageable. For instance, we might want to show all connections from a particular application server: db.currentOp(true).inprog.forEach(function(o){if(o.client.indexOf(“10.0.1.77”) != -1 ) printjson(o)}); or from the MongoDB logs we’ll see a particular connectionId and want to know where it came from: db.currentOp(true).inprog.forEach(function(o){if(o.connectionId == 8606 ) printjson(o)}); This will then show all the connection info for that connectionId: { "opid" : 7117752, "active" : false, "lockType" : "read", "waitingForLock" : false, "op" : "query", "ns" : "player_data.player_answerchoice", "query" : { "$query" : { "poll_id" : ObjectId("4f58e08db3e93217c2000008") } }, "client" : "10.0.1.77:59542", "desc" : "conn", "threadId" : "0x49e31940", "connectionId" : 8606, "numYields" : 0 }
Share this
Previous story
← My SLOB IO Testing Index
You May Also Like
These Related Stories
ORA-00274 after upgrade to 19c and trying to enable a delay on recovery for standby database.
ORA-00274 after upgrade to 19c and trying to enable a delay on recovery for standby database.
Sep 26, 2022
1
min read
Issues With Database Service Names Starting With Pluggable Database (PDB) Name
Issues With Database Service Names Starting With Pluggable Database (PDB) Name
Nov 5, 2020
9
min read
Datascape podcast episode 25 – Azure SQL Database & Paas offerings
Datascape podcast episode 25 – Azure SQL Database & Paas offerings
Apr 12, 2018
1
min read
No Comments Yet
Let us know what you think