Hi,
In my django settings.py I have set CONN_MAX_AGE=0 to use with MySQL DB,
which I understood as closing conn after each request. However when I start
a simple "mysite" tutorial with "python manage.py runserver", I see
immediately 3 connections in mysql that will not close but in Sleep mode.
Did I miss something here? How do we ensure these connections will get
closed while the app is running?
mysql> show full processlist;
+-----+------+-----------------+------+---------+------+-------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info
|
+-----+------+-----------------+------+---------+------+-------+-----------------------+
| 316 | root | localhost | NULL | Query | 0 | init | show full
processlist |
| 317 | root | localhost:61695 | test | Sleep | 3 | | NULL
|
| 318 | root | localhost:61696 | test | Sleep | 3 | | NULL
|
| 319 | root | localhost:61697 | test | Sleep | 3 | | NULL
|
+-----+------+-----------------+------+---------+------+-------+-----------------------+
4 rows in set (0.00 sec)
Thanks
Zemian
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/33fcf156-42bd-4c07-819f-952a6b214b76%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
