zabbix监控mysql脚本（python3）

最新推荐文章于 2023-10-05 08:30:22 发布

程程呀

最新推荐文章于 2023-10-05 08:30:22 发布

阅读量509

点赞数

本文链接：https://blog.csdn.net/qq_31755183/article/details/87929098

版权

#!/usr/bin/python3
import os
import sys

db_bin = 'mysqladmin'
db_user = 'root'
db_passwd = 'cbst789'
db_host = '127.0.0.1'
db_port = '3306'
state_list = ['Com_commit','Com_delete','Com_insert','Com_update','Com_select','Com_rollback']

class mysql_state:
   def __init__(self,db_bin,db_user,db_passwd,db_host,db_port):
       self.binpath = db_bin
       self.user = db_user
       self.passwd = db_passwd
       self.host = db_host
       self.port = db_port
   def mysqladmin(self,state):
       cmd = "{0} -u{1} -p{2} -h {3} -P {4} extended-status | grep -w {5} | awk '{6}'".format(self.binpath,self.user,self.passwd,self.host,self.port,state,'{print $4}')
       return cmd
   def state_key(self,_state):
       cmd = state.mysqladmin(_state)
       os.system(cmd)

def get_state(_type):
    if _type in state_list:
       state.state_key(_type)
    else:
       print ('没有这个key值',_type)

if __name__ == '__main__':
   state = mysql_state(db_bin,db_user,db_passwd,db_host,db_port)
   _type = sys.argv[1]
   get_state(_type)