After server load problems on shared host I finaly moved to a vps to see whats going on on the serverside.
Guaranteed RAM 256 MB
Burstable RAM 1 GB
Got 4 CPUs: Intel(R) Xeon(TM) CPU 3.00GHz cache 1024 KB
I did apache and mysql config tweaks that people advice on forums. And so many optimizations on mysql queries. I think tweaks reduced server load a few but I got this "top" stats:
<snip>
httpd with PID 2240 is making 99% cpu usage average every 5 seconds and mysql going 99% sometimes mostly httpd. Load 7.12 but on cpanel service status about 1.5 at that time. But during high traffic hours it goes 10-15. I got about 8000 unique visitors.
I have to solve this problem. Please help me to find out what is making this cpu load.
[edited by: engine at 10:00 am (utc) on Dec. 19, 2005]
[edit reason] TOS [/edit]
