Skip to content

Instantly share code, notes, and snippets.

@tsmgeek
Forked from kylemclaren/findLongRunningOp.js
Created January 21, 2019 11:32
Show Gist options
  • Save tsmgeek/521b3f487c1e64aeca227ecc096ed431 to your computer and use it in GitHub Desktop.
Save tsmgeek/521b3f487c1e64aeca227ecc096ed431 to your computer and use it in GitHub Desktop.
Find and (safely) kill long running MongoDB ops
db.currentOp().inprog.forEach(
function(op) {
if(op.secs_running > 5) printjson(op);
}
)
// kills long running ops in MongoDB (taking seconds as an arg to define "long")
// attempts to be a bit safer than killing all by excluding replication related operations
// and only targeting queries as opposed to commands etc.
killLongRunningOps = function(maxSecsRunning) {
currOp = db.currentOp();
for (oper in currOp.inprog) {
op = currOp.inprog[oper-0];
if (op.secs_running > maxSecsRunning && op.op == "query" && !op.ns.startsWith("local")) {
print("Killing opId: " + op.opid
+ " running for over secs: "
+ op.secs_running);
db.killOp(op.opid);
}
}
};
//example: killLongRunningOps(5)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment