Sure, open up a new MySQL session, and use "SHOW PROCESSLIST;" to monitor the query status. It should report what it's doing and how long the process has been running.
Chris Schreiber -----Original Message----- From: Karl Stubsjoen [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 8:38 PM To: [EMAIL PROTECTED] Subject: Hang??? Hello, How can I tell if a process is "hanging"? I am performing a large (fairly) insert from one table to another (insert into... select from) I have been looking at a non-MySQL prompt for 20 minutes or more (non, meaning: after you execute a command you are between prompts for awhile until the command is finished, at that time you get a prompt again). Thanks! Karl www.excelbus.com/info-m ..opportunity knocking.. --------------------------------------------------------------------- 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
