List:General Discussion« Previous MessageNext Message »
From:杨涛涛 Date:December 21 2010 9:44am
Subject:Re: Kill DELETE Query
View as plain text  
Yeah. The "Delete from tablename " will remove the record one by one.  So
you can cancel it whenever you don't need to continue.

David Yeung, In China, Beijing.
My First Blog:http://yueliangdao0608.cublog.cn
My Second Blog:http://yueliangdao0608.blog.51cto.com


2010/12/17 Willy Mularto <sangprabv@stripped>

> 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