We have seen some strange problems with Linux 2.2.14 and
MySQL on SMP systems. We also have reports from some MySQL
users that they have encountered serious stability problems
using MySQL with kernel 2.2.14. If you are using this
kernel, you should upgrade to 2.2.19 (or newer) or to a 2.4
kernel. If you have a multiple-CPU box, you should seriously
consider using 2.4 because it gives you a significant speed
boost. Your system should be more stable.
When using LinuxThreads, you should see a minimum of three
mysqld processes running. These are in fact
threads. There is one thread for the LinuxThreads manager, one
thread to handle connections, and one thread to handle alarms
and signals.