[mistwang]

Originally Posted by mysitegroup

I will be the IOWAIT guy.... ha ha..

What is your servers IOWAIT?

If high, mySQL will fall on it's face - with high load... and this will snowball, with excessive threads being created, and get worse and worse.

Check and fix your IOWAIT (in addition to optimizing mySQL my.cnf file).

Warm regards.

One tip to reduce IOWAIT is to turn off updating access time of file system, search for "noatime" file system mount option for /etc/fstab .