mysql 短连接

import mysql.connector.pooling

config = {
    "host": "localhost",
    "user": "user",
    "password": "password",
    "database": "database"
}

pool = mysql.connector.pooling.MySQLConnectionPool(pool_name="mypool", pool_size=5, **config)

def get_connection():
    return pool.get_connection()

# 使用连接池获取连接
conn = get_connection()
cursor = conn.cursor()
cursor.execute("SELECT * FROM table")
result = cursor.fetchall()
cursor.close()
conn.close()

[mysqld]
wait_timeout = 3600
interactive_timeout = 3600

import time

def keep_alive(conn):
    while True:
        try:
            cursor = conn.cursor()
            cursor.execute("SELECT 1")
            cursor.close()
        except mysql.connector.Error as err:
            print(f"Error: {err}")
            break
        time.sleep(60)