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 Exception as e:
        print(f"Error: {e}")
        return None

# 示例调用
host = 'localhost'
user = 'root'
password = 'password'
database = 'testdb'

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