日常巡检mysql_mysql巡检脚本(必看篇)

#!/usr/bin/env python3.5

import psutil

import mysql.connector

import argparse

import json

import datetime

def get_cpu_info(verbose):

cpu_info={}

if verbose >0:

print("[cpu] start collect cpu info ...")

data=psutil.cpu_times_percent(3)

cpu_info['user']=data[0]

cpu_info['system']=data[2]

cpu_info['idle']=data[3]

cpu_info['iowait']=data[4]

cpu_info['hardirq']=data[5]

cpu_info['softirq']=data[6]

cpu_info['cpu_cores']=psutil.cpu_count()

if verbose >0:

print("{0}".format(json.dumps(cpu_info,ensure_ascii=False,indent=4)))

print("[cpu] collection compeleted ...")

return cpu_info

def get_mem_info(verbose):

mem_info={}

if verbose >0:

print("[mem] start collect mem info ...")

data=psutil.virtual_memory()

mem_info['total']=data[0]/1024/1024/1024

mem_info['avariable']=data[1]/1024/1024/1024

if verbose>0:

print("{0}".format(json.dumps(mem_info,ensure_ascii=False,indent=4)))

print("[mem] collection compeletd ...")

return mem_info

def get_disk_info(verbose):

disk_info={}

if verbose >0:

print("[disk] start collect disk info ...")

partitions=psutil.disk_partitions()

partitions=[(partition[1],partition[2])for partition in partitions if partition[2]!='iso9660']

disk_info={}

for partition in partitions:

disk_info[partition[0]]={}

disk_info[partition[0]]['fstype']=partition[1]

for mount_point in disk_info.keys():

data=psutil.disk_usage(mount_point)

disk_info[mount_point]['total']=data[0]/1024/1024/1024

disk_info[mount_point]['used_percent']=data[3]

if verbose >0:

print("{0}".format(json.dumps(disk_info,ensure_ascii=False,indent=4)))

print("[disk] collection compeleted ....")

return disk_info

def get_mysql_info(cnx_args,status_list):

config={

'user':cnx_args.user,

'password':cnx_args.password,

'host':cnx_args.host,

'port':cnx_args.port}

cnx=None

cursor=None

mysql_info={}

try:

cnx=mysql.connector.connect(**config)

cursor=cnx.cursor(prepared=True)

fo