Django - Custom SQL in the connection string

Question

I have had some issues with downtime as a result of hitting the max_user_connections limit in MySql.

The default connection timeout is 8 hours, so once we hit the limit (and having no access to kill the connections on our shared hosting) I simply had to wait 8 hours for the connections to time out.

I would like to add the following code to my connection string:

SET wait_timeout=300;

Which would change the timeout to 5 minutes. As you can imagine, I'm much happier to deal with 5 minutes of downtime than 8 hours. ;)

Is there a good way of adding custom SQL to the connection string in django?

If not, it has been suggested that we write some middleware that runs the SQL before the view is processed.

That might work, but I would feel more comfortable knowing that the query was absolutely guaranteed to run for every connection, even if more than one connection is opened for each view.

Thanks!

PS - before you tell me I should just hunt down the code that is keeping the connections from being closed - Never Fear! - we are doing that, but I would like to have this extra insurance against another 8 hour block of downtime

maybe you mean "query string" instead of "connection string"? — nosklo
– nosklo, Commented Oct 16, 2009 at 12:50

Daniel Roseman · Accepted Answer · 2009-10-16 13:42:21Z

1

You can specify a list of commands to send to MySQL when the connection is open, by setting the DATABASE_OPTIONS dictionary in settings.py.

(Incidentally, note that Django doesn't open a new connection for every view.)

answered Oct 16, 2009 at 13:42

Daniel Roseman

602k68 gold badges911 silver badges924 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jiaaro Over a year ago

Good info! thanks so much this is exactly the solution I was hoping for :)

Collectives™ on Stack Overflow

Django - Custom SQL in the connection string

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related