Doubly bad to reply twice to your own posts.... I have more info though..... my startup script has max_connections=1000, and I cannot log in as the superuser as mentioned here http://www.mysql.com/doc/en/Too_many_connections.html
----- Original Message ----- From: "Gary Huntress" <[EMAIL PROTECTED]> To: "Gary Huntress" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, November 11, 2002 1:31 PM Subject: Re: At Wits End With Unstable Unusable Server > Bad form to reply to ones own post....but I should have emphasized my major > symptom: > > I cannot stop the server, "mysqladmin -pxxxxxxx shutdown" never returns. > > This is in addition to the "too many connections" and "forcing close of > threads" errors > > > > ----- Original Message ----- > From: "Gary Huntress" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, November 11, 2002 1:21 PM > Subject: At Wits End With Unstable Unusable Server > > > > As I mentioned in a previous post, I have been using 3.23 for a very long > > time with no problems whatsoever. About 1 month ago I began to have > > stability problems, unable to connect, unable to shut down....hundreds and > > hundreds of myslq processes > > > > At first I thought this was a particular user, so I rebooted my server and > > started with clean logs....it hung again within minutes, so I grepped the > > log to get the names of every DB that was opened in that brief time and I > > took them all offline and restarted again.....lo and behold the server > hung > > again, so I concluded that it was not due to one users out of control > query. > > > > I then upgraded to the current release of 3.23 (installed by rpm) and I > was > > happy that it appeared to fix the problem...the server was stable and > > accessible for all users. However, approximately 1 week later, I am > seeing > > the exact same problem again and I don't know how to troubleshoot this! > > > > The platform is linux running 2.2.16 and is otherwise stable, there is > > plenty of disk and mem so its not resources. Mysqladmin -p shutdown > never > > returns and the only way to restart is to reboot. > > I have many " Forcing close of thread " in my error log. > > > > Please help! > > > > > > Regards, > > Gary "SuperID" Huntress > > ======================================================= > > FreeSQL.org offering free database hosting to developers > > Visit http://www.freesql.org > > > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
