>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
