mysql经常连接中断

SET GLOBAL wait_timeout = 3600; -- 设置为1小时
SET GLOBAL interactive_timeout = 3600; -- 设置为1小时

from sqlalchemy import create_engine

engine = create_engine('mysql+pymysql://user:password@host/db', pool_recycle=3600)

import pymysql

def connect():
    return pymysql.connect(host='host', user='user', password='password', db='db')

try:
    conn = connect()
except pymysql.OperationalError as e:
    if e.args[0] == 2006:  # MySQL server has gone away
        conn = connect()

import time

while True:
    try:
        with conn.cursor() as cursor:
            cursor.execute("SELECT 1")
        time.sleep(60)  # 每分钟发送一次心跳
    except pymysql.OperationalError as e:
        if e.args[0] == 2006:
            conn = connect()