mysql 自动关闭连接

import mysql.connector
from mysql.connector import pooling

db_config = {
    "host": "localhost",
    "user": "your_user",
    "password": "your_password",
    "database": "your_database",
    "pool_name": "mypool",
    "pool_size": 5,
}

try:
    cnxpool = mysql.connector.pooling.MySQLConnectionPool(**db_config)
    conn = cnxpool.get_connection()
    cursor = conn.cursor()

    while True:
        try:
            cursor.execute("SELECT 1")
            result = cursor.fetchone()
            if result[0] == 1:
                print("Connection is alive")
            else:
                print("Connection is dead, reconnecting...")
                conn.reconnect(attempts=3, delay=1)
        except mysql.connector.errors.InterfaceError as err:
            print(f"Connection error: {err}, reconnecting...")
            conn.reconnect(attempts=3, delay=1)
        except mysql.connector.Error as err:
            print(f"Database error: {err}")
        finally:
            cursor.close()
            conn.close()
        time.sleep(10)  # 每10秒检测一次

except mysql.connector.Error as err:
    print(f"Failed to connect to MySQL: {err}")