python实践——批量统计mongodb数据库的集合大小
#!/usr/bin/env python
import os,sys
list = []
for i in range(3,50):
l = os.popen("/bin/echo 'show collections'| /usr/local/mongodb/mongodb/bin/mongo 127.0.0.1:27103/数据库名|sed -n '%sp'" %i) #获取数据库的集合列表
l = l.read()
if l != "":
list.append(l)
else:
print "the collections is %s" %i
del list[i-4]
break
for i in list:
i = i.strip("\n")
os.popen("/bin/echo 'db.%s.stats()'| /usr/local/mongodb/mongodb/bin/mongo 127.0.0.1:27103/数据库名|sed -n '4p;6p;8p'>>mongodb_size_count.txt" %i) #统计集合的大小并把结果写入mongodb_size_count.txt文件中
博客同步地址:http://blog.csdn.net/u010917843