mysql数据监视

import mysql.connector
from mysql.connector import Error

def monitor_mysql_performance():
    try:
        connection = mysql.connector.connect(host='localhost',
                                             database='testdb',
                                             user='root',
                                             password='password')

        if connection.is_connected():
            cursor = connection.cursor()
            cursor.execute("SHOW GLOBAL STATUS LIKE 'Threads_connected';")
            result = cursor.fetchone()
            print(f"Current connections: {result[1]}")

            cursor.execute("SHOW GLOBAL STATUS LIKE 'Uptime';")
            result = cursor.fetchone()
            print(f"Server uptime: {result[1]} seconds")

            cursor.close()
            connection.close()

    except Error as e:
        print(f"Error: {e}")

if __name__ == "__main__":
    monitor_mysql_performance()