Jump to content
xisto Community
Sign in to follow this  
krap

Too Many Mysql Connections how to stop it

Recommended Posts

I have a site on another host (computingweb.com- its the same people who run here) and my site was suspended because it was apparently having too many connections. Its ok now but to prevent it from happening again what should i do? Im not very good at php/mysql so i think its probably because of my code i am using and the fact i have a busy forum(15-40 people online at a time). The forum is for wap(mobiles+pda) and isnt one like phpbb etcI would like to know:* What causes this error* How to prevent itThanks in advanceAndr?

Share this post


Link to post
Share on other sites

You can use Pconnect, another function of mysql which makes persistent connections. Because of this, once a connection is open, it is not closed even after the query is executed. Instead, the same Connection will be used. Thereby, preventing many connections.However, since you are from Xisto - Web Hosting, We have added 1 GB Extra ram to our server. The conditions should be stable now. :-)

Share this post


Link to post
Share on other sites

i tried the pconnect and it works for a while and then i get this huge error message so i change back to connect and it works but i get the error messages as well for some pages before i reload them.. oh well i hope its not my site breaking the mysql :( seems to be ok now though. does it take some time for pconnect to fix the problem because it has connect connections and pconnect connections? I dont realy know what im talking about now :):)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.