【mongoDB】mongoDB统计指定库中各表数据量大小

作者: Bogon | 来源:发表于2022-08-06 15:37 被阅读0次

$ cat get_table_size.sh

#!/bin/bash

db="test"

function mongo_login() {
  /path/to/bin/mongo  --quiet  --host xx.xx.xx.xx --port=27017 -u username --password='XXX' --authenticationDatabase=admin
}


tables=`echo -e "use ${db};\n show tables;"  | mongo_login | grep -v "switched to"`

for  table in  ${tables}
 do
    echo  "${table}"
    size=`echo -e "use ${db};\n db.${table}.totalSize()" | mongo_login | grep -v  "switched to"`
    echo ${size} | awk '{size=$1/1024;if(size<1024){printf("%10.3f KB\t%s\n",size,$2);}else{size=size/1024;if(size<1024){printf("\033[36m%10.3f MB\t%s\n\033[0m",size,$2);}else{size=size/1024;if(size<1024){printf("\033[35m%10.3f GB\t%s\n\033[0m",size,$2);}else{size=size/1024;printf("\033[31m%10.3f TB\t%s\n\033[0m",size,$2);}}}}'
    echo ""
done


#!/bin/bash


function mongo_login() {
  /path/to/bin/mongo  --quiet  --host xx.xx.xx.xx --port=27017 -u username --password='XXX' --authenticationDatabase=admin
}

dbs=`echo -e "use admin;\n show dbs;"  | mongo_login`

for db  in  ${dbs}
  echo "############ ${db} ###########"
  tables=`echo -e "use ${db};\n show tables;"  | mongo_login | grep -v "switched to"`
  
  for table in  ${tables}
  do
    echo  "${table}"
    size=`echo -e "use ${db};\n db.${table}.totalSize()" | mongo_login | grep -v  "switched to"`
    echo ${size} | awk '{size=$1/1024;if(size<1024){printf("%10.3f KB\t%s\n",size,$2);}else{size=size/1024;if(size<1024){printf("\033[36m%10.3f MB\t%s\n\033[0m",size,$2);}else{size=size/1024;if(size<1024){printf("\033[35m%10.3f GB\t%s\n\033[0m",size,$2);}else{size=size/1024;printf("\033[31m%10.3f TB\t%s\n\033[0m",size,$2);}}}}'
    echo ""
done

注：此处mongo_login 如果定义成变量，用 ${mongo_login} 引用，会语法报错