>>>>> "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