List:General Discussion« Previous MessageNext Message »
From:Ananda Kumar Date:December 17 2010 5:06am
Subject:Re: Kill DELETE Query
View as plain text  
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