Re: stopping drop index command on table

2005-08-31 Thread 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 [EMAIL PROTECTED] 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
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   ___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



stopping drop index command on table

2005-08-30 Thread Clyde Lewis
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.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]