From: Michael Widenius Date: March 26 1999 1:20am Subject: mysql leaves a single process that hangs connections List-Archive: http://lists.mysql.com/mysql/989 Message-Id: <14074.57351.624243.115040@monty.pp.sci.fi> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit >>>>> "Zach" == Zach Beane writes: >> Description: Zach> We use a Mysql server as a logging system. Since upgrading Zach> to 3.22.20a, it will frequently (a few times per day) go into a mode where Zach> all threads seem to disappear and a single mysqld process remains. It Zach> binds to the port, but connections to it simply hang, and since it's Zach> binding to the port a new process can't be automatically started. It must Zach> be killed before anything can be done. Hi! Please read the MySQL manual section: Debugging MySQL; This has a lot of tips how you can localize the problem! It may be a compiler problem thought; Can you try to upgrade to egcs 1.1.2 and recompile with the following configure line: CFLAGS="-O6 -mpentium -fomit-frame-pointer" CXX=gcc CXXFLAGS="-O6 -mpentium -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti" ./configure --enable-assembler --with-mysqld-ldflags=-all-static --disable-shared --localstatedir=/usr/local/mysql_db --with-tcp-port=3333 (This version should be safer and much faster than your current version) Regards, Monty