如何查看mysql当前连接数量

SHOW STATUS LIKE 'Threads_connected';

import mysql.connector
import time

def get_current_connections():
    try:
        conn = mysql.connector.connect(user='your_user', password='your_password', host='your_host', database='your_database')
        cursor = conn.cursor()
        cursor.execute("SHOW STATUS LIKE 'Threads_connected'")
        result = cursor.fetchone()
        print(f"Current connections: {result[1]}")
    except mysql.connector.Error as err:
        print(f"Error: {err}")
    finally:
        cursor.close()
        conn.close()

while True:
    get_current_connections()
    time.sleep(5)  # 每5秒查看一次