>Description:
on heavy use (350-370 mysql threads, connections opened by multiple
apache webservs) one of the mysql threads suddenly defuncts and mysql does
not accept or serve any connections anymore. if more threads are opened the
probability of defuncting increases. with 350 connections the bug occurs
really seldom (once a week or so), with 360 threads in the next hour and
with 370 threads nearly immediately.
if you connect with the mysql client no response is given at all, and all
other opened threads do not respond and just idle. if you try to stop mysqld
with the redhat mysql shutdown scripts, mysqld doesn't stop. "waiting for
mysql to exit ..." keeps returning ~20 times and nothing happens. the only
solution is to reboot the computer, fix the now corrupted tables with
myisamchk and restart mysql.
what's really weird is that no errors can be found afterwars in the error
logs of the system / of mysql. mysql simply stops working.
I have 2 mysql servers running with the same setup and the same bug occurs
at both machines.
this problem is about the same as metioned in
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:23855 except that I don't get
any error messages in the errorlogfile, not even the "Aborted connection xx
to xx..." error.
i have already increased my file descriptor limit from 1024 to 4096 but it
didn't change anything.
>How-To-Repeat:
didn't find a way to repeat it yet.
>Fix:
limiting the load of the db server to less than 350 threads. with
less threads and less load everything works perfect. but the servers are
only running at about 20% of their capacity with these limits, since it's
impossible to increase it
>Submitter-Id: <submitter ID>
>Originator: Richard Lohwasser, [EMAIL PROTECTED]
>Organization:
clanintern GmbH (www.clanintern.com)
>MySQL support: none (yet :)
>Synopsis: MySQL defuncting on heavy use
>Severity: serious
>Priority: high
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.29-gamma (Source distribution)
>Environment:
dual p3-800 with 1gb ram and raid1-u160 harddrives running on red hat 7
System: Linux sql1.clanintern.de 2.2.18pre24b010125/2 #25 SMP Tue Feb 20
17:42:03 CET 2001 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.0)
Compilation info: CC='gcc' CFLAGS='-O2 -march=i386 -mcpu=i686' CXX='c++'
CXXFLAGS='-O2 -march=i386 -mcpu=\
i686' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 11 Dec 6 10:56 /lib/libc.so.6 ->
libc-2.2.so
-rwxr-xr-x 1 root root 4733359 Nov 19 15:25 /lib/libc-2.2.so
-rw-r--r-- 1 root root 22806158 Nov 19 15:22 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Nov 19 15:22 /usr/lib/libc.so
Configure command: ./configure
i386-redhat-linux --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --sbind
\
ir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --includedir=/usr/includ
e --libdir=/usr/lib --libexecdir\
=/usr/libexec --localstatedir=/var --sharedstatedir=/usr/com --mandir=/usr/s
hare/man --infodir=/usr/share/in\
fo --without-debug --without-readline --enable-shared --with-extra-charsets=
complex --without-bench --locals\
tatedir=/var/lib/mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --w
ith-mysqld-user=mysql --with-ext\
ra-charsets=all
---------------------------------------------------------------------
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
