In phpMyAdmin, when I run Show Processes, should that list all of the current MySQL processes running? This server has mysql taking 95-99% of the CPU an dthe load averages are around 1 when they are normally .05. Any idea on how to track down what is causing this?
last pid: 77688; load averages: 1.25, 1.14, 1.08 up 86+22:59:50 07:13:17
61 processes: 2 running, 59 sleeping
CPU states: 24.9% user, 0.0% nice, 73.5% system, 1.6% interrupt, 0.0% idle
Mem: 246M Active, 294M Inact, 141M Wired, 26M Cache, 85M Buf, 14M Free
Swap: 1317M Total, 476K Used, 1317M Free
PID USERNAME PRI NICE SIZE RES STATE TIME WCPU CPU COMMAND
14590 mysql 132 0 81008K 72380K RUN 66.8H 87.84% 87.84% mysqld
73612 apache 20 0 38544K 32228K lockf 0:04 0.15% 0.15% httpd
last pid: 77688; load averages: 1.25, 1.14, 1.08 up 86+22:59:50 07:13:17
61 processes: 2 running, 59 sleeping
CPU states: 24.9% user, 0.0% nice, 73.5% system, 1.6% interrupt, 0.0% idle
Mem: 246M Active, 294M Inact, 141M Wired, 26M Cache, 85M Buf, 14M Free
Swap: 1317M Total, 476K Used, 1317M Free
PID USERNAME PRI NICE SIZE RES STATE TIME WCPU CPU COMMAND
14590 mysql 132 0 81008K 72380K RUN 66.8H 87.84% 87.84% mysqld
73612 apache 20 0 38544K 32228K lockf 0:04 0.15% 0.15% httpd