python mysql数据库连接池

import mysql.connector.pooling

config = {
    "host": "localhost",
    "user": "user",
    "password": "password",
    "database": "database",
    "pool_name": "mypool",
    "pool_size": 32  # 增加最大连接数
}

pool = mysql.connector.pooling.MySQLConnectionPool(**config)

try:
    connection = pool.get_connection()
    cursor = connection.cursor()
    cursor.execute("SELECT * FROM table")
    result = cursor.fetchall()
    cursor.close()
    connection.close()
except mysql.connector.Error as err:
    print(f"Error: {err}")

try:
    with pool.get_connection() as connection:
        with connection.cursor() as cursor:
            cursor.execute("SELECT * FROM table")
            result = cursor.fetchall()
except mysql.connector.Error as err:
    print(f"Error: {err}")