V2EX = way to explore
V2EX 是一个关于分享和探索的地方
Sign Up Now
For Existing Member Sign In
推荐学习书目
› Learn Python the Hard Way
Python Sites
› PyPI - Python Package Index
› http://diveintopython.org/toc/index.html
› Pocoo
值得关注的项目
› PyPy
› Celery
› Jinja2
› Read the Docs
› gevent
› pyenv
› virtualenv
› Stackless Python
› Beautiful Soup
› 结巴中文分词
› Green Unicorn
› Sentry
› Shovel
› Pyflakes
› pytest
Python 编程
› pep8 Checker
Styles
› PEP 8
› Google Python Style Guide
› Code Style from The Hitchhiker's Guide
求使用 flask-sqlalchemy 的正确姿势，最近总报 Too many connections 错误， SQLALCHEMY_POOL_SIZE=5
larkifly · Apr 22, 2016 · 6769 viewsThis topic created in 3668 days ago, the information mentioned may be changed or developed.
如题，已经设置了 SQLALCHEMY_POOL_SIZE=5 ，依然无法解决。
mysql> show global status like '%connect%';
+--------------------------+-------+
| Variable_name | Value |
+--------------------------+-------+
| Aborted_connects | 8 |
| Connections | 374 |
| Max_used_connections | 21 |
| Ssl_client_connects | 0 |
| Ssl_connect_renegotiates | 0 |
| Ssl_finished_connects | 0 |
| Threads_connected | 5 |
+--------------------------+-------+
mysql> show global status like '%connect%';
+--------------------------+-------+
| Variable_name | Value |
+--------------------------+-------+
| Aborted_connects | 8 |
| Connections | 374 |
| Max_used_connections | 21 |
| Ssl_client_connects | 0 |
| Ssl_connect_renegotiates | 0 |
| Ssl_finished_connects | 0 |
| Threads_connected | 5 |
+--------------------------+-------+
 |
1
myyou Apr 22, 2016
你用 db.session.close()了没？
|
 |
2
liyj144 Apr 22, 2016
show variables like "%max_connections%"; 查看最大连接数，我怀疑是 mysql 配置的最大连接数太小， 然后 show processlist; 看看连接情况。
|
 |
3
larkifly OP @myyou 没有，如果每次都 db.session.close()，那是不是要每次使用的时候，都得 db = SQLAlchemy(app)初始化一下连接？？？
|
Select Language