FF.PyAdmin icon indicating copy to clipboard operation
FF.PyAdmin copied to clipboard

隔几分钟不操作,再请求数据库就报错2013, 'Lost connection to MySQL server during query,是怎么回事

Open zhaoxingmin opened this issue 5 years ago • 1 comments

zhaoxingmin avatar Aug 24 '20 06:08 zhaoxingmin

secret_settings.py 配置中, 有这么一段:

SQLALCHEMY_ENGINE_OPTIONS = {
    'pool_recycle': 3599,
    'pool_size': 100
}

pool_recycle 的值小于您 MySQL 中 SHOW GLOBAL VARIABLES LIKE "wait_timeout"; 设置的值即可. 希望能帮到您.

Ref: https://flask-sqlalchemy.palletsprojects.com/en/2.x/config/#timeouts

fufuok avatar Aug 24 '20 13:08 fufuok