agent007 wrote:The site receives about 2000 unique visitors per day..So the 500 SQL connections is pretty low. I've just finished adding the mysql_close() to the PHP scripts, so hopefully that will help. The hosting company doesnt provide SSH/terminal access so there is no way for me to find out whats eating the resources. According to them, the SQL is on a standalone box. They have also increased the RAM to 2GB.
So, since the RAM is increased can the MYSQL connections be increased too? Like maybe 6000? or would the OS crash?
Depending on what sort of access your visitors are getting a 500 connection limit should be *more* than enough to handle 2000 unique visitors a day, even if those visitors are hitting your site 24x7 which I am sure they are not. 2000 unique visitors is a very small number. Remember, a connection should be opened and closed only during the page load. Once the page is loaded the connection should be closed. I would think 500 connections would normally be enough to service tens of thousands of unique daily visitors with ease. I have to think something is wrong in either the MySQL configuration, the Apache configuration, or in the PHP coding, but again you haven't given very many details as to what sort of application we are talking about.