flask sqlalchemy 数据库连接超时自动重试

创建日期: 2024-11-08 11:40 | 作者: 风波 | 浏览次数: 17 | 分类: SQLAlchemy

来源:https://stackoverflow.com/questions/58866560/flask-sqlalchemy-pool-pre-ping-only-working-sometimes 参考:https://stackoverflow.com/questions/56271116/flask-sqlalchemy-sqlalchemy-engine-options-not-set-up-correctly

主要是 pool_pre_ping 参数。

SQLALCHEMY_ENGINE_OPTIONS = {
    'pool_size': 10,
    'pool_recycle': 60,
    'pool_pre_ping': True
}

例如

app.config['SQLALCHEMY_ENGINE_OPTIONS'] = 

或者

app.config.from_pyfile('config.py')
17 浏览
12 爬虫
0 评论