Re: RHow To Reclaim Space After Huge Delete
Posted by:
Rick James
Date: September 11, 2014 06:01PM
This points out a use case for each of these:
innodb_file_per_table=1 -- You can do OPTIMIZE TABLE one at a time to return the space to the OS.
innodb_file_per_table=1, plus PARTITIONing on date - so that you can do DROP PARTITION instead if DELETE. The DROP will immediately return the space to the OS.
Subject
Written By
Posted
September 10, 2014 04:10AM
September 10, 2014 10:40AM
Re: RHow To Reclaim Space After Huge Delete
September 11, 2014 06:01PM
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.