MySQL goes wild

[ASap]

Hi, recently I've been having MySQL load goes wild.

The server wasn't under attack, and MySQL just goes wild.

top - 05:29:04 up 5 days, 20:22,  2 users,  load average: 186.41, 181.80, 138.0
Tasks: 529 total,   4 running, 511 sleeping,  12 stopped,   2 zombie
%Cpu(s):  0.2 us,  0.7 sy,  0.0 ni,  0.0 id, 97.3 wa,  0.0 hi,  1.7 si,  0.0 st
KiB Mem:  10268324 total, 10156360 used,   111964 free,     2184 buffers
KiB Swap:  1997820 total,  1965612 used,    32208 free,   130848 cached

  PID USER      PR  NI  VIRT  RES  SHR S  %CPU %MEM    TIME+  COMMAND
    3 root      20   0     0    0    0 S  24.1  0.0   0:30.36 ksoftirqd/0
 6724 andy      20   0 23688 1232  516 R   5.5  0.0  13:44.94 top
 1720 mysql     20   0 1999m 175m 2008 S   3.9  1.8  49:01.21 mysqld
29977 andy      20   0  297m  33m 1596 S   2.6  0.3 163:38.48 perl

Any clue what's wrong?

When I tried to kill MySQLd, it went into Zombie state, when I tried to kill it's parent PID, then it's parent PID changed to 1 (which is belong to INIT) makes me need to reboot the whole server.

 

[zEitEr]

Hello,

And how much wild is MySQL on your server? Give us more details as possible, with your initial data it is very difficult to give you any proper solution.