mongodb数据库及集合status详解

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: 集合索引列表及每个索引占用大小