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
|