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.
Subject
Views
Written By
Posted
2422
February 25, 2014 04:35AM
1138
February 27, 2014 12:20AM
1208
February 27, 2014 02:26AM
938
March 01, 2014 11:06AM
1095
March 03, 2014 03:19AM
1359
March 05, 2014 05:10PM
931
March 06, 2014 03:05AM
752
March 06, 2014 11:19PM
932
March 07, 2014 04:03AM
Re: deleting data from large fragmented InnoDB table
917
March 08, 2014 12:14PM
837
March 11, 2014 02:36AM
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.