Re: 97% CPU MySQL freeze Problem

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

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