Delete Query Taking Too Much Resources
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.
Thanks
Jaiswar Vipin Kumar R
Subject
Views
Written By
Posted
Delete Query Taking Too Much Resources
1691
September 21, 2012 01:13AM
665
September 21, 2012 05:20AM
975
September 23, 2012 10:44PM
968
September 24, 2012 12:31AM
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.