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
2456
February 25, 2014 04:35AM
1158
February 27, 2014 12:20AM
1225
February 27, 2014 02:26AM
951
March 01, 2014 11:06AM
1110
March 03, 2014 03:19AM
1379
March 05, 2014 05:10PM
942
March 06, 2014 03:05AM
767
March 06, 2014 11:19PM
949
March 07, 2014 04:03AM
Re: deleting data from large fragmented InnoDB table
936
March 08, 2014 12:14PM
851
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.