mongodb库表信息监控脚本

var collnames=db.getCollectionNames();
//print(collnames)
var indexsize="";
var collline="";
var storagesize=""
var size=""
var count=""
/*print("|--------------------------------------------totalIndexSize----------------------------------------|")
for (coll in collnames)
{
    if(collnames[coll].substr(0,7)=='system.')
        continue;
    collline+=collnames[coll]+"   ";
    stats=db[collnames[coll]].stats();
//    print(collnames[coll]+": "+stats["totalIndexSize"]);
    indexsize=indexsize+"   "+stats["totalIndexSize"]
}
print("|"+collline+"|")
print("|"+indexsize+"|")
print("|--------------------------------------------totalIndexSize----------------------------------------|")
*/
print("******************"+db.getName()+"*******************")
for (coll in collnames)
{
        if(collnames[coll].substr(0,7)=='system.')
                continue;
    collline+=collnames[coll]+"   ";
        stats=db[collnames[coll]].stats();
    printjson(stats);
    indexsize=indexsize+"   "+stats["totalIndexSize"]
    storagesize=storagesize+"   "+stats["storageSize"]
    count=count+"   "+stats["count"]
    size=size+"   "+stats["size"]
}
print("******************"+db.getName()+"*******************")
print("|"+db.getName())
print("|-------------------------------------------[totalIndexSize]---------------------------------------|")
print("|"+collline+"|")
print("|"+indexsize+"|")
print("|-------------------------------------------[totalIndexSize]---------------------------------------|")
print("|-------------------------------------------[storageSize]------------------------------------------|")
print("|"+collline+"|")
print("|"+storagesize+"|")
print("|-------------------------------------------[storageSize]------------------------------------------|")
print("|-------------------------------------------[count]------------------------------------------------|")
print("|"+collline+"|")
print("|"+count+"|")
print("|-------------------------------------------[count]------------------------------------------------|")
print("|-------------------------------------------[size]-------------------------------------------------|")
print("|"+collline+"|")
print("|"+size+"|")
print("|-------------------------------------------[size]-------------------------------------------------|")

 

转载于:https://www.cnblogs.com/mytech/p/3499403.html