Thread

Hi,

I’m having some issues with my EE site under extreme loads particularly hitting max connection errors in MySQL and after some debugging with the hosts (Rackspace) it looks like some connections aren’t being closed properly so they remain in a sleep state until they are killed by MySQL.

I have non-persistent connections selected and whilst I have a few PHP scripts running that aren’t EE - EE is responsible for 99.9% of the site so am looking here first. I’m actually definitely not using persistent connections for anything as I’ve overridden this setting in php.ini

Has anyone experienced this before and is there anything I can do to absolutely confirm EE isn’t the issue?

Edit: Running 1.6.8, PHP 5.2.13, MySQL 5.0.77

Just a quick update. I’ve confirmed it is an EE script that is leaving sleeping connections (I used a seperate database user for EE), though actually I guess it just means that one of my pages must be taking an eternity to load i.e. a monster query rather than an issue with EE itself?

Hi Gareth,

That sounds like more of a server configuration issue, since EE doesn’t manage those connections itself. Are you able to lower the MySQL connection timeout limit on the host?