MongoDBで実行中のクエリーを止める
現在実行中のクエリーの一覧を見る
db.currentOp()
mongo> db.currentOp()
{
"inprog" : [
{
"opid" : 11680,
"active" : true,
"secs_running" : 3719,
"op" : "query",
"ns" : "test.images",
"query" : {
"count" : "images",
"query" : {
"downloaded" : true
},
"fields" : null
},
"client" : "127.0.0.1:52838",
"desc" : "conn291",
"threadId" : "0x7fa09e277700",
"connectionId" : 291,
"locks" : {
"^test" : "R"
},
"waitingForLock" : true,
"numYields" : 41432,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(95825066),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong("3712466732"),
"w" : NumberLong(0)
}
}
}
]
}
クエリーを止める
db.killOp()
mongo> db.killOp(11680)
{ "info" : "attempting to kill op" }
db.killOp()
にopidを渡して実行させると停止できます。