import pymysql
class DB(object):
def __init__(self,user,password,host,database):
self.user = user
self.password = password
self.host = host
self.database = database
try:
self.db = pymysql.connect("%s"%host, "%s"%user, "%s"%password, "%s"%database)
except Exception as e:
print(e)
def get_data(self):
#con = pymysql.connect(host=self.host, user=self.user, password=self.password, database=self.database)
sql = "show databases"
cursor = self.db.cursor()
cursor.execute(sql)
results = cursor.fetchall()
dists = {}
for i in results:
sql = "select concat(round(sum(data_length)/(1024*1024),2) + round(sum(index_length)/(1024*1024),2)) as 'DB' from tables where table_schema='%s'; "%(i[0])
cursor.execute(sql)
results = cursor.fetchall()
try:
dists[i[0]] = float(results[0][0])
except:
dists[i[0]] = 0
cursor.close()
self.db.close()
#print(dists)
distss = sorted(dists.items(), key=lambda x: x[1])
#print(distss)
for i in distss:
print(i[0],str(i[1])+'MB')
if __name__ == "__main__":
host = 'aliyuncs.com'
user = 'gcbx'
password = 'super'
database = 'information_schema'
db = DB(user,password,host,database)
db.get_data()
pymysql查询每个库存储空间
最新推荐文章于 2024-09-04 23:56:31 发布