Hi, in my site the main page (where user spend most of their time) needs 140 queries (according to django-toolbar). However, sometimes when running a small ajax request (every 10 secs using javascript's setInterval), I get a 'too many connections' error. It fails silently but I receive the e-mail. This ajax request is a very small overhead (just 3 simple queries) and returns a simplejson object with just one number. I have done some optimization but I also need to know if there is a way and if I must increase number of connections Mysql can handle. asked 06 Aug '12, 12:46 xpanta |
You can't increase the maximum connections on your servers' shared MySQL instance - if you need that ability, then you'll need to run your own MySQL server. That said, I don't really think you need to do anything - your server had recently been suffering from a high load condition which was causing queries to run slowly and exhaust the available pool of connections. We fixed the high load condition earlier today (about 4 hours ago), so I don't think you should be seeing these errors any more. Hope that helps! answered 06 Aug '12, 14:10 seanf Thank you very much. This helps a lot.
(08 Aug '12, 04:56)
xpanta
|