mysql宕机检查

import psutil
import subprocess

def check_mysql_status():
    try:
        # 检查MySQL进程是否存在
        mysql_process = [proc for proc in psutil.process_iter(['pid', 'name']) if proc.info['name'] == 'mysqld']
        if not mysql_process:
            print("MySQL服务未运行")
            return False
        else:
            print("MySQL服务正在运行")
            return True
    except Exception as e:
        print(f"检查MySQL状态时出错: {e}")
        return False

def check_resource_usage():
    try:
        mysql_process = [proc for proc in psutil.process_iter(['pid', 'name', 'cpu_percent', 'memory_info']) if proc.info['name'] == 'mysqld']
        if mysql_process:
            proc = mysql_process[0]
            print(f"MySQL进程PID: {proc.info['pid']}")
            print(f"CPU使用率: {proc.info['cpu_percent']}%")
            print(f"内存使用: {proc.info['memory_info'].rss / 1024 ** 2} MB")
        else:
            print("未找到MySQL进程")
    except Exception as e:
        print(f"检查资源使用时出错: {e}")

if __name__ == "__main__":
    check_mysql_status()
    check_resource_usage()