怎样查询mysql连接数

SHOW STATUS LIKE 'Threads_connected';

import mysql.connector

def get_mysql_connection_count(host, user, password, database):
    try:
        conn = mysql.connector.connect(
            host=host,
            user=user,
            password=password,
            database=database
        )
        cursor = conn.cursor()
        cursor.execute("SHOW STATUS LIKE 'Threads_connected'")
        result = cursor.fetchone()
        connection_count = int(result[1])
        cursor.close()
        conn.close()
        return connection_count
    except mysql.connector.Error as err:
        print(f"Error: {err}")
        return None

# 示例调用
host = 'localhost'
user = 'your_username'
password = 'your_password'
database = 'your_database'

connection_count = get_mysql_connection_count(host, user, password, database)
if connection_count is not None:
    print(f"Current MySQL connection count: {connection_count}")