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 <sangpr...@gmail.com> > Thanks for the confirmation. > > > > sangprabv > sangpr...@gmail.com > 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 <sangpr...@gmail.com> > 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 > > sangpr...@gmail.com > > 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 <sangpr...@gmail.com> > 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 > >> sangpr...@gmail.com > >> 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=anan...@gmail.com > >> > >> > > > > > >
