Re: mysqld process hangs, cannot terminate

2005-02-08 Thread Jason Martin
On Tue, Feb 08, 2005 at 03:57:16PM -0600, Brian Erickson wrote: > stops working) and continues to run. Nothing we do will terminate that > process (we have > tried: kill , kill -s 9 , everything that is supposed to > forcibly kill the process and nothing works). A unkillable process like that is us

mysqld process hangs, cannot terminate

2005-02-08 Thread Brian Erickson
Hello everyone, we are having a problem on our server with the mysqld process hanging. We first notice the problem because our max connections is reached. A "show processlist" query shows 250 queries with a status of "locked." When we try to issue the command: mysqladmin -u root -p shutdown, it do