mongodb相关操作命令

//查看所有集合大小

var clsName=db.getCollectionNames();
function getReadableFileSizeString(clsName) {
    for(var j=0;j<clsName.length;j++){
        var name=clsName[j];
        var cun=db.getCollection(name).find({}).count();
        var fileSizeInBytes= db.getCollection(name).stats().size;
        var i = -1;
        var byteUnits = [' kB', ' MB', ' GB', ' TB', 'PB', 'EB', 'ZB', 'YB'];
        do {
            fileSizeInBytes = fileSizeInBytes / 1024;
            i++;
        } while (fileSizeInBytes > 1024);
        print(name+'----'+cun+'条----------'+Math.max(fileSizeInBytes, 0.1).toFixed(1) + byteUnits[i]);
    }
};
getReadableFileSizeString(clsName);

获取MongoDB中collection大小

db.t0608.dataSize()//collection中的数据大小
db.t0608.storageSize()//为collection分配的空间大小，包括未使用的空间
db.t0608.totalIndexSize() //collection中索引数据大小
db.t0608.totalSize() //collection中索引+data所占空间
db.getCollection(‘Collection’).stats(1024 * 1024).size

db.auth(‘lbs’,‘AfdErqweqw!53084’); //用户验证

查看集合分片信息

db.collection.getShardDistribution() //可以查看数据分布
db.collection.stats().sharded //简单的返回true或者false
db.collection.stats()

//新表选择hashed分片，并创建hashed索引

use test
sh.shardCollection(“test.t0608”,{id:“hashed”});
db.t0608.ensureIndex({id:“hashed”});

当前数据库连接

db.serverStatus().connections

db.oplog.rs.stats().maxSize
db.printReplicationInfo()
db.getReplicationInfo()
db.oplog.rs.find()
db.adminCommand({replSetResizeOplog:1,size:1024})
db.runCommand({create:“oplog.rs”,capped:true,size:(410241024*1024)})

db.isMaster()
db.isSecondary()
db.isMaster().true
rs.stepDown()
db.printSlaveReplicationInfo()

db.sources.find();

–查看当前执行session

print("##########");db.currentOp().inprog.forEach(function(item){if(item.waitingForLock){var lock_info = item[“opid”];print(“waiting:”,lock_info,item.op,item.ns);}});print("----");db.currentOp().inprog.forEach(function(item){if(!item.waitingForLock){var lock_info = item[“opid”];print(“doing”,lock_info,item.op,item.ns);}});print("##########");

–kill会话
db.killOp(“s1:30187657”)

–kill当前所有会话
db.currentOp().inprog.forEach(function(item){db.killOp(item.opid)})