Kill DELETE Query

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@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=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Kill DELETE Query

--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@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=anandkl@gmail.com
>
>

--0016e65b5eb8e461ea04979423fe--

Re: Kill DELETE Query

--Apple-Mail-6-725580218
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
charset=us-ascii

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
sangprabv@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 , then =
it would take toot much time to rollback all the deleted but not =
commited rows.
>=20
> Regards
> anandkl
>=20
> 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.
>=20
>=20
>=20
>=20
> sangprabv
> sangprabv@gmail.com
> http://www.petitiononline.com/froyo/
>=20
>=20
>=20
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: =
http://lists.mysql.com/mysql?unsub=3Danandkl@gmail.com
>=20
>=20


--Apple-Mail-6-725580218--

Re: Kill DELETE Query

--001485f89468de7ebc0497955189
Content-Type: text/plain; charset=ISO-8859-1

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
> sangprabv@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 , 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@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=anandkl@gmail.com
>>
>>
>
>

--001485f89468de7ebc0497955189--

Re: Kill DELETE Query

--Apple-Mail-7-733248461
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
charset=us-ascii

Thanks for the confirmation.



sangprabv
sangprabv@gmail.com
http://www.petitiononline.com/froyo/


On Dec 17, 2010, at 1:31 PM, Ananda Kumar wrote:

> No...it will not.
>=20
> 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.
>=20
>=20
>=20
> sangprabv
> sangprabv@gmail.com
> http://www.petitiononline.com/froyo/
>=20
>=20
> On Dec 17, 2010, at 12:06 PM, Ananda Kumar wrote:
>=20
>> 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.
>>=20
>> Regards
>> anandkl
>>=20
>> 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.
>>=20
>>=20
>>=20
>>=20
>> sangprabv
>> sangprabv@gmail.com
>> http://www.petitiononline.com/froyo/
>>=20
>>=20
>>=20
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: =
http://lists.mysql.com/mysql?unsub=3Danandkl@gmail.com
>>=20
>>=20
>=20
>=20


--Apple-Mail-7-733248461--

Re: Kill DELETE Query

--20cf3043430000e4270497e87c75
Content-Type: text/plain; charset=UTF-8

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 for the confirmation.
>
>
>
> sangprabv
> sangprabv@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. Another
> question is if I kill the process will it crash the table? Thanks.
> >
> >
> >
> > sangprabv
> > sangprabv@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 , 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@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=anandkl@gmail.com
> >>
> >>
> >
> >
>
>

--20cf3043430000e4270497e87c75--