-
Type: Bug
-
Resolution: Done
-
Priority: Major - P3
-
Affects Version/s: 1.6.2, 1.7.0
-
Component/s: Performance
-
None
-
Environment:ubuntu 9.10
24G RAM
the db is on a RAID0 of 2 disks
-
Linux
Here's some excerpt from the logs
Sun Sep 12 10:51:14 [conn6] Finding median for index:
between { : 24430203 } and { : 25662603 } took 3161 ms.
Sun Sep 12 10:51:36 [conn6] Finding median for index:
between { : 26814034 } and { : 27937206 } took 14448 ms.
Sun Sep 12 10:52:10 [conn6] Finding median for index:
between { : 22297203 } and { : 23324407 } took 2012 ms.
Sun Sep 12 10:52:55 [conn6] Finding median for index:
between { : 60706232 } and { : 62958603 } took 23454 ms.
Sun Sep 12 10:53:05 [conn6] Finding median for index:
between { : 25662603 } and { : 26814034 } took 3050 ms.
Sun Sep 12 10:53:09 [conn6] Finding median for index:
between { : 23324407 } and { : 24430203 } took 2804 ms.
Sun Sep 12 10:53:34 [conn6] Finding median for index:
between { : 37270223 } and { : 38933407 } took 24029 ms.
Sun Sep 12 10:54:19 [conn6] Finding median for index:
between { : 40766434 } and { : 42625800 } took 13718 ms.
Sun Sep 12 10:54:53 [conn6] Finding median for index:
between { : 58696810 } and { : 60706232 } took 11311 ms.
Sun Sep 12 10:55:11 [conn6] Finding median for index:
between { : 30362400 } and { : 31572033 } took 9520 ms.
Sun Sep 12 10:55:35 [conn6] Finding median for index:
between { : 72665435 } and { : 96292200 } took 7396 ms.
Sun Sep 12 10:55:53 [conn6] Finding median for index:
between { : 68727613 } and { : 72665435 } took 7880 ms.
Sun Sep 12 10:56:04 [conn6] Finding median for index:
between { : 38933407 } and { : 40766434 } took 10045 ms.
Sun Sep 12 10:56:43 [conn6] Finding median for index:
between { : 35630403 } and { : 37270223 } took 7486 ms.
Sun Sep 12 14:31:02 [conn10] Finding median for index:
between { : 65599205 } and { : 68727613 } took 95402 ms.
Sun Sep 12 14:32:34 [conn10] Finding median for index:
between { : 62958603 } and { : 65599205 } took 72608 ms.
Sun Sep 12 14:34:19 [conn6] Finding median for index:
between { : 56850022 } and { : 58696810 } took 58778 ms.
Sun Sep 12 14:35:20 [conn6] Finding median for index:
between { : 55276200 } and { : 56850022 } took 50957 ms.
Sun Sep 12 14:43:17 [conn6] Finding median for index:
between { : 45860418 } and { : 47944851 } took 47859 ms.
Sun Sep 12 14:44:10 [conn6] Finding median for index:
between { : 51170454 } and { : 52417803 } took 38282 ms.
Sun Sep 12 14:44:47 [conn6] Finding median for index:
between { : 53762457 } and { : 55276200 } took 27610 ms.
Sun Sep 12 14:45:55 [conn6] Finding median for index:
between { : 42625800 } and { : 44283041 } took 34589 ms.
Sun Sep 12 14:46:19 [conn6] Finding median for index:
between { : 47944851 } and { : 49876203 } took 17147 ms.
Sun Sep 12 14:47:07 [conn6] Finding median for index:
between { : 49876203 } and { : 51170454 } took 23866 ms.
Sun Sep 12 14:47:48 [conn6] Finding median for index:
between { : 44283041 } and { : 45860418 } took 18224 ms.
Sun Sep 12 14:48:53 [conn6] Finding median for index:
between { : 52417803 } and { : 53762457 } took 21154 ms.
The indexes surely fit in memory. The whole DB does!
> db.answers.stats()
{
"sharded" : true,
"ns" : "pravdorub_production.answers",
"count" : 273039209,
"size" : 33919877756,
"avgObjSize" : 124.23079410547223,
"storageSize" : 39745093120,
"nindexes" : 2,
"nchunks" : 92,
"shards" : {
"brussels" : {
"ns" : "pravdorub_production.answers",
"count" : 136990615,
"size" : 17019609560,
"avgObjSize" : 124.23923755652896,
"storageSize" : 19872546560,
"numExtents" : 40,
"nindexes" : 2,
"lastExtentSize" : 1991168256,
"paddingFactor" : 1,
"flags" : 1,
"totalIndexSize" : 14175980928,
"indexSizes" :
,
"ok" : 1
},
"moscow" : {
"ns" : "pravdorub_production.answers",
"count" : 136048594,
"size" : 16900268196,
"avgObjSize" : 124.22229219068592,
"storageSize" : 19872546560,
"numExtents" : 40,
"nindexes" : 2,
"lastExtentSize" : 1991168256,
"paddingFactor" : 1,
"flags" : 1,
"totalIndexSize" : 13670329728,
"indexSizes" :
,
"ok" : 1
}
},
"ok" : 1
}
> db.stats()
{
"raw" : {
"brussels/moskau8:27018" :
,
"moscow/moskau7:27018" :
},
"objects" : 273408929,
"avgObjSize" : 124.23096107442782,
"dataSize" : 33965854016,
"storageSize" : 39745109248,
"numExtents" : 84,
"indexes" : 4,
"indexSize" : 27883469568,
"fileSize" : 90018152448,
"ok" : 1
}