MySQL Forums
Forum List  »  InnoDB

Re: deleting data from large fragmented InnoDB table
Posted by: Rick James
Date: March 08, 2014 12:14PM

Good.

Now, if you do DROP PARTITION and recreate it -- instead of using DELETE, the deletions will be very efficient, and won't lead to fragmentation.
Also necessary is innodb_file_per_table=ON.

Options: ReplyQuote




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.