mySQL 4.0.22 hangs
 

Hi,

I'm using Wordpress 1.2.1 with mySQL 4.0.22 on a Debian testing system. (Nothing weird installed, it's a very new system.)

When I start mySQL up the system works fine, delivering the web-page. However, after about an hour or five, the mySQL daemon "hangs".

I can (for now) still get in with the mySQL monitor, but it no longer accepts network (port 3306) connections. If I telnet to localhost 3306, I get nothing at all (i.e. the connection is open, but mySQL is not sending any information back.)

If I look on the mySQL monitor, I can see throgh "show processlist;" that another process has been started. (User: unautheniticated, status login, time null, etc.)

At this point, if I try "/etc/init.d/mysql restart" it hangs.

Now, if we wait, and wait and wait, then eventually mySQL will get too many connections, and I can use "/etc/init.d/mysql restart" to get it going again (although all it does this time is fail to get in and kill the threads with a -9 I guess).

So, now the database has been reset and will continue for another 1 to 5 hours.

I'm tearing my hair out! I've looked through syslog and I can't see it barfing on any queries. Help me please.

Thank you,

Robert

bump