Everyone, I experienced table deadlock on my MySQL server...my client program does a Table Write lock before writing to it...but suddenly the computer hangs-up...do, other client got stuck and waiting for the table to be free for writing... But as I know...only the thread who does locking can do the unlocking....is there a hard way to unlock the table?...an admin way...what I did...is just shut the server down and resume...can mysqladmin do it a simple way?
R.B.Roa Traffic Management Engineer PhilCom Corporation Tel.No. (088) 858-1028 Mobile No. (0919) 30856267 --------------------------------------------------------------------- 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