From: Mike Bretz
Date: March 21 1999 6:34pm
Subject: * DEAD * mysqld, exhausting overall memory
List-Archive: http://lists.mysql.com/mysql/723
Message-Id: <199903211834.TAA30760@chat3d.metropolis.de>

>Description:
  	the mysqld stop's non reproducable on 1 of our databases. Is goes to
        '*** DEAD ***' status and causes all other mysqld to hang. Also it
        consumes all available memory.

>How-To-Repeat:
	the database is part of a web project. Only simple selects and simple
        updates are made. Could not be repeated with simple scripts, but with
        the 'real web' accesses.

>Fix:
	Deleting a specific row where the problem occured _most_ of the time
        helped a little. But problem still exists, but not that often anymore.

>Submitter-Id:	<submitter ID>
>Originator:	Mike Bretz
>Organization:  21Torr medienDesign GmbH, Reutlingen, Germany
>MySQL support: none
>Synopsis:	*** DEAD *** mysqld processes causing overall hanging
>Severity:	critical
>Priority:	high
>Category:	mysql
>Class:		sw-bug
>Release:	mysql-3.22.20a (Source distribution)

>Environment:
	
System: Linux db 2.0.36 #8 Tue Dec 8 15:34:59 MET 1998 i686 unknown
Architecture: i686

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i486-linux/egcs-2.91.60/specs
gcc version egcs-2.91.60 19981201 (egcs-1.1.1 release)
Compilation info: CC='gcc'  CFLAGS=''  CXX='c++'  CXXFLAGS=''  LDFLAGS=''
Configure command: ./configure  --prefix=/usr/local/mysql --localstatedir=/usr/local/mysqldata --with-debug --without-bench
Perl: This is perl, version 5.005_02 built for i586-linux