I am hosting with dreamhost and I have got lots of sites hosted under the same account. I need to lower the cpu usage, what can i do?
1)stop advertising your site and ban some of your visitors , 2) Tweak your php scripts if you are good at programming
well there could be a number of ways to deal with this. Ask your host to move you to another server or buy a different "type" of hosting, ie: semi-ded. server, VPS, etc..
If the applications you're running have caching options do use them. PHP/MySQL is very cpu intensive compared to static html pages. So if the script has the option of that sort of caching it's a good thing to turn on.
Being in a shared hosting, it is really hard yourself to control the load i believe. What only you can do is making sure your php-mysql coding is bugless. Most of the time mysql open socks gives problem with the unexpected server load. So make sure you close the mysql connections after using them
most heavy resources are attributed to poor code. if your the programmer double check your code. It can make a big difference. If your positive your clean then check with your provider to see any upgrade paths.