Hi Dave, Couple of things: Did you see these notes? They apply to BSDi also http://www.mysql.com/doc/en/FreeBSD.html Do you have more that 1.2G of free memory? What version of Mysql?
Ken P.S. my compile script rm config.cache CC=gcc CFLAGS="-O3 -DHAVE_BROKEN_REALPATH" CXX=gcc \ CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti -DHAVE_BR OKEN_REALPATH" \ ./configure $DEBUG --enable-large-files --with-innodb \ --enable-assembler gmake -s ----- Original Message ----- From: "Dave Granic" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 16, 2003 8:17 AM Subject: MySQL freezes running under BSDI 4.2 > Going insane, we have a BSDI 4.2 Version running on an under powered > machine, we are trying to load up a new server with more horsepower also > running BSDI 4.2 > > We tried several compiled configurations and the binary distribution and the > server hangs after a about 1-2 hours of use (binary within minutes).. > > compiles fine > /set threads to 2 in my.cnf > correctly set ld.so.conf > > > below is what we find in the .err file > > BSDI is patched up > > /usr/local/mysql/libexec/mysqld: ready for connections > mysqld got signal 11; > This could be because you hit a bug. It is also possible that this binary > or one of the libraries it was linked against is corrupt, improperly built, > or misconfigured. This error can also be caused by malfunctioning hardware. > We will try our best to scrape up some info that will hopefully help > diagnose > the problem, but since we have already crashed, something is definitely > wrong > and this may fail > > key_buffer_size=268431360 > record_buffer=1044480 > sort_buffer=1048568 > max_used_connections=1 > max_connections=500 > threads_connected=2 > It is possible that mysqld could use up to > key_buffer_size + (record_buffer + sort_buffer)*max_connections = 1284136 K > bytes of memory > Hope that's ok, if not, decrease some variables in the equation > > > > > -------------------------------------------------------------------- - > 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
