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
