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
3135
January 29, 2005 07:36PM
1843
January 29, 2005 08:30PM
Re: DELETE performance problem
1941
January 30, 2005 04:46PM
2094
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.