Responding to my own email... sheesh. It's just that kinda day. :
I found reference in the archives to what seems to be the same problem.
Monty replied to a thread entitled I got it hanged ! on 2001-07-17, and agreed that
it shouldn't be happening. Unfortunately, I can't find a solution in the archives.
I've had to shutdown mysqld. mysqladmin -p shutdown prevents the client from
connecting, but the process still shows up with ps -ef | grep mysql. I eventually had
to issue a kill -9 finally to remove it.
Think I'm gonna install 4.0, but I'm still interested in a solution to this problem.
Thanks all,
/Rob
At 15:05 -0500 2001/10/30, Robert Alexander wrote:
Hi all,
mysqld seems to 'hang' under certain circumstances when I'm doing a fairly large
ALTER TABLE -- adding or dropping an Index, repair etc. The server and client are
still 'alive' and I can do simple things like show processlist, or selecting a
count(0) from another table, but other selects or updates of other tables just sit
there forever in the process list.
mysqld's server usage goes up to over 99%, and the files for the table being ALTERed
(in the data directory) are no longer being updated -- the size, last modified time,
etc, do not change.
It seems that if I issue just the ALTER TABLE statement, and then don't try to do
ANYTHING else, it'll complete successfully (eventually), but if I issue ANY other
select/update statement on another table, the CPU goes up to 99% and everything just
stops.
I'm running MySQL v.3.23.36 binary on an UltraSparc 1 with Solaris 8 (patched to
2001/04 IIRC).
Any hints, ideas, suggestions? Any additional info I can provide?
Thanks much, everyone. I'll summarize.
Best,
/Rob
-
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