Re: stopping drop index command on table

[Gleb Paharenko]

Hello.

According to the:
  http://dev.mysql.com/doc/mysql/en/kill.html

"During ALTER TABLE, the kill flag is checked before each block of rows
are read from the original table. If the kill flag was set, the
statement is aborted and the temporary table is deleted."

So, in my opinion, nothing bad will happen.


Clyde Lewis <cllewis@stripped> wrote:
> What are the consequences of cancelling(stopping) the drop index on 
> table command if any at all?
> The process is running on a 9GB table and need to stop the process (dev 
> environment).
> 
> Thanks in advance.
> 


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   Gleb.Paharenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com