help tracking down mysql excessive use

[WebHostPro]

Hello,

I can't seem to track down who using huge mysql resource:

mysql 1.29 0.80

Any ideas would be very helpful.

I have checked the message log but no help so far.

 

[pingo]

You can look at mysql processes by:

mysqladmin -p processlist

The following command will show the top 10 CPU hogs. The worst is at the bottom:

ps -efw --sort %cpu | tail

John

 

[Juanra]

mtop.sf.net