Skip to content

Instantly share code, notes, and snippets.

@mManishTrivedi

mManishTrivedi/killLongRunningOps.js

Forked from comerford/killLongRunningOps.js
Created September 7, 2018 06:16
Show Gist options
  • Save mManishTrivedi/6cbf12289e0aa14b34f949b88b0f20f6 to your computer and use it in GitHub Desktop.
Save mManishTrivedi/6cbf12289e0aa14b34f949b88b0f20f6 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. @comerford comerford revised this gist Jun 10, 2014. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion killLongRunningOps.js
    View file
    Original file line number Diff line number Diff line change
    @@ -8,7 +8,7 @@ killLongRunningOps = function(maxSecsRunning) {
    op = currOp.inprog[oper-0];
    if (op.secs_running > maxSecsRunning && op.op == "query" && !op.ns.startsWith("local")) {
    print("Killing opId: " + op.opid
    + " running over for secs: "
    + " running for over secs: "
    + op.secs_running);
    db.killOp(op.opid);
    }
  2. @comerford comerford revised this gist Feb 27, 2014. 1 changed file with 2 additions and 1 deletion.
    3 changes: 2 additions & 1 deletion killLongRunningOps.js
    View file
    Original file line number Diff line number Diff line change
    @@ -1,5 +1,6 @@
    // kills long running ops (taking seconds as an arg to define "long")
    // 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();
  3. @comerford comerford created this gist Feb 27, 2014.
    15 changes: 15 additions & 0 deletions killLongRunningOps.js
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,15 @@
    // kills long running ops (taking seconds as an arg to define "long")
    // attempts to be a bit safer than killing all by excluding replication related operations

    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 over for secs: "
    + op.secs_running);
    db.killOp(op.opid);
    }
    }
    };