MySQL Forums
Forum List  »  Performance

Re: DELETE performance problem
Posted by: Bradford Folkens
Date: January 30, 2005 04:46PM

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)...

Options: ReplyQuote

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