Skip to content

Instantly share code, notes, and snippets.

@kgorman
Last active August 29, 2015 14:06
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kgorman/f985be1267cbd2cccd1d to your computer and use it in GitHub Desktop.
Save kgorman/f985be1267cbd2cccd1d to your computer and use it in GitHub Desktop.
TokuMX space v2
// none
> db.ocean_data.stats()
{
"ns" : "kg_spacetest.ocean_data",
"count" : 530679,
"nindexes" : 2,
"nindexesbeingbuilt" : 2,
"size" : 229294009,
"storageSize" : 234881024,
"totalIndexSize" : 13386352,
"totalIndexStorageSize" : 37748736,
"indexDetails" : [
{
"name" : "_id_",
"count" : 530679,
"size" : 229294009,
"avgObjSize" : 432.07665839424584,
"storageSize" : 234881024,
"pageSize" : 4194304,
"readPageSize" : 65536,
"fanout" : 16,
"compression" : "uncompressed",
"queries" : 1,
"nscanned" : 0,
"nscannedObjects" : 0,
"inserts" : 530680,
"deletes" : 0
},
{
"name" : "station_id_1",
"count" : 478084,
"size" : 13386352,
"avgObjSize" : 28,
"storageSize" : 37748736,
"pageSize" : 4194304,
"readPageSize" : 65536,
"fanout" : 16,
"compression" : "uncompressed",
"queries" : 0,
"nscanned" : 0,
"nscannedObjects" : 0,
"inserts" : 530680,
"deletes" : 0
}
],
"ok" : 1
}
> db.stats()
{
"db" : "kg_spacetest",
"collections" : 6,
"objects" : 531098,
"avgObjSize" : 432.0821373833078,
"dataSize" : 229477959,
"storageSize" : 235037696,
"indexes" : 8,
"indexSize" : 14030964,
"indexStorageSize" : 37789696,
"ok" : 1
}
>
// quicklz
> db.ocean_data.stats()
{
"ns" : "kg_spacetest.ocean_data",
"count" : 530680,
"nindexes" : 2,
"nindexesbeingbuilt" : 2,
"size" : 229294480,
"storageSize" : 67108864,
"totalIndexSize" : 14859040,
"totalIndexStorageSize" : 20971520,
"indexDetails" : [
{
"name" : "_id_",
"count" : 530680,
"size" : 229294480,
"avgObjSize" : 432.07673174040855,
"storageSize" : 67108864,
"pageSize" : 4194304,
"readPageSize" : 65536,
"fanout" : 16,
"compression" : "quicklz",
"queries" : 1,
"nscanned" : 0,
"nscannedObjects" : 0,
"inserts" : 530680,
"deletes" : 0
},
{
"name" : "station_id_1",
"count" : 530680,
"size" : 14859040,
"avgObjSize" : 28,
"storageSize" : 20971520,
"pageSize" : 4194304,
"readPageSize" : 65536,
"fanout" : 16,
"compression" : "quicklz",
"queries" : 0,
"nscanned" : 0,
"nscannedObjects" : 0,
"inserts" : 530680,
"deletes" : 0
}
],
"ok" : 1
}
> db.stats()
{
"db" : "kg_spacetest",
"collections" : 6,
"objects" : 531095,
"avgObjSize" : 432.0845950347866,
"dataSize" : 229477968,
"storageSize" : 67265536,
"indexes" : 8,
"indexSize" : 14859064,
"indexStorageSize" : 21012480,
"ok" : 1
}
// lzma
> db.ocean_data.stats()
{
"ns" : "kg_spacetest.ocean_data",
"count" : 530680,
"nindexes" : 2,
"nindexesbeingbuilt" : 2,
"size" : 229294480,
"storageSize" : 50331648,
"totalIndexSize" : 14848904,
"totalIndexStorageSize" : 5242880,
"indexDetails" : [
{
"name" : "_id_",
"count" : 530680,
"size" : 229294480,
"avgObjSize" : 432.07673174040855,
"storageSize" : 50331648,
"pageSize" : 4194304,
"readPageSize" : 65536,
"fanout" : 16,
"compression" : "lzma",
"queries" : 1,
"nscanned" : 0,
"nscannedObjects" : 0,
"inserts" : 530680,
"deletes" : 0
},
{
"name" : "station_id_1",
"count" : 530318,
"size" : 14848904,
"avgObjSize" : 28,
"storageSize" : 5242880,
"pageSize" : 4194304,
"readPageSize" : 65536,
"fanout" : 16,
"compression" : "lzma",
"queries" : 0,
"nscanned" : 0,
"nscannedObjects" : 0,
"inserts" : 530680,
"deletes" : 0
}
],
"ok" : 1
}
> db.stats()
{
"db" : "kg_spacetest",
"collections" : 6,
"objects" : 531098,
"avgObjSize" : 432.0821373833078,
"dataSize" : 229477959,
"storageSize" : 50488320,
"indexes" : 8,
"indexSize" : 14859064,
"indexStorageSize" : 10526720,
"ok" : 1
}
// zlib
> db.ocean_data.stats()
{
"ns" : "kg_spacetest.ocean_data",
"count" : 530680,
"nindexes" : 2,
"nindexesbeingbuilt" : 2,
"size" : 229294480,
"storageSize" : 50331648,
"totalIndexSize" : 14151648,
"totalIndexStorageSize" : 20971520,
"indexDetails" : [
{
"name" : "_id_",
"count" : 530680,
"size" : 229294480,
"avgObjSize" : 432.07673174040855,
"storageSize" : 50331648,
"pageSize" : 4194304,
"readPageSize" : 65536,
"fanout" : 16,
"compression" : "zlib",
"queries" : 1,
"nscanned" : 0,
"nscannedObjects" : 0,
"inserts" : 530680,
"deletes" : 0
},
{
"name" : "station_id_1",
"count" : 505416,
"size" : 14151648,
"avgObjSize" : 28,
"storageSize" : 20971520,
"pageSize" : 4194304,
"readPageSize" : 65536,
"fanout" : 16,
"compression" : "zlib",
"queries" : 0,
"nscanned" : 0,
"nscannedObjects" : 0,
"inserts" : 530680,
"deletes" : 0
}
],
"ok" : 1
}
>
> db.stats()
{
"db" : "kg_spacetest",
"collections" : 6,
"objects" : 531095,
"avgObjSize" : 432.08457808866586,
"dataSize" : 229477959,
"storageSize" : 50488320,
"indexes" : 8,
"indexSize" : 13632468,
"indexStorageSize" : 21012480,
"ok" : 1
}
// mongodb
> db.ocean_data.stats()
{
"ns" : "kg_spacetest.ocean_data",
"count" : 530680,
"size" : 283525248,
"avgObjSize" : 534,
"storageSize" : 335900672,
"numExtents" : 14,
"nindexes" : 1,
"lastExtentSize" : 92585984,
"paddingFactor" : 1,
"systemFlags" : 1,
"userFlags" : 1,
"totalIndexSize" : 30692704,
"indexSizes" : {
"_id_" : 30692704
},
"ok" : 1
}
> db.stats()
{
"db" : "kg_spacetest",
"collections" : 6,
"objects" : 531089,
"avgObjSize" : 534.3929623848356,
"dataSize" : 283810224,
"storageSize" : 336629760,
"numExtents" : 22,
"indexes" : 4,
"indexSize" : 30733584,
"fileSize" : 520093696,
"nsSizeMB" : 16,
"dataFileVersion" : {
"major" : 4,
"minor" : 5
},
"extentFreeList" : {
"num" : 0,
"totalSize" : 0
},
"ok" : 1
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment