python中使用mysql数据库连接池

import mysql.connector.pooling

db_config = {
    "host": "localhost",
    "user": "your_user",
    "password": "your_password",
    "database": "your_database",
    "pool_name": "mypool",
    "pool_size": 5  # 连接池大小
}

try:
    # 创建连接池
    pool = mysql.connector.pooling.MySQLConnectionPool(**db_config)

    # 从连接池获取连接
    conn = pool.get_connection()
    cursor = conn.cursor()

    # 执行SQL查询
    query = "SELECT * FROM your_table"
    cursor.execute(query)

    # 获取结果
    result = cursor.fetchall()
    for row in result:
        print(row)

except mysql.connector.Error as err:
    print(f"Error: {err}")

finally:
    # 关闭连接和游标
    if 'cursor' in locals():
        cursor.close()
    if 'conn' in locals():
        conn.close()  # 连接会返回到连接池，而不是真正关闭