Guys i am despert here, already get this problem for a week sometime suddenly get high load, and still dont find where is the problem yet


normally the top result like this, load only 0.71, only have 200+ tasks


other screenshots : http://i291.photobucket.com/albums/l...topnormal2.jpg



but sometime suddenly get high load (usually 1-3 times a day), load very high 90-200, with 500+ tasks


other screenshots : http://i291.photobucket.com/albums/l...phighload2.jpg





Daily Process Log, i already repair and optimize all table, like you can see the mysql process is very low (in white line, not in yellow or red line), so its looks like the problem is not in mysql
The red line is maybe apache







Nb1. I use a dedicated server, only host 1 site, here is my server specs
Intel Single Xeon E3110 3.0ghz L2 cache 6MB
Memory 4 GB DDR2 RAM
Harddisk 500 GB Sata 7200rpm
Cent OS 5.4
WHM/Cpanel


Nb2. I already check no backup/cronjob or related scheduled active right now


Nb3. I already disabled the feature one by one, Even i already block all search engine spider now using robots.txt disallow for 2 days, no spiders again in my website until the problem found, its ok i just need to found the source problem


Nb4. I dont think my hosting support can help it, and they cost very expensive for that extra managed service ($69/hour), i want to find the source problem by my self, please analyze and give advice to found the source problem

And do we get a hint at what is running on your server??

Your problem is a lot of processes, CPU load or RAM usage?
CPU load is higher on 1st screenshots

On 2nd screenshot you have more processes and high RAM usage.
The ram is used by mysql server. It eats 1gb of RAM.
Sort it by the RAM size and you will see all RAM consuming processes.

Now you can go to the console and type ps -aux and see what processes are not normally running.

Use "lsof -p PID" to see what process is trying to do, and what files and connection its using atm.

And after all researches you will see where the problem is.

IMHO some of your scripts have bad optimized mysql queries or not closing mysql connection.

And optimize your apache settings. 190Mbs of cached RAM is not normal Usually it should be twice higher than real size (44Mb)