Process running none stop and eating CPU !!!

I have issue where a process or something similar is eating this CPU and causing running issues at times .... 

running 'top' command in SSH I see some crazy readings .....   I'm looking for advise to to identify what exactly is causing this issue;

This is like WTTFFF?!

top - 20:31:34 up  2:12,  2 users,  load average: 0.85, 0.60, 0.72
Tasks: 284 total,   1 running, 282 sleeping,   0 stopped,   1 zombie
Cpu(s): 23.8%us,  1.7%sy,  0.0%ni, 74.5%id,  0.1%wa,  0.0%hi,  0.0%si,  0.0%st
Mem:  16447788k total,  1829384k used, 14618404k free,    83416k buffers
Swap:  4194288k total,        0k used,  4194288k free,   504692k cached

  PID USER       PR  NI   VIRT  RES  SHR S     %CPU  %MEM     TIME+     COMMAND
 1891 mysql       20   0   2961m 180m 6896 S     102.3   1.1          48:08.89   mysqld
 8584 ********     20   0   287m  20m 8104 S        21.3      0.1         0:00.73     php-cgi
 8583 ********     20   0   284m  19m 7628 S        14.3      0.1        0:00.47      php-cgi

 

I have another post here detailing some errors I have and I don't know if they related: http://www.boonex.com/forums/topic/Whats-this-error-and-how-to-fix-.htm

DedicatedServer4You.com -- BIGGEST Range of Dedicated Servers at the Lowest Price!
Quote · 10 Nov 2012

This is outrageous;-

 1891 mysql       20   0   2961m 180m 6896 S     102.3   1.1          48:08.89   mysqld

DedicatedServer4You.com -- BIGGEST Range of Dedicated Servers at the Lowest Price!
Quote · 10 Nov 2012

mysqld process just hit 160% CPU ....!

DedicatedServer4You.com -- BIGGEST Range of Dedicated Servers at the Lowest Price!
Quote · 10 Nov 2012

damn... sorry went to press reply and hit report !!! ffs .... lol

at times I have watched the loads hit:  load average: 8.83, 7.21, 5.28

and even:  load average: 6.40, 10.50, 7.00

this happens very often and rapidly!    I am admin of own dedicated server so don't have support as far as all this ...

This cannot be right !   I need to identify which process is running none stop and causing a server (which is awesome) to fail at times?

DedicatedServer4You.com -- BIGGEST Range of Dedicated Servers at the Lowest Price!
Quote · 10 Nov 2012

Also last week I had over 130K unique visitors and server was running beautifully .....

Today (which these readings are from) the network is very quiet and yet I get these high loads ?

don't make sense ....

damn sorry when to press reply and hit report !!! ffs .... lol

at times I have watched the loads hit:  load average: 8.83, 7.21, 5.28

and even:  load average: 6.40, 10.50, 7.00

this happens very often and rapidly!    I am admin of own dedicated server so don't have support as far as all this ...

This cannot be right !   I need to identify which process is running none stop and causing a server (which is awesome) to fail at times?

 

DedicatedServer4You.com -- BIGGEST Range of Dedicated Servers at the Lowest Price!
Quote · 10 Nov 2012
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.