List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:March 26 1999 1:20am
Subject:mysql leaves a single process that hangs connections
View as plain text  
>>>>> "Zach" == Zach Beane <xach@stripped> 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.

<cut>

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
Thread
mysql leaves a single process that hangs connectionsZach Beane25 Mar
  • mysql leaves a single process that hangs connectionsMichael Widenius26 Mar