server overload with strange behaviour ... please give me a hand

hi ..


i am facing overload problem over 2 monthes ...

i tried my best to solve it out but .. i faild ...

i found someone who could optimize my server ... and he tried to solve it out ... , then told me, my server which host only three websites is too weak and i need to order for new RAMS, but i moved to new server much better n order to solve this problem
my new server details are:

Dual Xeon - 3.2Ghz - Redhat Enterprise - 2-250GBHD-SATA - 2GB RAM


it cost me $400 .... but the problem still remain server overload with strange behaviour ... please give me a hand


the problem in short is : overload with strange behaviour ...

now my server load is only 0.17 ... but with unknowen reason it become over 50 and some time over 100... and then overload comes down to 0.00

we did our best again ... we changed the hard disk from SATA to IDE ... but without any serious change ...


so now i am just montring my server and when there is overload i just restart mysql ...



could you help me please to solve out this problem from your experince???

if not... is that possible to write an script when the overload over 10 ... just restart mysql ????

thank you

 

 

 

 

Top