Forum Moderators: rogerd
"The forum wasn't working because there were too many connections to the mysql service."
They fixed it but didn't explain what this means even after I asked. Could anyone help me out by explaining this?
It means that all of your MySql connections to the database are in use. One of them needs to be freed up.
Before you panic, consider this. A certain web host (IPowerWeb) is having server problems lately, and this is the same error I saw. If the problem isn't with your host and it really is a true error, there are things you can do.
Take a look at the difference between mysql_connect and mysql_pconnect. Generally speaking, the mysql_connect is the way to go unless you have a specific reason to need a persistent connection. Also, its good practice to ensure the connection is closed before you leave the script.
mysql_close will close the non-persistent connections. Search for 'freeing resources' to learn more about this.
I haven't examined phpbb code that closely, but it's hard to believe the authors would overlook these obvious issues. However, if the code you use has been modified, check the changes.
I just went through months of agita with ours. They kept telling us that our "scripts were bad," and that we were exceeding 50,000 requests per hour.
Sort of like Emperor Joseph claiming that there were "too many notes" in Wolfie's music.
In our case, the site was a bandwidth sipper. It probably made 50,000 requests every six months, not hour. Out usage stats showed they didn't even make the bandwidth meter twitch.
The host wasn't resetting the counter every hour. Maybe the same for you? Ask them to prove it. MySQL can track queries. [dev.mysql.com]
