db.xxx
db.stats()
返回整个数据库的基本情况,可以传入一个number类型参数
如db.stats(1024)
则按kb显示数据,默认按byte显示:
db.stats(1024)
// 1
{
"db": "carnetwork",
"collections": NumberInt("26"),
"objects": NumberInt("93762839"),
"avgObjSize": 3088.92759086572,
"dataSize": 282838496.469727,
"storageSize": 155959280,
"numExtents": NumberInt("0"),
"indexes": NumberInt("79"),
"indexSize": 8275208,
"ok": 1
}
db:数据库
collections:数据库有多少个集合;可通过运行show collections查看当前数据库具体有哪些集合
objects:当前数据库所有collection总共有多少行数据。显示的数据是一个估计值,并不是非常精确
avgObjSize:每行数据的大小,估计值,单位bytes
dataSize:当前数据库所有数据的总大小,不是指占有磁盘大小。单位bytes
storageSize:当前数据库占有磁盘大小,单位bytes,因为mongodb有预分配空间机制,为了防止当有大量数据插入时对磁盘的压力,因此会事先多分配磁盘空间
numExtents:连续分配的数据块
indexes:索引个数
indexSize:索引占用空间大小
nsSizeMB:命名空间文件大小
db.xxx.status() 显示集合基本情况
// 1
{
"ns": "carnetwork.actia_0a07",
"count": NumberInt("16898"),
"size": NumberInt("66191900"),
"avgObjSize": NumberInt("3917"),
"storageSize": 51761475584,
"capped": false,
"wiredTiger": {
"metadata": {
"formatVersion": NumberInt("1")
},
"creationString": "allocation_size=4KB,app_metadata=(formatVersion=1),block_allocation=best,block_compressor=snappy,cache_resident=0,checksum=on,colgroups=,collator=,columns=,dictionary=0,encryption=(keyid=,name=),exclusive=0,extractor=,format=btree,huffman_key=,huffman_value=,immutable=0,internal_item_max=0,internal_key_max=0,internal_key_truncate=,internal_page_max=4KB,key_format=q,key_gap=10,leaf_item_max=0,leaf_key_max=0,leaf_page_max=32KB,leaf_value_max=64MB,log=(enabled=),lsm=(auto_throttle=,bloom=,bloom_bit_count=16,bloom_config=,bloom_hash_count=8,bloom_oldest=0,chunk_count_limit=0,chunk_max=5GB,chunk_size=10MB,merge_max=15,merge_min=0),memory_page_max=10m,os_cache_dirty_max=0,os_cache_max=0,prefix_compression=0,prefix_compression_min=4,source=,split_deepen_min_child=0,split_deepen_per_child=0,split_pct=90,type=file,value_format=u",
"type": "file",
"uri": "statistics:table:collection-4--5039472950115613557",
"LSM": {
"bloom filter false positives": NumberInt("0"),
"bloom filter hits": NumberInt("0"),
"bloom filter misses": NumberInt("0"),
"bloom filter pages evicted from cache": NumberInt("0"),
"bloom filter pages read into cache": NumberInt("0"),
"bloom filters in the LSM tree": NumberInt("0"),
"chunks in the LSM tree": NumberInt("0"),
"highest merge generation in the LSM tree": NumberInt("0"),
"queries that could have benefited from a Bloom filter that did not exist": NumberInt("0"),
"sleep for LSM checkpoint throttle": NumberInt("0"),
"sleep for LSM merge throttle": NumberInt("0"),
"total size of bloom filters": NumberInt("0")
},
"block-manager": {
"allocations requiring file extension": NumberInt("0"),
"blocks allocated": NumberInt("8665"),
"blocks freed": NumberInt("6828"),
"checkpoint size": 2361110528,
"file allocation unit size": NumberInt("4096"),
"file bytes available for reuse": 51741614080,
"file magic number": NumberInt("120897"),
"file major version number": NumberInt("1"),
"file size in bytes": 51761475584,
"minor version number": NumberInt("0")
},
"btree": {
"btree checkpoint generation": NumberInt("217"),
"column-store fixed-size leaf pages": NumberInt("0"),
"column-store internal pages": NumberInt("0"),
"column-store variable-size RLE encoded values": NumberInt("0"),
"column-store variable-size deleted values": NumberInt("0"),
"column-store variable-size leaf pages": NumberInt("0"),
"fixed-record size": NumberInt("0"),
"maximum internal page key size": NumberInt("368"),
"maximum internal page size": NumberInt("4096"),
"maximum leaf page key size": NumberInt("2867"),
"maximum leaf page size": NumberInt("32768"),
"maximum leaf page value size": NumberInt("67108864"),
"maximum tree depth": NumberInt("5"),
"number of key/value pairs": NumberInt("0"),
"overflow pages": NumberInt("0"),
"pages rewritten by compaction": NumberInt("0"),
"row-store internal pages": NumberInt("0"),
"row-store leaf pages": NumberInt("0")
},
"cache": {
"bytes read into cache": NumberInt("262363684"),
"bytes written from cache": NumberInt("137615406"),
"checkpoint blocked page eviction": NumberInt("0"),
"data source pages selected for eviction unable to be evicted": NumberInt("429"),
"hazard pointer blocked page eviction": NumberInt("13"),
"in-memory page passed criteria to be split": NumberInt("0"),
"in-memory page splits": NumberInt("0"),
"internal pages evicted": NumberInt("1360"),
"internal pages split during eviction": NumberInt("0"),
"leaf pages split during eviction": NumberInt("1156"),
"modified pages evicted": NumberInt("6562"),
"overflow pages read into cache": NumberInt("0"),
"overflow values cached in memory": NumberInt("0"),
"page split during eviction deepened the tree": NumberInt("0"),
"page written requiring lookaside records": NumberInt("0"),
"pages read into cache": NumberInt("12338"),
"pages read into cache requiring lookaside entries": NumberInt("0"),
"pages requested from the cache": NumberInt("3204442"),
"pages written from cache": NumberInt("8233"),
"pages written requiring in-memory restoration": NumberInt("0"),
"unmodified pages evicted": NumberInt("5773")
},
"compression": {
"compressed pages read": NumberInt("10967"),
"compressed pages written": NumberInt("6427"),
"page written failed to compress": NumberInt("0"),
"page written was too small to compress": NumberInt("1806"),
"raw compression call failed, additional data available": NumberInt("0"),
"raw compression call failed, no additional data available": NumberInt("0"),
"raw compression call succeeded": NumberInt("0")
},
"cursor": {
"bulk-loaded cursor-insert calls": NumberInt("0"),
"create calls": NumberInt("51"),
"cursor-insert key and value bytes inserted": NumberInt("32478596"),
"cursor-remove key bytes removed": NumberInt("0"),
"cursor-update value bytes updated": NumberInt("0"),
"insert calls": NumberInt("8284"),
"next calls": NumberInt("34235"),
"prev calls": NumberInt("1"),
"remove calls": NumberInt("0"),
"reset calls": NumberInt("8597"),
"restarted searches": NumberInt("1"),
"search calls": NumberInt("1126"),
"search near calls": NumberInt("274"),
"truncate calls": NumberInt("0"),
"update calls": NumberInt("0")
},
"reconciliation": {
"dictionary matches": NumberInt("0"),
"fast-path pages deleted": NumberInt("0"),
"internal page key bytes discarded using suffix compression": NumberInt("1933"),
"internal page multi-block writes": NumberInt("7"),
"internal-page overflow keys": NumberInt("0"),
"leaf page key bytes discarded using prefix compression": NumberInt("0"),
"leaf page multi-block writes": NumberInt("1158"),
"leaf-page overflow keys": NumberInt("0"),
"maximum blocks required for a page": NumberInt("2"),
"overflow values written": NumberInt("0"),
"page checksum matches": NumberInt("0"),
"page reconciliation calls": NumberInt("7035"),
"page reconciliation calls for eviction": NumberInt("6469"),
"pages deleted": NumberInt("0")
},
"session": {
"object compaction": NumberInt("0"),
"open cursor count": NumberInt("51")
},
"transaction": {
"update conflicts": NumberInt("0")
}
},
"nindexes": NumberInt("4"),
"totalIndexSize": NumberInt("2772992"),
"indexSizes": {
"_id_": NumberInt("319488"),
"uuid_1": NumberInt("1470464"),
"mobile_1_msgtime_-1": NumberInt("520192"),
"mobile_1_addtime_1": NumberInt("462848")
},
"ok": 1
}
解读:
ns:命名空间,集合名称
size:集合大小
count:集合中的文档总数
avgObjSize:每个obj的大小
storageSize:分配的存储空间,当删除集合中的文档时,此值不会降低
capped:是否固定集合
wiredTiger:wiredTiger储存引擎相关信息
nindexes:索引数量
totalIndexSize:索引占用磁盘大小
indexSizes: 集合索引列表及每个索引占用大小