代码改变世界

mongodb - 查看正在执行的操作

  abce  阅读(7508)  评论(0编辑  收藏  举报
1
2
3
4
5
6
7
8
查看正在执行的操作
db.currentOp()
 
查看系统执行的操作
db.currentOp(True)
 
kill正在执行的操作
db.killOp(<operation id>)

 

示例:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
> 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)
                                }
                        }
                }
        }
]
>

 

编辑推荐:
· AI与.NET技术实操系列(二):开始使用ML.NET
· 记一次.NET内存居高不下排查解决与启示
· 探究高空视频全景AR技术的实现原理
· 理解Rust引用及其生命周期标识(上)
· 浏览器原生「磁吸」效果!Anchor Positioning 锚点定位神器解析
阅读排行:
· DeepSeek 开源周回顾「GitHub 热点速览」
· 物流快递公司核心技术能力-地址解析分单基础技术分享
· .NET 10首个预览版发布:重大改进与新特性概览!
· AI与.NET技术实操系列(二):开始使用ML.NET
· .NET10 - 预览版1新功能体验(一)
点击右上角即可分享
微信分享提示