On Mon, 14 Jun 2004, Bopolissimus X Platypus wrote: .. > was it running as root? how can a user process crash a box?
MySQL is very threads-intensive. I guess (in those days) it would exercise obscure corner-cases in the kernel threading implementation, because on Solaris it was solid (Solaris had a much more mature thread implementation than Linux pthreads or BSD outside-the-kernel threads). Don't know about NPTL these days, plus, MySQL now has the InnoDB table type which helps A LOT not just for commit/rollback but row-level locking. The standard MyISAM table type is table-level locks so in a highly transactional environment you end up with hundreds of deadlocked threads.. which is what eventually causes the box to crash. --- Orlando Andico <[EMAIL PROTECTED]> Mosaic Communications, Inc. -- Philippine Linux Users' Group (PLUG) Mailing List [EMAIL PROTECTED] (#PLUG @ irc.free.net.ph) Official Website: http://plug.linux.org.ph Searchable Archives: http://marc.free.net.ph . To leave, go to http://lists.q-linux.com/mailman/listinfo/plug . Are you a Linux newbie? To join the newbie list, go to http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie
