-
Type:
Question
-
Resolution: Done
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: Querying
-
None
HI
I found many slow updates from mongodb log ,as following:
2019-05-16T18:12:56.514+0800 I COMMAND [conn1931352] command db.$cmd command: update { update: "table", ordered: true, writeConcern:
{ j: true }, updates: [ { q:
{ _id: ObjectId('5cd6e558d12f840077d79eb9') }, u: { _id: ObjectId('5cd6e558d12f840077d79eb9'), im: "ebca3a98c70b8de169f2231195ca4f24", h: "www.aaaa.cc", nm: "nm-string", ch: "string", u: "html_addr", s: 1, ut: 1558001574941 }, upsert: true } ] } numYields:0 reslen:119 locks:{ Global: { acquireCount:
{ r: 2, w: 2 }}, Database: { acquireCount:
{ w: 2 }}, Collection: { acquireCount:
{ w: 1 }}, Metadata: { acquireCount:
{ w: 1 }}, oplog: { acquireCount:
{ w: 1 }} } protocol:op_query 1571ms
but i saw the secton of locks , cound't find anything valuable .
version of mongodb is 3.4.17
how can i found this 1571ms costed by which section of mongodb.