Jump to content


Photo

help! This Account Has Exceeded Its CPU Quota!


  • Please log in to reply
6 replies to this topic

#1 graphicguy

graphicguy
  • New Members
  • Pip
  • Newbie
  • 5 posts

Posted 28 October 2006 - 05:23 AM

My account constantly gets suspended and its because I use to many resources on the server and the problem comes from using get. What can I use to use less resources?

HTTP Request: asdf.com : GET /page/count/633/ HTTP/1.1

This is the error I am getting!

This Account Has Exceeded Its CPU Quota 

Please contact this site's webmaster.

Wait a few minutes and use your browser's "Back" button or click here to try again.




--------------------------------------------------------------------------------
If you are the webmaster, your account may have exceeded for one or more of the following reasons:
Your site has used more than 20% of the cpu.
Your account has too many processes running at the same time.
Your site was consuming too many resources. This happens on occassion to very busy sites that have inefficient scripts running.



#2 trq

trq
  • Staff Alumni
  • Advanced Member
  • 31,041 posts

Posted 28 October 2006 - 06:09 AM

Everytime someone requests a page on the web they are using http's get method. Sounds to me like you need more bandwidth.

#3 graphicguy

graphicguy
  • New Members
  • Pip
  • Newbie
  • 5 posts

Posted 28 October 2006 - 04:23 PM

Hey, I have tons of bandwith its using to many cpu resources for example this is one of them,

Sat Oct 28 06:21:15 2006: used 3.59 seconds of cpu time for HTTP Request: www.asdf.com : GET /page/count/733/ HTTP/1.0

I used $_GET alot for example,

$update = mysql_query("update users set date = CURDATE( ) where id = '$_GET[id]'");



#4 wildteen88

wildteen88
  • Staff Alumni
  • Advanced Member
  • 10,482 posts
  • LocationUK, Bournemouth

Posted 28 October 2006 - 05:54 PM

GET shouldnt be eating up your CPU. It is your PHP script that is eating up your RAM/CPU. If you are using mysql queries then that is most probably the culprit. Try and optimize your SQL Queries/database structure

It doesnt matter how many GETs you use or what ever.

#5 .josh

.josh
  • Staff Alumni
  • .josh
  • 14,871 posts

Posted 28 October 2006 - 06:06 PM

slightly off topic: you shouldn't be putting your $_GET variables directly into your queries like that.  This doesn't have anything to do with resources; it's a security issue.  Doing that makes your site ripe for sql injection.

Here's a thought: maybe someone has figured out this, and they are exploiting you. Have you checked any of your logs? checked your database?
Did I help you? Feeling generous? Buy me lunch! 
Please, take the time and do some research and find out how much it would have cost you to get your help from a decent paid-for source. A "roll-of-the-dice" freelancer will charge you $5-$15/hr. A decent entry level freelancer will charge you around $15-30/hr. A professional will charge you anywhere from $50-$100/hr. An agency will charge anywhere from $100-$250/hr. Think about all this when soliciting for help here. Think about how much money you are making from the work you are asking for help on. No, we do not expect you to pay for the help given here, but donating a few bucks is a fraction of the cost of what you would have paid, shows your appreciation, helps motivate people to keep offering help without the pricetag, and helps make this a higher quality free-help community :)

#6 graphicguy

graphicguy
  • New Members
  • Pip
  • Newbie
  • 5 posts

Posted 28 October 2006 - 09:37 PM

GET shouldnt be eating up your CPU. It is your PHP script that is eating up your RAM/CPU. If you are using mysql queries then that is most probably the culprit. Try and optimize your SQL Queries/database structure

It doesnt matter how many GETs you use or what ever.


Hey, How would I go about optimizing them to make them better?

#7 maddog39

maddog39
  • New Members
  • Pip
  • Newbie
  • 7 posts

Posted 29 October 2006 - 04:29 PM

By using less queries and or combining queries using LEFT JOIN and also you could implement a page caching system.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users