查询mysql的进程数

SHOW PROCESSLIST;

SELECT COUNT(*) FROM INFORMATION_SCHEMA.PROCESSLIST;

SHOW STATUS LIKE 'Threads_running';

import mysql.connector

def get_mysql_process_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_running'")
        result = cursor.fetchone()
        if result:
            return int(result[1])
        else:
            return 0
    except mysql.connector.Error as err:
        print(f"Error: {err}")
        return None
    finally:
        if conn.is_connected():
            cursor.close()
            conn.close()

# 使用示例
process_count = get_mysql_process_count('localhost', 'your_user', 'your_password', 'your_database')
print(f"Current MySQL process count: {process_count}")