List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:May 13 2002 7:45pm
Subject:Re: [bug] Multiple daily crashes of mysql/innodb
View as plain text  
Use gcc 2.95.3

jason@stripped 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 <mysql-thread108911@stripped>
>To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


Thread
[bug] Multiple daily crashes of mysql/innodbjason13 May
  • Re: [bug] Multiple daily crashes of mysql/innodbGerald Clark13 May
Re: [bug] Multiple daily crashes of mysql/innodbHeikki Tuuri13 May