Skip to content

Instantly share code, notes, and snippets.

@alexdong
Created March 18, 2011 11:34
Show Gist options
  • Save alexdong/875918 to your computer and use it in GitHub Desktop.
Save alexdong/875918 to your computer and use it in GitHub Desktop.
> db.stats()
{
"collections" : 31,
"objects" : 33273261,
"avgObjSize" : 276.750695520947,
"dataSize" : 9208398124,
"storageSize" : 10635470336,
"numExtents" : 242,
"indexes" : 58,
"indexSize" : 10991725824,
"fileSize" : 25691160576,
"ok" : 1
}
// db.url and db.link are the two collections
// that I've seen "write lock" X mark from the
// http interface.
> db.url.stats()
{
"ns" : "trunkly.url",
"count" : 8026219,
"size" : 2198682488,
"avgObjSize" : 273.93751503665675,
"storageSize" : 2739354880,
"numExtents" : 28,
"nindexes" : 3,
"lastExtentSize" : 463082496,
"paddingFactor" : 1.7399999999955535,
"flags" : 1,
"totalIndexSize" : 2504198976,
"indexSizes" : {
"_id_" : 957588416,
"tags.tag_1_uc_-1" : 767083456,
"tags.tag_1_dtl_-1" : 779527104
},
"ok" : 1
}
> db.link.stats()
{
"ns" : "trunkly.link",
"count" : 11018081,
"size" : 4445501824,
"avgObjSize" : 403.4733293392924,
"storageSize" : 4762098432,
"numExtents" : 31,
"nindexes" : 5,
"lastExtentSize" : 800206080,
"paddingFactor" : 1.5899999999971621,
"flags" : 1,
"totalIndexSize" : 5337117376,
"indexSizes" : {
"_id_" : 1473086400,
"u_1_s_1_dt_-1" : 841008064,
"u_1_dt_-1" : 450839488,
"u_1_e_1_dt_-1" : 1153614784,
"lh_1_dt_-1" : 1418568640
},
"ok" : 1
}
// db.schedule is heavily updated.
// The modification usually involves timestamp refresh.
> db.schedule.stats()
{
"ns" : "trunkly.schedule",
"count" : 18636,
"size" : 671152,
"avgObjSize" : 36.013736853402015,
"storageSize" : 2793472,
"numExtents" : 5,
"nindexes" : 2,
"lastExtentSize" : 2097152,
"paddingFactor" : 1,
"flags" : 1,
"totalIndexSize" : 1671168,
"indexSizes" : {
"_id_" : 729088,
"n_-1" : 942080
},
"ok" : 1
}
// db.link, db.url and db.source are the
// most heavily read collection.
> db.source.stats()
{
"ns" : "trunkly.source",
"count" : 19679,
"size" : 18465300,
"avgObjSize" : 938.3251181462473,
"storageSize" : 34590976,
"numExtents" : 4,
"nindexes" : 2,
"lastExtentSize" : 32914688,
"paddingFactor" : 1.579999999999991,
"flags" : 1,
"totalIndexSize" : 1990656,
"indexSizes" : {
"_id_" : 770048,
"u_1_s_1_i_1" : 1220608
},
"ok" : 1
}
// db.timeline and db.url.comments
// have lots of insertions.
db.timeline.stats()
{
"ns" : "trunkly.timeline",
"count" : 9679549,
"size" : 1929403956,
"avgObjSize" : 199.32787736288125,
"storageSize" : 2276272384,
"numExtents" : 27,
"nindexes" : 4,
"lastExtentSize" : 385902080,
"paddingFactor" : 1.009999999999966,
"flags" : 1,
"totalIndexSize" : 2592395008,
"indexSizes" : {
"_id_" : 372499392,
"u_1_dt_-1" : 397968320,
"p_1_l_1" : 936010688,
"u_1_e_1_dt_-1" : 885916608
},
"ok" : 1
}
> db.url.comments.stats()
{
"ns" : "trunkly.url.comments",
"count" : 113945,
"size" : 62748940,
"avgObjSize" : 550.6949844223091,
"storageSize" : 81710848,
"numExtents" : 7,
"nindexes" : 1,
"lastExtentSize" : 25002240,
"paddingFactor" : 1.009999999999998,
"flags" : 1,
"totalIndexSize" : 10207232,
"indexSizes" : {
"_id_" : 10207232
},
"ok" : 1
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment