Skip to content

Instantly share code, notes, and snippets.

@fazlurr
Created January 27, 2025 08:48
Show Gist options
  • Save fazlurr/03382cacf5ac68b55c197db533de2b83 to your computer and use it in GitHub Desktop.
Save fazlurr/03382cacf5ac68b55c197db533de2b83 to your computer and use it in GitHub Desktop.
MongoDB - Kill Slow Operations
var killLongRunningOps = function (table = 'submission', maxSecsRunning = 5000, kill = false) {
var ns = 'orderonline_db.' + table;
if (table === '*') {
ns = /^orderonline_db\./;
}
var currOp = db.currentOp({"active" : true,"secs_running" : { "$gt" : maxSecsRunning },"ns" : ns});
var operations = currOp.inprog;
for (var i = 0; i < operations.length; i++) {
var operation = operations[i];
print(i + ". Operation: " + operation.opid);
print("- NS: " + operation.ns);
print("- OP: " + operation.op);
print("- Secs Running: " + operation.secs_running);
if (kill) {
print("- Killing operation: " + operation.opid);
try {
db.killOp(operation.opid);
} catch (error) {
console.log('- Error Killing: ', error);
}
}
print("--------------------");
}
}
killLongRunningOps('*', 1000, false)
@fazlurr
Copy link
Author

fazlurr commented Jan 27, 2025

Login to your MongoDB cluster, then copy paste the code

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment