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
