Too many sleep processes

mariopro

Hi,

I'm postinghere a question rgarding some discussion with the company where one of my websites is hosted and that has to do with opened connections.

Any help on this subject would be appreciated.

They are argueing that my website leaves to many opned connections on the server (shared server) and that this is slowing it down.

I'm using on my PHP scripts mysql_connect() and not mysql_pconnect() .
According with the MySQL and PHP manuals, for the mysql_connect() there is no need for mysql_close() since the server garbage collector will free these sleep processes.

The questions are:

Is this, mysql_connect()/mysql_pconnect(), true?
Is there something in the PHP or MySQL configuration that can override or fix this issue?

Any additional comments are welcome.

Thanks in advance

nnichols

if you are always connecting to the same db(s) on the same server you would be better off using pconnect. Try it. You should have your db connection routine in a separate include file so it is easy to play with issues like this.

It is true that the connections created by "mysql_connect()" will be closed when the scripts complete, but I'm not sure how reliable this is.

Hope this helps 😉

mariopro

Hi,

Thanks for your reply.

In fact, the folks from the hosting company sent me an e-mail with the list for openning sleep connections from my database. Guess what! They were just 15.

Okay, I've put the mysql_close() into the last line of my footer.inc.php that is common to all pages, which, according with them, would decrease the server load.

I'm using the mysql_connect() in a database.inc.php.

After a couple of days, they told me that the situation was still happening.

I made them a little php script to run as cron every minute and kill the oppened connections that are lasting more than 100 secs. on the server. Now guess what... thay are running the script and telling me that they are still having server overloads because of my site, that has about 2.500 page views/day.

I think that they may have a misconfiguration on their php.ini or server conf since I'm using much complex and lenghty queries in another website on other server and they aren't experiencing any problems. Hummm...

Anyway, thanks for you tips.

Regards

Sxooter

It sounds like you have apache children seg faulting while connected to the database, and the connections are hanging after that.

Can you get a look at their error logs for apache on that box? They more than likely have something misconfigured on their server.