-
Type:
Question
-
Resolution: Incomplete
-
Priority:
Major - P3
-
None
-
Affects Version/s: 2.4.10
-
Component/s: Index Maintenance, Querying
-
None
-
None
-
None
-
None
-
None
-
None
-
None
-
None
I used mongodb 2.4.10 to collect some app logs, sometimes when i statistics and analysis, i execute a same command, but give me different result:
logReplSet:PRIMARY> db.ofapi_inf_record_20140825.count({"invokeTime":{"$gte":"2014-08-29 19:30:52","$lte":"2014-08-29 19:41:52"},"exceptionMsg":{"$ne":null}})
86
logReplSet:PRIMARY> db.ofapi_inf_record_20140825.count({"invokeTime":{"$gte":"2014-08-29 19:30:52","$lte":"2014-08-29 19:41:52"},"exceptionMsg":{"$ne":null}})
47
logReplSet:PRIMARY> db.ofapi_inf_record_20140825.count({"invokeTime":{"$gte":"2014-08-29 19:30:52","$lte":"2014-08-29 19:41:52"},"exceptionMsg":{"$ne":null}})
47
logReplSet:PRIMARY> db.ofapi_inf_record_20140825.count({"invokeTime":{"$gte":"2014-08-29 19:30:52","$lte":"2014-08-29 19:41:52"},"exceptionMsg":{"$ne":null}})
47
logReplSet:PRIMARY> db.ofapi_inf_record_20140825.count({"invokeTime":{"$gte":"2014-08-29 19:30:52","$lte":"2014-08-29 19:41:52"},"exceptionMsg":{"$ne":null}})
47
the current db and collection status:
logReplSet:PRIMARY> db.stats()
{
"db" : "logs",
"collections" : 45,
"objects" : 2108341434,
"avgObjSize" : 747.0257969857837,
"dataSize" : NumberLong("1574985440052"),
"storageSize" : NumberLong("1634846926048"),
"numExtents" : 1303,
"indexes" : 230,
"indexSize" : 661429905136,
"fileSize" : NumberLong("2365305389056"),
"nsSizeMB" : 16,
"dataFileVersion" : {
"major" : 4,
"minor" : 5
},
"ok" : 1
}
logReplSet:PRIMARY> db.ofapi_inf_record_20140825.stats()
{
"ns" : "logs.ofapi_inf_record_20140825",
"count" : 45681275,
"size" : 45292806320,
"avgObjSize" : 991.496106884057,
"storageSize" : 47941103312,
"numExtents" : 43,
"nindexes" : 6,
"lastExtentSize" : 2146426864,
"paddingFactor" : 1,
"systemFlags" : 1,
"userFlags" : 0,
"totalIndexSize" : 18175558688,
"indexSizes" : {
"_id_" : 1482316976,
"invokeTime_-1.0_methodName_1.0" : 7287988288,
"uuId_1.0" : 3596499760,
"paramValues.userCode_1.0" : 1950908064,
"costTime_-1.0" : 2296245952,
"exceptionMsg_1.0" : 1561599648
},
"ok" : 1
}
Mongodb Logs: (first cost 51952ms )
Mon Sep 1 08:59:27.659 [conn5901521] command logs.$cmd command: { count: "ofapi_inf_record_20140825", query: { invokeTime: { $gte: "2014-08-29 19:30:52", $lte: "2014-08-29 19:41:52" }, exceptionMsg: { $ne: null } }, fields: {} } ntoreturn:1 keyUpdates:0 numYields: 1494 locks(micros) r:101254026 reslen:48 51952ms
Mon Sep 1 08:59:55.252 [conn5901521] command logs.$cmd command: { count: "ofapi_inf_record_20140825", query: { invokeTime: { $gte: "2014-08-29 19:30:52", $lte: "2014-08-29 19:41:52" }, exceptionMsg: { $ne: null } }, fields: {} } ntoreturn:1 keyUpdates:0 numYields: 1 locks(micros) r:317472 reslen:48 169ms
Mon Sep 1 09:03:27.404 [conn5901521] command logs.$cmd command: { count: "ofapi_inf_record_20140825", query: { invokeTime: { $gte: "2014-08-29 19:30:52", $lte: "2014-08-29 19:41:52" }, exceptionMsg: { $ne: null } }, fields: {} } ntoreturn:1 keyUpdates:0 numYields: 2 locks(micros) r:292434 reslen:48 169ms
Mon Sep 1 09:03:29.201 [conn5901521] command logs.$cmd command: { count: "ofapi_inf_record_20140825", query: { invokeTime: { $gte: "2014-08-29 19:30:52", $lte: "2014-08-29 19:41:52" }, exceptionMsg: { $ne: null } }, fields: {} } ntoreturn:1 keyUpdates:0 locks(micros) r:162235 reslen:48 162ms
Mon Sep 1 09:22:09.624 [conn5901521] command logs.$cmd command: { count: "ofapi_inf_record_20140825", query: { invokeTime: { $gte: "2014-08-29 19:30:52", $lte: "2014-08-29 19:41:52" }, exceptionMsg: { $ne: null } }, fields: {} } ntoreturn:1 keyUpdates:0 numYields: 281 locks(micros) r:373800 reslen:48 380ms