high server loads - do i need more RAM?

Hi all, I'm experiencing very high server loads and this slows down my website. I used 2 servers (Dual Xeon, SCSI HDD, 2GB RAM each) for 1 website, 1 server for http and 1 for mysql connected via cross connect cable. I've also tried to optimized httpd.conf and my.cnf but this is as good as it gets on my own effort. Could anyone recommend something for me like whether I should get more RAM or some other solutions? Thanks in advance!

http server

00:47:42 up 10 days, 53 min, 1 user, load average: 36.67, 41.66, 91.12
474 processes: 443 sleeping, 28 running, 2 zombie, 1 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 94.8% 0.0% 3.0% 0.1% 1.0% 0.0% 0.8%
cpu00 89.4% 0.0% 4.1% 0.5% 2.5% 0.0% 3.1%
cpu01 96.2% 0.0% 3.3% 0.0% 0.3% 0.0% 0.0%
cpu02 95.2% 0.0% 3.1% 0.1% 1.3% 0.0% 0.0%
cpu03 98.6% 0.0% 1.1% 0.0% 0.1% 0.0% 0.0%
Mem: 2075792k av, 1535224k used, 540568k free, 0k shrd, 47544k buff
1276972k active, 169912k inactive
Swap: 2040212k av, 923380k used, 1116832k free 160356k cached

mysql server

00:41:03 up 29 days, 18:46, 1 user, load average: 25.99, 22.32, 16.35
62 processes: 59 sleeping, 2 running, 1 zombie, 0 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 86.9% 0.0% 11.3% 0.1% 0.6% 0.0% 0.8%
cpu00 85.0% 0.0% 10.9% 0.7% 2.3% 0.0% 0.7%
cpu01 86.2% 0.0% 12.7% 0.0% 0.1% 0.0% 0.7%
cpu02 87.0% 0.0% 10.9% 0.0% 0.0% 0.0% 1.9%
cpu03 89.4% 0.0% 10.5% 0.0% 0.0% 0.0% 0.0%
Mem: 2075964k av, 2057884k used, 18080k free, 0k shrd, 34708k buff
1934676k active, 87144k inactive
Swap: 2040244k av, 221200k used, 1819044k free 755272k cached

mysql variables

Variable Global value
back log 50
basedir /usr/local/mysql/
binlog cache size 32768
bulk insert buffer size 8388608
concurrent insert ON
connect timeout 5
convert character set
datadir /var/lib/mysql/
default week format 0
delay key write ON
delayed insert limit 100
delayed insert timeout 300
delayed queue size 1000
flush OFF
flush time 0
ft boolean syntax + -><()~*:""&|
ft min word len 4
ft max word len 254
ft max word len for sort 20
ft stopword file (built-in)
have bdb NO
have crypt YES
have innodb YES
have isam YES
have raid NO
have symlink YES
have openssl NO
have query cache YES
init file
innodb additional mem pool size 1048576
innodb buffer pool size 8388608
innodb data file path ibdata1:10M:autoextend
innodb data home dir
innodb file io threads 4
innodb force recovery 0
innodb thread concurrency 8
innodb flush log at trx commit 1
innodb fast shutdown ON
innodb flush method
innodb lock wait timeout 50
innodb log arch dir ./
innodb log archive OFF
innodb log buffer size 1048576
innodb log file size 5242880
innodb log files in group 2
innodb log group home dir ./
innodb mirrored log groups 1
innodb max dirty pages pct 90
innodb max purge lag 0
innodb table locks ON
interactive timeout 28800
join buffer size 131072
key buffer size 1073741824
language /usr/local/mysql/share/mysql/english/
large files support ON
license GPL
local infile ON
locked in memory OFF
log OFF
log update OFF
log bin OFF
log slave updates OFF
log slow queries ON
log warnings 1
long query time 3
low priority updates OFF
lower case file system OFF
lower case table names 0
max allowed packet 1048576
max binlog cache size 4294967295
max binlog size 1073741824
max connections 800
max connect errors 10
max delayed threads 20
max insert delayed threads 20
max heap table size 16777216
max join size 4294967295
max relay log size 0
max seeks for key 4294967295
max sort length 1024
max user connections 0
max tmp tables 32
max write lock count 4294967295
myisam max extra sort file size 268435456
myisam max sort file size 2147483647
myisam repair threads 1
myisam recover options OFF
myisam sort buffer size 8388608
net buffer length 16384
net read timeout 30
net retry count 10
net write timeout 60
new OFF
open files limit 5610
log error
port 3306
protocol version 10
query alloc block size 8192
query cache limit 1048576
query cache size 20971520
query cache type ON
query prealloc size 8192
range alloc block size 2048
read buffer size 131072
read only OFF
read rnd buffer size 262144
rpl recovery rank 0
server id 0
slave net timeout 3600
skip external locking ON
skip networking OFF
skip show database OFF
slow launch time 2
socket /var/lib/mysql/mysql.sock
sort buffer size 2097144
sql mode 0
table cache 2400
table type MYISAM
thread cache size 40
thread stack 196608
tx isolation REPEATABLE-READ
tmp table size 33554432
tmpdir /tmp/
transaction alloc block size 8192
transaction prealloc size 4096
version 4.0.23a-log
version comment Source distribution
version compile os redhat-linux-gnu
wait timeout 28800

httpd.conf

Timeout 300
KeepAlive On
MaxKeepAliveRequests 300
KeepAliveTimeout 5
MinSpareServers 20
MaxSpareServers 35
StartServers 15
MaxClients 800
MaxRequestsPerChild 50

P.s. I know some would question about KeepAlive On but I have many images on my site.

 

 

 

 

Top