python监控mysql慢日志并发送钉钉

#pip3 install requests

 

#!/usr/bin/python
 
#-*- coding: utf-8 -*
import urllib, json, requests
import sys, shutil, os, string, datetime,time

serverip="99"
name="slow.log"
msg = []  #定义一个空列表将while循环中每次读出的行作为一个元素接收

def msg_format(data):
    global msg
    if data.startswith("#") or data.startswith("SET"):
      msg = []
      if "User@Host" in data:    #过滤出库信息并分割字符
        uh = data.split("@")
        host = uh[1]
        http_post(host)
    else:
      msg.append(data)
      if data.endswith(";"):
        strmsg = ' '.join(msg)
        http_post(strmsg)

def http_post(errmsg):

    url = "https://oapi.dingtalk.com/robot/send?access_token=xxxx"

    values = {"msgtype": "text"}
    content = {}
    content["content"] = serverip + "slow_sql_msg：" + errmsg
    values["text"] = content
    headers = {"Content-Type":"application/json;charset=UTF-8"}
    jdata = json.dumps(values)

    req = requests.post(url=url, headers=headers, data=jdata)
    print(req.content.decode())

file = open('/usr/local/mysql/logs/'+ name)
file.seek(0, os.SEEK_END)
 
while 1:
        where = file.tell()
        line = file.readline()
        if not line:
                time.sleep(1)
                file.seek(where)
        else:
                msg_format(line[:-1])    #删除每行的最后一个字符(即换行符)