On Wed, Feb 06, 2002 at 02:57:51PM +0200, Sinisa Milivojevic wrote: > Franklin, Kevin writes: > > We are running an extremely large instance of mysql version 3.23.46 on > > Solaris 2.8. We are attempting to use a software version compiled 64 bit > > and have been experiencing memory related server crashes. > > > > The behavior suggests that we are still unable to use more than 4G of > > memory. > > > > If the server is started with the following settings: > > > > key_buffer=4608M > > max_allowed_packet=1M > > table_cache=1024 > > record_buffer=1M > > sort_buffer=1M > > thread_cache=12 > > thread_concurrency=12 > > myisam_sort_buffer_size=512M > > > > We observe the following symptoms / problems: > > (1) A "mysqladmin variables" call shows that the key_buffer is set to be 1 > > G, not 4.5G. > > (2) Under any sort of database load, the server crashes with the following > > error output: > > > > mysql got signal 10; > > 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=4831834112 > > record_buffer=1044480 > > sort_buffer=1048568 > > max_used_connections=0 > > max_connections=512 > > threads_connected=1 > > It is possible that mysqld could use up to > > key_buffer_size + (record_buffer + sort_buffer)*max_connections = 5765112 K > > bytes of memory > > Hope that's okay, if not, decrease some variables in the equation. > > > > > > If the server is started with more modest settings (e.g., > > key_buffer_size=2G), mysql operates correctly. Additionally, "mysqladmin > > variables" shows a correct key_buffer value. > > > > System memory is not a constraint ( 6 G real memory and 14.5 G swap). > > Hi! > > This is a problem that we would like to take a look at !! > > Please provide us with details on how have you built MySQL. For the > start ...
MySQL 3.23.46 was built with the Sun C++ compiler: $ CC -V CC: Sun WorkShop 6 update 2 C++ 5.3 Patch 111685-03 2001/10/19 It was built as follows: CC=cc CFLAGS="-mr -Qn -xstrconst -xO2 -xtarget=generic -xarch=v9" \ CXX=CC CXXFLAGS="-xO2 -xtarget=generic -xarch=v9" \ CPPFLAGS="-I/opt/TWWfsw/readline42a/include \ -I/opt/TWWfsw/zlib11/include -I/opt/TWWfsw/ncurses5/include \ -I/opt/TWWfsw/ncurses5/include/ncurses" \ LDFLAGS="-L/opt/TWWfsw/readline42a/lib/sparcv9 \ -L/opt/TWWfsw/zlib11/lib/sparcv9 -L/opt/TWWfsw/ncurses5/lib/sparcv9 \ -L/opt/TWWfsw/readline42a/lib/sparcv9 \ -R/opt/TWWfsw/readline42a/lib/sparcv9:\ /opt/TWWfsw/zlib11/lib/sparcv9:/opt/TWWfsw/ncurses5/lib/sparcv9 \ -xarch=v9" ./configure --localstatedir=/var/opt/TWWfsw/mysql32346 \ --sysconfdir=/etc/opt/TWWfsw/mysql32346 --enable-shared \ --enable-static --without-debug --with-innodb --without-bench \ --without-readline --enable-strcoll --with-libwrap \ --with-berkeley-db --enable-thread-safe-client \ --prefix=/opt/TWWfsw/mysql32346 -- albert chin ([EMAIL PROTECTED]) --------------------------------------------------------------------- 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