mysql监控指标值设定

import mysql.connector
import smtplib
from email.mime.text import MIMEText

# MySQL连接配置
config = {
    'user': 'your_user',
    'password': 'your_password',
    'host': 'your_host',
    'database': 'your_database'
}

# 监控阈值
threshold = 100

# 获取MySQL连接数
def get_connection_count():
    conn = mysql.connector.connect(**config)
    cursor = conn.cursor()
    cursor.execute("SHOW STATUS LIKE 'Threads_connected'")
    result = cursor.fetchone()
    cursor.close()
    conn.close()
    return int(result[1])

# 发送告警邮件
def send_alert_email(subject, content):
    msg = MIMEText(content)
    msg['Subject'] = subject
    msg['From'] = 'your_email'
    msg['To'] = 'recipient_email'

    smtp_server = smtplib.SMTP('smtp.your_email_provider')
    smtp_server.send_message(msg)
    smtp_server.quit()

# 主监控逻辑
def monitor_mysql():
    connection_count = get_connection_count()
    if connection_count > threshold:
        subject = 'MySQL连接数告警'
        content = f'当前MySQL连接数为 {connection_count}，超过阈值 {threshold}'
        send_alert_email(subject, content)

if __name__ == '__main__':
    monitor_mysql()