FF.PyAdmin
FF.PyAdmin copied to clipboard
隔几分钟不操作,再请求数据库就报错2013, 'Lost connection to MySQL server during query,是怎么回事
在 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