Use gcc 2.95.3 [EMAIL PROTECTED] wrote:
>>Description: >> > Our mysql server is crashing multiple times every day. In looking through the >logs, in mentions that we should check our key buffer, but the memory size is well >within our systems ability. Basically, if I don't find out how to prevent this/what >the problem is then my boss won't allow innodb anymore. >Hardware is a quad-Xeon box, and a dual Pentuim III. >2 gb RAM >dedicated mysql server. > >>How-To-Repeat: >> > haven't figured it out yet, it does repeat several times a day > >>Fix: >> > unknown > >>Submitter-Id: <submitter ID> >>Originator: >>Organization: >> > > >>MySQL support: none yet >>Synopsis: daily crashing of mysql (usually Innodb) >>Severity: serious >>Priority: high >>Category: mysql/innodb >>Class: sw-bug >>Release: mysql-3.23.49a-max (Official MySQL Binary) >>Server: /opt/mysql/bin/mysqladmin Ver 8.23 Distrib 3.23.49a, for pc-linux-gnu on >i686 >> >Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB >This software comes with ABSOLUTELY NO WARRANTY. This is free software, >and you are welcome to modify and redistribute it under the GPL license > >Server version 3.23.49a-max-log >Protocol version 10 >Connection Localhost via UNIX socket >UNIX socket /tmp/mysql.sock >Uptime: 1 hour 1 min 45 sec > >Threads: 73 Questions: 631834 Slow queries: 49 Opens: 3256 Flush tables: 1 Open >tables: 512 Queries per second avg: 170.535 > >>Environment: >> > >System: Linux db4.recruitomatic.com 2.4.9-21.0RSenterprise #1 SMP Fri Jan 25 04:25:45 >CST 2002 i686 unknown >Architecture: i686 > >Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc >GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs >gcc version 2.96 20000731 (Red Hat Linux 7.1 2.96-85) >Compilation info: CC='gcc' CFLAGS='-Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch >-Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec >-Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro >-O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-Wimplicit -Wreturn-type >-Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat >-Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings >-Woverloaded-virtual -Wextern-inline -Wsign-promo -Wreorder -Wctor-dtor-privacy >-Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -mcpu=pentiumpro >-O3 -fno-omit-frame-pointer' LDFLAGS='' >LIBC: >lrwxrwxrwx 1 root root 13 Apr 22 11:55 /lib/libc.so.6 -> >libc-2.2.4.so >-rwxr-xr-x 2 root root 5734740 Apr 2 10:44 /lib/libc-2.2.4.so >-rw-r--r-- 1 root root 27332668 Apr 2 10:42 /usr/lib/libc.a >-rw-r--r-- 1 root root 178 Apr 2 10:42 /usr/lib/libc.so >lrwxrwxrwx 1 root root 10 Apr 22 11:55 /usr/lib/libc-client.a -> >c-client.a >Configure command: ./configure --prefix=/usr/local/mysql --enable-assembler >--with-extra-charsets=complex --enable-thread-safe-client --with-innodb >--with-berkeley-db --enable-thread-safe-client >--with-other-libc=/usr/local/mysql-glibc '--with-comment=Official MySQL Binary' >--prefix=/usr/local/mysql --with-extra-charset=complex --enable-thread-safe-client >--enable-local-infile --with-server-suffix=-max 'CFLAGS=-Wimplicit -Wreturn-type >-Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat >-Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings >-Wunused -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' 'CXXFLAGS=-Wimplicit >-Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts >-Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare >-Wwrite-strings -Woverloaded-virtual -Wextern-inline -Wsign-promo -Wreorder >-Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-r! >tti -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' CXX=gcc > > >--------------------------------------------------------------------- >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