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 >> >> > >
