Jeff, CTRL-Z in linux doesn't hang up mysql, it suspends it. mysqld releases the locks because the connection was broken when you issue 'exit'. When using ctrl-z the client process still exists and it's connections still exist so the locks won't be released. To bring a process out of suspension type 'fg' it will move back to the foreground. CTRL-D is typically the exit shortcut.
On 7/16/07, Jeff Pang <[EMAIL PROTECTED]> wrote:
hello, When saying 'exit' in mysql shell,mysqld would release the lock which was made before. But if I do 'ctrl+z' under linux to hang up mysql shell,would mysqld also release the lock or not? Thank you. Viel oder wenig? Schnell oder langsam? Unbegrenzt surfen + telefonieren ohne Zeit- und Volumenbegrenzung? DAS TOP ANGEBOT JETZT bei Arcor: günstig und schnell mit DSL - das All-Inclusive-Paket für clevere Doppel-Sparer, nur 39,85 € inkl. DSL- und ISDN-Grundgebühr! http://www.arcor.de/rd/emf-dsl-2 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- Eric Bergen [EMAIL PROTECTED] http://www.provenscaling.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]