php database connection errors

Question

Hello all, im hoping someone can help me quickly with a question i have.

As site i have build is occasionally returning with the error

Warning: mysqli::mysqli() [mysqli.mysqli]: (08004/1040): Too many connections in

Warning: mysqli::query() [mysqli.query]: Couldn't fetch mysqli in

Now at first i thought this was happening as i hadent closed the connection at the end of each page, now i get the connection like this at the beginning of a page / script

$conn = new mysqli($host, $username, $password, $database);

and at the very end call

$conn->close();

Also i close any result sets i have open.

Looking at my log files around the time i accessed the site today and saw this error, I accessed about 12 o clock and at first the page wouldnt even load, then it gave me this error. before that one person visted around 11:30 and then 10:30, not exactly heavy traffic.

The host I have gone with is very quiet and there is no way to get in contact with them, and ignoring any support emails, i thought maybe as now i hear they are not very good this could be an issue with a badly set up shared mysql server?

Any thoughts or suggestions would be amazing as i need to sort this out!

Thanks in advance!

Answer 1

It sounds like the MySQL server is being shared by too many accounts, as that error means that the server's max_connections setting has been exceeded. It could be that there are several other high-traffic customers that are taking up the connections (this is a shared MySQL server, I take it?)

I'm fairly sure that PHP automatically closes resources at the end of the request (although it's always best to explicitly close your connections etc. anyway) so I wouldn't think it's your script keeping connections open.

You'll need to keep on at your hosting provider, I'm afraid, or consider moving providers. Also try to keep a log of when the errors occur and for how long, as you'll need that as evidence if they refuse to acknowledge there's a problem.

You can also refer your provider to this page: http://dev.mysql.com/doc/refman/5.1/en/too-many-connections.html.