MySQL Forums
Forum List  »  InnoDB

Delete Query Taking Too Much Resources
Posted by: Vipin Kumar R Jaiswar
Date: September 21, 2012 01:13AM

Hi Team,
one day in every week i am running one script which is deleting the data from database base.
1) IN the table there always more then 3m of record
2) Delete query delete 25000 rows at a time.
3) database base is INNODB.
4) Delete query where caluse column name is have key to make this process fast.
(I have tested with removing the key as well)

IN first 2 (in 2 weeks) execution went smoothly with out any server load and issue. now days same script taking lots of time where

1) Data weight is not change
2) No other services asking for same table or mysql request in that duration.
3) No hardware changes.

I really want your helps in that. Can any one tell me how to optimize the process more on the query level.

Jaiswar Vipin Kumar R

Options: ReplyQuote

Written By
Delete Query Taking Too Much Resources
September 21, 2012 01:13AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.