Hi, I think this is more than a threads problem. If your machine has run fine with this software for more than two years and you have not made any changes, then I doubt that the threads problems would be 'suddenly' affecting you this badly. Could you be having hardware problems at this point? Are you running ECC or parity memory? Did the fan die in system? I would not dismiss this as a 'threads problem'. If you have been running fine for two years I would look more closely at hardware.
Good Luck, Ken ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 31, 2002 3:26 AM Subject: 97% CPU MySQL freeze Problem > > hello, > > our mysql-system worked fine for 2 years. > (per day 80.000 pageviews and 200.000 SQL requests) > no changes in programs or system have been made. > > since some days we have a critical problem: > 1 or 2 times a day the mysql CPU usage grows up to 97% > (normally 20-40%) and mysql-daemon freezes. > > mysql shutdown or kill do not work, > only kill -9 will do, but can damage the tables. > > we have checked all tables with isamchk : ok > i found some similar mysql-daemon-freeze reports in www > but no solution how to fix it. > > who has any idea ? > thanks for your help ! > > kind regards > peter > > > mysql : 3.22.22 > os : FreeBSD 3.2 > system : intel dual pentium > ram : 512 MB > > -------------------------------------------------------------------- - > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
