Re: [Maria-developers] How MySQL/MariaDB handles aborted DDL

2010-07-07 Thread Arjen Lentz
Hi Philip On 07/07/2010, at 5:21 PM, Philip Stoev wrote: What do you mean by "can be tricky and more often than not causes hassles", "Crashed" and inaccessible tables. and in general, what is the semantics of a DDL KILL operation? For example, are you allowed to leave temporary files and i

Re: [Maria-developers] How MySQL/MariaDB handles aborted DDL

2010-07-07 Thread Philip Stoev
Arjen, What do you mean by "can be tricky and more often than not causes hassles", and in general, what is the semantics of a DDL KILL operation? For example, are you allowed to leave temporary files and if not, who is responsible for cleaning them up -- the engine or the server? I am afraid

[Maria-developers] How MySQL/MariaDB handles aborted DDL

2010-07-06 Thread Arjen Lentz
Hi Philip, all Philip's bug on recovery from a kill -9 during DML reminded me... from my experience, aborting a DDL query (ALTER TABLE - things like adding an index usually) can be tricky and more often than not causes hassles. By abort in this case I mean killing the connection/thread that d