数据库服务器资源使用周报，近期想跳槽的程序员必看

cpu_median = cpu_median_points[0][‘median’]

##print(cpu_median)

##print(‘开始查询mem使用率的平均数’)

mem_mean_list = self.client.query(

“SELECT mean(used) /mean(total) from mem where time>=%s and time<=%s and host != ‘qqlog_XXX_XXX’;” % (

start_time, end_time))

print(mem_mean_list)

mem_mean_list的格式为ResultSet({’(‘mem’, None)’: [{‘time’: ‘2018-06-21T16:00:00Z’, ‘mean_mean’: 0.729324184536873}]})

mem_mean_points = list(mem_mean_list.get_points(measurement=‘mem’))

mem_mean = mem_mean_points[0][‘mean_mean’]

##print(mem_mean)

##print(‘开始查询mem使用率的中位数’)

mem_median_list = self.client.query(

“SELECT median(used) /median(total) from mem where time>=%s and time<=%s AND host != ‘qqlog_XXX_XXX’ ;” % (

start_time, end_time))

##print(mem_median_list)

###mem_median_list的格式为ResultSet({’(‘mem’, None)’: [{‘time’: ‘2018-06-21T16:00:00Z’, ‘median_median’: 0.8698493636354012}]})

mem_median_points = list(mem_median_list.get_points(measurement=‘mem’))

mem_median = mem_median_points[0][‘median_median’]

##print(‘开始查询disk使用率的平均数’)

disk_mean_list = self.client.query(

“SELECT mean(used) /mean(total) from disk where time>=%s and time<=%s AND host != ‘qqlog_XXX_XXX’;” % (

start_time, end_time))

##print (disk_mean_list)

###disk_mean_list的格式为esultSet({’(‘disk’, None)’: [{‘time’: ‘2018-06-21T16:00:00Z’, ‘mean_mean’: 0.31204798557786284}]})

disk_mean_points = list(disk_mean_list.get_points(measurement=‘disk’))

disk_mean = disk_mean_points[0][‘mean_mean’]

##print(disk_mean)

##print(‘开始查询disk使用率的中位数’)

disk_median_list = self.client.query(

“SELECT median(used) /median(total) from disk where time>=%s and time<=%s and host != ‘qqlog_XXX_XXX’;” % (

start_time, end_time))

##print (disk_median_list)

###disk_median_list的格式ResultSet({’(‘disk’, None)’: [{‘time’: ‘2018-06-21T16:00:00Z’, ‘median_median’: 0.08009824336938143}]})

disk_median_points = list(disk_median_list.get_points(measurement=‘disk’))

##print(disk_median_points)

disk_median = disk_median_points[0][‘median_median’]

##print(disk_median)

将计算统计的结果放到MySQl中，以便汇总发送Report

sql_insert = "insert into weekly_dbperformance(cpu_mean,cpu_median,mem_mean,mem_median,disk_mean,disk_median) " \

“values(’%s’,’%s’,’%s’,’%s’,’%s’,’%s’)” % \

(cpu_mean,cpu_median,mem_mean,mem_median,disk_mean,disk_median)

cursor.execute(sql_insert)

mysqldb.commit()

def change_time(self, params):

“”"

时间转换

:param params:

:return:

“”"

item = dateutil.parser.parse(params).astimezone(pytz.timezone(‘Asia/Shanghai’))

result = str(item).sp