mysql 性能采集

import mysql.connector
import time

def get_mysql_performance():
    conn = mysql.connector.connect(user='user', password='password', host='host', database='database')
    cursor = conn.cursor()
    
    # 获取系统级监控指标
    cursor.execute("SHOW GLOBAL STATUS LIKE 'Threads_connected'")
    threads_connected = cursor.fetchone()[1]
    
    cursor.execute("SHOW GLOBAL STATUS LIKE 'Uptime'")
    uptime = cursor.fetchone()[1]
    
    # 获取数据库级监控指标
    cursor.execute("SHOW GLOBAL VARIABLES LIKE 'max_connections'")
    max_connections = cursor.fetchone()[1]
    
    cursor.close()
    conn.close()
    
    return {
        'threads_connected': threads_connected,
        'uptime': uptime,
        'max_connections': max_connections
    }

if __name__ == "__main__":
    while True:
        performance_data = get_mysql_performance()
        print(performance_data)
        time.sleep(60)  # 每分钟采集一次数据