HELP ! PHP errror - site down

[adammc]

Hi,

I just tried to visit my site and got the following error:

Warning: mysql_connect(): Too many connections in /home/httpd/vhosts/workincairns.com/httpdocs/connect.php on line 2
Too many connections

Can ANYONE please tell me whats happenned and how to fix it ?

http://www.workincairns.com

[JeffIsGood]

Usually that means that your site is busy and you are hitting a limit on the number of mysql connections to the database (usually this limit is set by your web host). If you have access to your logs, you should check and see if that is really the case, and also get in touch with your host.

[spikeZ]

Seems to be working OK now. Keep a check on your logs and also any files that call to the database reguarly. I had a similar problem caused by a stats program that had gone nuclear and called the database far to many times!

Mike

[adammc]

My site is back up online...

I just got an email from my host saying:

Thanks for letting us know. I have fixed the problem. Please let me know if you see this occurring again.

I have just been made aware that my php pages should always end in a mysql close statement. However after the email from my host....

Maybe it wasnt my fault?

[spikeZ]

possibly wasn't, keep a close eye on them!

[Will Kelly]

It's good practice to clear mysql results but it is done automatically at the end of script execution anyway.

[ReptileMan]

It's good practice to clear mysql results but it is done automatically at the end of script execution anyway.

Well it isn't really a good practice either. No need to close something that is going to be close by the script automatically.

[spikeZ]

Not all scripts are closed automatically. It kinda depends on the server setup and if your server isn't playing, your script could screw up and run an infinite loop......

So although it's not 'good practice' persay,it is polite!

[n0other]

Well it isn't really a good practice either. No need to close something that is going to be close by the script automatically.

It's not guaranteed that it will be closed, it's a good practice to close it manually.

[rain5017]

Too many connections.

[Will Kelly]

Well it isn't really a good practice either. No need to close something that is going to be close by the script automatically.

MySQL results use up memory. So if you do a number of large queries it's a good idea to close ones you've finished with to free up memory.