help tracking down mysql excessive use

pingo

Well-Known Member
Nov 16, 2002
428
0
166
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