Skip to content

Instantly share code, notes, and snippets.

@greglu

greglu/gist:749016

Created December 20, 2010 21:22
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save greglu/749016 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save greglu/749016 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.js
> db.runCommand( { listshards : 1 } );
{
"shards" : [
{
"_id" : "node02",
"host" : "node02/node02.lab.mtl:27020,node03.lab.mtl:27020"
},
{
"_id" : "node04",
"host" : "node04/node04.lab.mtl:27020,node05.lab.mtl:27020"
},
{
"_id" : "node06",
"host" : "node06/node06.lab.mtl:27020,node07.lab.mtl:27020"
},
{
"_id" : "node08",
"host" : "node08/node08.lab.mtl:27020,node09.lab.mtl:27020"
},
{
"_id" : "node10",
"host" : "node10/node10.lab.mtl:27020,node11.lab.mtl:27020"
},
{
"_id" : "node12",
"host" : "node12/node12.lab.mtl:27020,node13.lab.mtl:27020"
},
{
"_id" : "node14",
"host" : "node14/node14.lab.mtl:27020,node15.lab.mtl:27020"
},
{
"_id" : "node16",
"host" : "node16/node16.lab.mtl:27020,node17.lab.mtl:27020"
}
],
"ok" : 1
}
> db.printShardingStatus()
--- Sharding Status ---
sharding version: { "_id" : 1, "version" : 3 }
shards:
{
"_id" : "node02",
"host" : "node02/node02.lab.mtl:27020,node03.lab.mtl:27020"
}
{
"_id" : "node04",
"host" : "node04/node04.lab.mtl:27020,node05.lab.mtl:27020"
}
{
"_id" : "node06",
"host" : "node06/node06.lab.mtl:27020,node07.lab.mtl:27020"
}
{
"_id" : "node08",
"host" : "node08/node08.lab.mtl:27020,node09.lab.mtl:27020"
}
{
"_id" : "node10",
"host" : "node10/node10.lab.mtl:27020,node11.lab.mtl:27020"
}
{
"_id" : "node12",
"host" : "node12/node12.lab.mtl:27020,node13.lab.mtl:27020"
}
{
"_id" : "node14",
"host" : "node14/node14.lab.mtl:27020,node15.lab.mtl:27020"
}
{
"_id" : "node16",
"host" : "node16/node16.lab.mtl:27020,node17.lab.mtl:27020"
}
databases:
{ "_id" : "admin", "partitioned" : false, "primary" : "config" }
{ "_id" : "test", "partitioned" : true, "primary" : "node02" }
test.shard_test2 chunks:
{ "num" : { $minKey : 1 } } -->> { "num" : 1 } on : node16 { "t" : 17000, "i" : 0 }
{ "num" : 1 } -->> { "num" : 568 } on : node02 { "t" : 2000, "i" : 4 }
{ "num" : 568 } -->> { "num" : 1203 } on : node02 { "t" : 2000, "i" : 5 }
{ "num" : 1203 } -->> { "num" : 2147 } on : node02 { "t" : 3000, "i" : 1 }
{ "num" : 2147 } -->> { "num" : 3092 } on : node16 { "t" : 18000, "i" : 0 }
{ "num" : 3092 } -->> { "num" : 4037 } on : node16 { "t" : 19000, "i" : 0 }
{ "num" : 4037 } -->> { "num" : 4982 } on : node04 { "t" : 4000, "i" : 4 }
{ "num" : 4982 } -->> { "num" : 5927 } on : node04 { "t" : 5000, "i" : 1 }
{ "num" : 5927 } -->> { "num" : 6872 } on : node06 { "t" : 5000, "i" : 2 }
{ "num" : 6872 } -->> { "num" : 8762 } on : node06 { "t" : 6000, "i" : 1 }
{ "num" : 8762 } -->> { "num" : 10652 } on : node08 { "t" : 6000, "i" : 2 }
{ "num" : 10652 } -->> { "num" : 12542 } on : node08 { "t" : 6000, "i" : 4 }
{ "num" : 12542 } -->> { "num" : 14432 } on : node08 { "t" : 7000, "i" : 1 }
{ "num" : 14432 } -->> { "num" : 16322 } on : node10 { "t" : 8000, "i" : 1 }
{ "num" : 16322 } -->> { "num" : 18212 } on : node12 { "t" : 8000, "i" : 2 }
{ "num" : 18212 } -->> { "num" : 20102 } on : node12 { "t" : 9000, "i" : 1 }
{ "num" : 20102 } -->> { "num" : 21992 } on : node16 { "t" : 20000, "i" : 0 }
{ "num" : 21992 } -->> { "num" : 23882 } on : node14 { "t" : 9000, "i" : 4 }
{ "num" : 23882 } -->> { "num" : 25772 } on : node14 { "t" : 10000, "i" : 1 }
{ "num" : 25772 } -->> { "num" : 29547 } on : node04 { "t" : 10000, "i" : 2 }
{ "num" : 29547 } -->> { "num" : 33322 } on : node04 { "t" : 10000, "i" : 4 }
{ "num" : 33322 } -->> { "num" : 37097 } on : node04 { "t" : 19000, "i" : 1 }
{ "num" : 37097 } -->> { "num" : 40872 } on : node06 { "t" : 11000, "i" : 2 }
{ "num" : 40872 } -->> { "num" : 44647 } on : node06 { "t" : 11000, "i" : 4 }
{ "num" : 44647 } -->> { "num" : 48422 } on : node06 { "t" : 12000, "i" : 1 }
{ "num" : 48422 } -->> { "num" : 52197 } on : node08 { "t" : 12000, "i" : 2 }
{ "num" : 52197 } -->> { "num" : 55972 } on : node08 { "t" : 13000, "i" : 1 }
{ "num" : 55972 } -->> { "num" : 59747 } on : node10 { "t" : 13000, "i" : 2 }
{ "num" : 59747 } -->> { "num" : 63522 } on : node10 { "t" : 13000, "i" : 4 }
{ "num" : 63522 } -->> { "num" : 67297 } on : node10 { "t" : 14000, "i" : 1 }
{ "num" : 67297 } -->> { "num" : 71072 } on : node12 { "t" : 14000, "i" : 2 }
{ "num" : 71072 } -->> { "num" : 74847 } on : node12 { "t" : 14000, "i" : 4 }
{ "num" : 74847 } -->> { "num" : 78622 } on : node12 { "t" : 15000, "i" : 1 }
{ "num" : 78622 } -->> { "num" : 82397 } on : node14 { "t" : 15000, "i" : 2 }
{ "num" : 82397 } -->> { "num" : 86172 } on : node14 { "t" : 15000, "i" : 4 }
{ "num" : 86172 } -->> { "num" : 89947 } on : node14 { "t" : 20000, "i" : 1 }
{ "num" : 89947 } -->> { "num" : { $maxKey : 1 } } on : node02 { "t" : 16000, "i" : 0 }
{ "_id" : "local", "partitioned" : false, "primary" : "node02" }
> db.shard_test2.stats()
{
"sharded" : true,
"ns" : "test.shard_test2",
"count" : 200000,
"size" : 10012058720,
"avgObjSize" : 50060.2936,
"storageSize" : 11008873472,
"nindexes" : 2,
"nchunks" : 37,
"shards" : {
"node02" : {
"ns" : "test.shard_test2",
"count" : 112200,
"size" : 5616747900,
"avgObjSize" : 50060.141711229946,
"storageSize" : 6052865024,
"numExtents" : 28,
"nindexes" : 2,
"lastExtentSize" : 1018820352,
"paddingFactor" : 1,
"flags" : 1,
"totalIndexSize" : 8822784,
"indexSizes" : {
"_id_" : 4661248,
"num_1" : 4161536
},
"ok" : 1
},
"node04" : {
"ns" : "test.shard_test2",
"count" : 13215,
"size" : 661545080,
"avgObjSize" : 50060.164964056,
"storageSize" : 762665984,
"numExtents" : 17,
"nindexes" : 2,
"lastExtentSize" : 137121280,
"paddingFactor" : 1,
"flags" : 1,
"totalIndexSize" : 1064960,
"indexSizes" : {
"_id_" : 565248,
"num_1" : 499712
},
"ok" : 1
},
"node06" : {
"ns" : "test.shard_test2",
"count" : 14160,
"size" : 708857728,
"avgObjSize" : 50060.57401129943,
"avgObjSize" : 50060.57401129943,
"storageSize" : 762665984,
"numExtents" : 17,
"nindexes" : 2,
"lastExtentSize" : 137121280,
"paddingFactor" : 1,
"flags" : 1,
"totalIndexSize" : 1130496,
"indexSizes" : {
"_id_" : 598016,
"num_1" : 532480
},
"ok" : 1
},
"node08" : {
"ns" : "test.shard_test2",
"count" : 13220,
"size" : 661801328,
"avgObjSize" : 50060.61482602118,
"storageSize" : 762665984,
"numExtents" : 17,
"nindexes" : 2,
"lastExtentSize" : 137121280,
"paddingFactor" : 1,
"flags" : 1,
"totalIndexSize" : 1056768,
"indexSizes" : {
"_id_" : 557056,
"num_1" : 499712
},
"ok" : 1
},
"node10" : {
"ns" : "test.shard_test2",
"count" : 13215,
"size" : 661551028,
"avgObjSize" : 50060.615058645475,
"storageSize" : 762665984,
"numExtents" : 17,
"nindexes" : 2,
"lastExtentSize" : 137121280,
"paddingFactor" : 1,
"flags" : 1,
"totalIndexSize" : 1056768,
"indexSizes" : {
"_id_" : 557056,
"num_1" : 499712
},
"ok" : 1
},
"node12" : {
"ns" : "test.shard_test2",
"count" : 15105,
"size" : 756164428,
"avgObjSize" : 50060.5380999669,
"storageSize" : 762665984,
"numExtents" : 17,
"nindexes" : 2,
"lastExtentSize" : 137121280,
"paddingFactor" : 1,
"flags" : 1,
"totalIndexSize" : 1196032,
"indexSizes" : {
"_id_" : 630784,
"num_1" : 565248
},
"ok" : 1
},
"node14" : {
"ns" : "test.shard_test2",
"count" : 15105,
"size" : 756158480,
"avgObjSize" : 50060.14432307183,
"storageSize" : 927211520,
"numExtents" : 18,
"nindexes" : 2,
"lastExtentSize" : 164545536,
"paddingFactor" : 1,
"flags" : 1,
"totalIndexSize" : 1212416,
"indexSizes" : {
"_id_" : 638976,
"num_1" : 573440
},
"ok" : 1
},
"node16" : {
"ns" : "test.shard_test2",
"count" : 3780,
"size" : 189232748,
"avgObjSize" : 50061.573544973544,
"storageSize" : 215467008,
"numExtents" : 11,
"nindexes" : 2,
"lastExtentSize" : 45922048,
"paddingFactor" : 1,
"flags" : 1,
"totalIndexSize" : 311296,
"indexSizes" : {
"_id_" : 163840,
"num_1" : 147456
},
"ok" : 1
}
},
"ok" : 1
}
> use config
switched to db config
> db.settings.find()
{ "_id" : "chunksize", "value" : 200 }
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment