Home TheRandomizer Forum Index Log in Register FAQ Search
TheRandomizer Forum Index » General Support » suspended due to high sql load
Post new topic  Reply to topic View previous topic :: View next topic 
suspended due to high sql load
PostPosted: Tue Nov 18, 2003 3:42 pm Reply with quote
primaryhits
Visitor
Joined: 13 Nov 2003
Posts: 19




Hi
My account just got suspended with my hosting company.
Can somebody please tell me if this is normal what they told me;
Your account is suspended due to high load on mysql. You are running 52
process.
and if so does anyone know where I could host the script with my domain?
Thank You
Robert
PostPosted: Tue Nov 18, 2003 6:27 pm Reply with quote
Guest




I had the same problem with phpwebhosting.com. Part of the deal is unlimited bandwith and they took my site offline saying that it was affecting other users on the server. Not my problem!! I got them to put it back online after complaining for a bit, but I'm still scared they are going to take it off again. I love them as a host because their servers are faster than any others I've used and they have great, simple admin features and full access to the server. But yeah, if anyone knows of any hosts that wouldn't be a problem like this please let us know.
PostPosted: Tue Nov 18, 2003 6:42 pm Reply with quote
Guest




Hi
the funny part is I have another site with them. imhosted.com and it uses alot more resources and a sql database and they haven't said anything.
Primaryhits.com has been having problems for a year off and on and it was always an excuse. they installed a module on the server yesturday to monitor the resources and I had to write them because my site wasn't working. They said that they installed the module wrong and now suspension. Sounds like they just didn't like me complaining that I couldnt log into my cpanel or use the ftp software since it timed out.
Oh will .
bye
robert
PostPosted: Mon Dec 01, 2003 1:03 pm Reply with quote
ivanmort
Visitor
Joined: 29 Oct 2003
Posts: 16
Location: Denmark




Hi
My account just got suspended with my hosting company.
"Your account is suspended due to high load on mysql. "

Thank You
Ivan
Hi All I run my own hosting if you want space please let me
PostPosted: Mon Dec 01, 2003 9:33 pm Reply with quote
aboutweb
Visitor
Joined: 21 Oct 2003
Posts: 27
Location: Seattle Wa




Hi All,


I run my own hosting if you want space please let me know
You get
CGI, FTP, PHP4, MySQL and More
Web Site Admin Access
True POP3/SMTP
Unlimited Bandwidth

I run my own randomizer's with no problems

Jim


Last edited by aboutweb on Wed Jan 28, 2004 1:20 am; edited 1 time in total
shut down because of persistent connections
PostPosted: Tue Dec 09, 2003 10:44 am Reply with quote
guest
Guest




there is a persistent connect to the mysql db. That means that the connection to the db never closes. You need to finid it and remove it or all your resources will be used up within hours and most hosts will close you down.
PostPosted: Tue Dec 09, 2003 11:10 am Reply with quote
daniel
Addict
Joined: 19 Sep 2004
Posts: 177




The solution is simple: just replace the mysql_pconnect
with mysql_connect in db_connect.php.
This way all the connections will last only a few seconds,while the script uses the database.
PostPosted: Sat Jan 10, 2004 9:54 pm Reply with quote
Guest




Was this solution updated in the installation file since last month? Or should I still look to see if it needs to be fixed on my installation?
 suspended due to high sql load 
 TheRandomizer Forum Index » General Support
All times are GMT  
Page 1 of 1  

  
  
 Post new topic  Reply to topic  


Powered by phpBB© 2001-2006 phpBB Group |Randomizer Script | Web Hosting | phpBB Skin by Vjacheslav Trushkin