List:General Discussion« Previous MessageNext Message »
From:Willy Mularto Date:December 17 2010 8:04am
Subject:Re: Kill DELETE Query
View as plain text  
Thanks for the confirmation.



sangprabv
sangprabv@stripped
http://www.petitiononline.com/froyo/


On Dec 17, 2010, at 1:31 PM, Ananda Kumar wrote:

> No...it will not.
> 
> On Fri, Dec 17, 2010 at 11:26 AM, Willy Mularto <sangprabv@stripped> wrote:
> Thanks for the reply. I used non stored procedure approach. Another question is if I
> kill the process will it crash the table? Thanks.
> 
> 
> 
> sangprabv
> sangprabv@stripped
> http://www.petitiononline.com/froyo/
> 
> 
> On Dec 17, 2010, at 12:06 PM, Ananda Kumar wrote:
> 
>> If u have used a stored proc to delete the rows, and commting freqently, then the
> kill will happen faster.
>> If you have just used "delete from table_name where <condition>, then it
> would take toot much time to rollback all the deleted but not commited rows.
>> 
>> Regards
>> anandkl
>> 
>> On Fri, Dec 17, 2010 at 8:37 AM, Willy Mularto <sangprabv@stripped>
> wrote:
>> Hi List,
>> I run a delete query to delete around 1 million rows in innodb table, It's been
> hours and still unfinish. Is it safe to kill that delete query process while the table is
> also inserting and updating other rows? Thanks.
>> 
>> 
>> 
>> 
>> sangprabv
>> sangprabv@stripped
>> http://www.petitiononline.com/froyo/
>> 
>> 
>> 
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>> 
>> 
> 
> 


Thread
Kill DELETE QueryWilly Mularto17 Dec
  • Re: Kill DELETE QueryAnanda Kumar17 Dec
    • Re: Kill DELETE QueryWilly Mularto17 Dec
      • Re: Kill DELETE QueryAnanda Kumar17 Dec
        • Re: Kill DELETE QueryWilly Mularto17 Dec
          • Re: Kill DELETE Query杨涛涛21 Dec