Re: 97% CPU MySQL freeze Problem

2002-01-31 Thread Ken Menzel
> 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. > &

Re: 97% CPU MySQL freeze Problem

2002-01-31 Thread Oleg Prokopyev
hi i had the same problem on my freebsd 4.4 i installed mysql from ports and then had such a problem then i took sources from mysql.com and in file "INSTALL-SOURCE" i found: "... If you are using a recent version of *gcc*, recent enough to understand `-fno-exceptions' option, it is *VERY IMPORTA

Re: 97% CPU MySQL freeze Problem

2002-01-31 Thread Russell King
> 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 : 3.22.22 > os : FreeBSD 3.2 > system : intel dual pentium > ram : 512 MB This is a known problem with the threading library on FreeBSD. A

97% CPU MySQL freeze Problem

2002-01-31 Thread meier77
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.