Do I need more RAM?

Hi I'm running a dual xeon with 2GB RAM for this dedicated mysql server. Would appreciate any advice if I need more RAM to improve performance and reduce CPU load? My my.cnf configuration is very well optimised already. Thanks.

The following is my top results during PEAK time.

23:24:16 up 3 days, 3:08, 1 user, load average: 32.59, 24.26, 21.91
51 processes: 49 sleeping, 2 running, 0 zombie, 0 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 88.0% 0.0% 10.4% 0.0% 0.3% 0.0% 0.9%
cpu00 89.6% 0.0% 8.9% 0.1% 0.1% 0.0% 0.9%
cpu01 93.8% 0.0% 4.6% 0.0% 0.0% 0.0% 1.6%
cpu02 78.4% 0.0% 18.7% 0.1% 1.3% 0.0% 1.1%
cpu03 90.4% 0.0% 9.3% 0.0% 0.1% 0.0% 0.0%
Mem: 2075964k av, 1880416k used, 195548k free, 0k shrd, 28328k buff
1775528k active, 72636k inactive
Swap: 2040244k av, 10992k used, 2029252k free 639152k cached

 

 

 

 

Top