Re: DELETE performance problem
I wish it were only that easy... Unfortunately the table in question is relatively high-availability - and I can't spare a drop, create, and then rename.
I've begun to play with removing columns in the unique index, and the time it takes to delete has dropped from 24 hours+ (finally canceled) to 10 hours.... So I wonder if there is a specific problem with the unique index?
I probably don't have a full understanding of how a 2-table DELETE works (with indexes, etc). But after watching the SHOW INNODB STATUS for a while - it still seems odd to me that it would do 1 delete every 2-3 seconds and read *so* many records in the meantime (this was really the only query on the box)...
Subject
Views
Written By
Posted
3150
January 29, 2005 07:36PM
1847
January 29, 2005 08:30PM
Re: DELETE performance problem
1949
January 30, 2005 04:46PM
2104
January 31, 2005 08:45AM
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.