From: Ananda Kumar Date: December 17 2010 5:06am Subject: Re: Kill DELETE Query List-Archive: http://lists.mysql.com/mysql/223812 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=0016e65b5eb8e461ea04979423fe --0016e65b5eb8e461ea04979423fe Content-Type: text/plain; charset=ISO-8859-1 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, Willy Mularto 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=anandkl@stripped > > --0016e65b5eb8e461ea04979423fe--