Hannes Niedner writes:
> Hi Folks,
>
> I just started a create table ... select from ...left-join query from my
> laptop. It seems to take a while?
> What happens if disconnect my client from the mysql daemon running on
> another machine. Will the interupted mysqld-client crosstalk abrupt the
> query, or will it continue to run on the server and die when it needs to
> report back to the client, or will it even finish the job without the client
> listening (the one that started the job in the first place).
> This also raises the question for some kind of progress status bar etc.. All
> I can do now is to monitor the processlist with mysqladmin which doesn' give
> me any clue how long I still have to wait.
>
> Comments appreciated
>
> Hannes
>
Hi!
First of all, it is unlikely that you will see some status bar as
operations in RDBMS server are quite complicated and time table can
not be predicted except in some extremely simple cases.
Regarding aborting a client, server operation will continue until OS
on which server runs reports to server that a thread is killed. Then
it depends on the stage in which the operation is when will it stop
and when will cleanup operation be executed. In some cases , like in
multi-table delete (MySQL 4.0) delete will finish even if a thread is
killed. This is due to the entity integrity rules.
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
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
