Django Mysql Connection Pooling

Question

What is the best way to establish connection pooling for MySQL connections in Django..?

I have read a couple of blogs like SQLAlchemy

Can anyone suggest standard practices for the same.. I am running a B2C application on django and the number of simultaneous requests may hit 10000..

django >=1.6 have auto pooling, if you using django older virsion you can use : https://github.com/smartfile/django-mysqlpool/. — Yogesh dwivedi Geitpl, Jul 14 '15 at 11:23
Can you point me to a doc for version >=1.6 which states connection pooling is auto.. — abipc, Jul 15 '15 at 09:48
https://docs.djangoproject.com/en/1.6/ref/databases/#persistent-connections — Yogesh dwivedi Geitpl, Jul 16 '15 at 07:26
@YogeshDwivedi.. It only talks about persistence of connections with a max age.. What I am looking for is connection pooling.. — abipc, Jul 16 '15 at 12:05
why should not : https://github.com/smartfile/django-mysqlpool ? — Yogesh dwivedi Geitpl, Jul 17 '15 at 08:48
Unfortunately, django-mysqlpool looks like it's unmaintained. The most recent version on PyPI doesn't support Python3 (though github does), and the most recent commit is from May 2015. — Holly, Oct 19 '16 at 21:11
Possible duplicate of [Why doesn't django support connection pool?](http://stackoverflow.com/questions/4546059/why-doesnt-django-support-connection-pool) — bummi, Dec 16 '16 at 06:07
@GEITPL_Dev It's not auto pooling, just does not close connections immediately — ospider, Jul 07 '18 at 02:45

score -1 · Answer 1 · answered Dec 16 '16 at 05:56

-1

So for anyone still visiting this an unsatisfied with Django built in connection pooling (which has zero configuration and in all honesty I'm not too sure works), this project although years old since its last commit still works!

https://github.com/djangonauts/djorm-ext-pool

answered Dec 16 '16 at 05:56

Kevin Parker

16,975
20
76
105

The Django pool isn't a pool. Its one thread - one connection. – kagronick Nov 07 '17 at 21:41
I see, anyways we're using djorm-ext-pool – Kevin Parker Nov 08 '17 at 21:48

Django Mysql Connection Pooling

1 Answers1