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
> Thanks
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 wrote:
> Thanks for the reply. I used non stored procedure approach. Anoth
No...it will not.
On Fri, Dec 17, 2010 at 11:26 AM, Willy Mularto 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/
>
>
>
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
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 , 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, Wi
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/