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 IMPORTANT* that you use it.
Otherwise, you may compile a binary that crashes randomly. We also
recommend that you use `-felide-contructors' and `-fno-rtti' along with
`-fno-exceptions'. When in doubt, do the following:
CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors
-fno-exceptions -fn
o-rtti" ./configure --prefix=/usr/local/mysql --enable-assembler
--with-mysqld-l
dflags=-all-static
..."
i did it - compiled - it helped
[EMAIL PROTECTED] wrote:
>
> 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
--
Regards,
Oleg Prokopyev
OAP4-RIPE
---------------------------------------------------------------------
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
