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

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 <pangj@arcor.de> 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 alsorelease 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/mysql?unsub=e...gen@gmail..com
>
>


--
Eric Bergen
eric.bergen@provenscaling.com
http://www.provenscaling.com