mongodb - 查看正在执行的操作

查看正在执行的操作
db.currentOp()

查看系统执行的操作
db.currentOp(True)

kill正在执行的操作
db.killOp(<operation id>)

 

示例:

> db.currentOp().inprog
[
        {
                "desc" : "conn15",
                "threadId" : "140563298641664",
                "connectionId" : 15,
                "client" : "127.0.0.1:22588",
                "active" : true,
                "opid" : 12993394,
                "secs_running" : 0,
                "microsecs_running" : NumberLong(38),
                "op" : "command",
                "ns" : "admin.$cmd",
                "query" : {
                        "currentOp" : 1
                },
                "numYields" : 0,
                "locks" : {

                },
                "waitingForLock" : false,
                "lockStats" : {

                }
        },
        {
                "desc" : "conn14",
                "threadId" : "140563612096256",
                "connectionId" : 14,
                "client" : "127.0.0.1:22587",
                "active" : true,
                "opid" : 12993385,
                "secs_running" : 6,
                "microsecs_running" : NumberLong(6466243),
                "op" : "command",
                "ns" : "test.$cmd",
                "query" : {
                        "createIndexes" : "currentOpTest",
                        "indexes" : [
                                {
                                        "ns" : "test.currentOpTest",
                                        "key" : {
                                                "i" : 1
                                        },
                                        "name" : "i_1",
                                        "background" : 1
                                }
                        ]
                },
                "msg" : "Index Build (background) Index Build (background): 608127/9999999 6%",
                "progress" : {
                        "done" : 608127,
                        "total" : 9999999
                },
                "numYields" : 4767,
                "locks" : {
                        "Global" : "w",
                        "Database" : "w",
                        "Collection" : "w"
                },
                "waitingForLock" : false,
                "lockStats" : {
                        "Global" : {
                                "acquireCount" : {
                                        "r" : NumberLong(4768),
                                        "w" : NumberLong(4768)
                                }
                        },
                        "Database" : {
                                "acquireCount" : {
                                        "w" : NumberLong(4768),
                                        "W" : NumberLong(1)
                                }
                        },
                        "Collection" : {
                                "acquireCount" : {
                                        "w" : NumberLong(4768)
                                }
                        }
                }
        }
]
> 

 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值