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
