Yesterday, our Moodle server CPU load was over 90% and I was forced to reboot the machine. There was about 300 httpd's in the process list also.
Screenshot below was taken while there are only 10 users currently logged in.
Dual Core 2.5 Ghz Processor
4 GB RAM
Server Limit 300
We have change the statistics settings to keep stats for only 90 days from forever before, hoping that would bring the DB size down a bit.
I have read other forum topics and people have mentions installing eAccelerator, maybe settings up a proxy, or having the DB on a different machine. I'm not convinced this is what needs to happen as the machine specs we have are plenty for running a Moodle server, especially seeing the specs of other setups with no issues. I agree, eAccelerator would definitely help on any server though.
There has to be a configuration somewhere, but I think I'm just looking in the wrong places.
Any help would be appreciated!