99.9% MySql CPU Usage, how bad is this?

Hey there,

My server is having some strange problems. They have been going on forever and even on different servers, so hopefully someone can point me in the right direction.

My server is a...
P4 3.0 Ghz
2gb RAM

Here is the TOP

PHP Code:
132 processes: 129 sleeping, 3 running, 0 zombie, 0 stopped
CPU states:  cpu    user    nice  system    irq  softirq  iowait    idle
           total  163.4%    0.0%   10.8%   0.0%     0.0%    0.0%   25.4%
           cpu00   75.4%    0.0%    6.1%   0.0%     0.0%    0.0%   18.3%
           cpu01   88.0%    0.0%    4.8%   0.0%     0.0%    0.0%    7.1%
Mem:  2067164k av, 1951244k used,  115920k free,       0k shrd,  209048k buff
       849960k active,             932056k inactive
Swap: 1831400k av,   80204k used, 1751196k free                 1253012k cached

  PID USER     PRI  NI  SIZE  RSS SHARE STAT %CPU %MEM   TIME CPU COMMAND
 4115 mysql     16   0  160M 125M  5404 S    99.9  6.1 168:07   1 mysqld
14367 root      16   0  6984 6804  6728 S     5.8  0.3  84:27   1 httpd
30023 root      17   0  1260 1260   896 R     1.8  0.0   0:01   0 top
  124 root      15   0     0    0     0 SW    0.1  0.0   1:55   0 kjournald
 3833 named     18   0  4328 4116  1788 S     0.1  0.1   2:59   0 named
29981 root      15   0  1984 1976  1724 S     0.1  0.0   0:00   1 sshd
    1 root      16   0   424  392   372 S     0.0  0.0   0:10   1 init
    2 root      RT   0     0    0     0 SW    0.0  0.0   0:00   0 swapper 
Is there any way I can figure this out?

The CPU Usage is at 5-15, and I'd really like to see it lowered and possible faster page loading times.

Regards,
-Dusk

 

 

 

 

Top