Thanks for the reply. I used non stored procedure approach. Another question is if I kill
the process will it crash the table? Thanks.
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.
> 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.
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1