mysql负载查看

import mysql.connector
from mysql.connector import Error

def get_mysql_load(host, user, password, database):
    try:
        connection = mysql.connector.connect(host=host,
                                             user=user,
                                             password=password,
                                             database=database)
        if connection.is_connected():
            cursor = connection.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]
            load = threads_connected / uptime
            print(f"Current MySQL load: {load}")
    except Error as e:
        print("Error while connecting to MySQL", e)
    finally:
        if connection.is_connected():
            cursor.close()
            connection.close()

# 调用示例
get_mysql_load('localhost', 'root', 'password', 'testdb')