MySQL Ded. Server - Where is the Bottleneck?

MySQL 4.0.18 is running on dedicated Dual Xeon by itself with 2G memory, SCSI disk. Right now loads are reaching 5 but I can't see where the bottleneck is. Can some tell me what it is, or if there is some other information that I can find this in? The output of top, free -m and vmstat are pasted below. Thanks.

14:24:56 up 152 days, 2:07, 1 user, load average: 5.15, 4.60, 3.51
63 processes: 54 sleeping, 9 running, 0 zombie, 0 stopped
CPU0 states: 91.3% user 8.1% system 0.0% nice 0.0% iowait 0.1% idle
CPU1 states: 94.5% user 5.0% system 0.0% nice 0.0% iowait 0.0% idle
CPU2 states: 97.0% user 2.5% system 0.0% nice 0.0% iowait 0.0% idle
CPU3 states: 97.3% user 2.1% system 0.0% nice 0.0% iowait 0.1% idle
Mem: 2067912k av, 1897360k used, 170552k free, 0k shrd, 139924k buff
494456k active, 1282780k inactive
Swap: 2096472k av, 1792k used, 2094680k free 1226000k cached

PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
24831 mysql 9 0 404M 403M 1388 S 99.9 19.9 9:14 2 mysqld

---

$ free -m
total used free shared buffers cached
Mem: 2019 1844 175 0 136 1197
-/+ buffers/cache: 510 1509
Swap: 2047 1 2045

---

$ vmstat 1
procs memory swap io system cpu
r b w swpd free buff cache si so bi bo in cs us sy id
3 0 0 1792 175788 139948 1226032 0 0 0 1 0 1 2 4 0
2 0 0 1792 177304 139956 1226032 0 0 0 168 485 1465 69 5 25
3 0 0 1792 175236 139956 1226032 0 0 0 0 508 1991 77 4 19
3 0 0 1792 174604 139956 1226032 0 0 0 0 302 130 76 3 21
3 0 0 1792 174576 139956 1226032 0 0 0 0 373 288 74 3 23
3 0 0 1792 174564 139956 1226032 0 0 0 0 325 228 74 2 24

 

 

 

 

Top