mongo remove id - Githubissues

FS1360472174 / nosql-mongo

mongo knowledge

4 stars 4 forks source link

mongo remove id #38

Open FS1360472174 opened 6 years ago

FS1360472174 commented 6 years ago

两百万的数据，主键remove，单条花了0.4ms

op: "remove", ns: "test", query: { id: { $in: [ "111" ] } }, ndeleted: 0, keyUpdates: 0, writeConflicts: 0, numYield: 6769, locks: { Global: { acquireCount: { r: NumberLong(6770), w: NumberLong(6770) } }, Database: { acquireCount: { w: NumberLong(6770) } }, Collection: { acquireCount: { w: NumberLong(6770) } } }, millis: 416, execStats: { }, ts: ISODate("2017-09-21T05:19:46.827Z"),

FS1360472174 commented 6 years ago

numOfYield 表示完成这个操作之前为其他的操作让出线程的次数。比如想访问的数据没有到内存中

https://docs.mongodb.com/manual/reference/database-profiler/