From: Ananda Kumar
Date: December 17 2010 6:31am
Subject: Re: Kill DELETE Query
List-Archive: http://lists.mysql.com/mysql/223814
Message-Id: <AANLkTi=kJjr-WdK0=Hn5iP4e3W6XX0BWNxxpM3cN-_DV@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=001485f89468de7ebc0497955189

--001485f89468de7ebc0497955189
Content-Type: text/plain; charset=ISO-8859-1

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=anandkl@stripped
>>
>>
>
>

--001485f89468de7ebc0497955189--