mysql连接释放

import mysql.connector

try:
    conn = mysql.connector.connect(user='user', password='password', host='host', database='database')
    cursor = conn.cursor()
    # 执行数据库操作
    cursor.execute("SELECT * FROM table")
    result = cursor.fetchall()
finally:
    cursor.close()
    conn.close()

import mysql.connector

conn = mysql.connector.connect(user='user', password='password', host='host', database='database', keepalive_timeout=3600)
cursor = conn.cursor()
# 执行数据库操作
cursor.execute("SELECT * FROM table")
result = cursor.fetchall()
cursor.close()
conn.close()

from mysql.connector.pooling import MySQLConnectionPool

pool = MySQLConnectionPool(pool_name="mypool", pool_size=5, user='user', password='password', host='host', database='database')

try:
    conn = pool.get_connection()
    cursor = conn.cursor()
    # 执行数据库操作
    cursor.execute("SELECT * FROM table")
    result = cursor.fetchall()
finally:
    cursor.close()
    conn.close()