Tag - ibdata

How to reclaim space in InnoDB when innodb_file_per_table is ON

reclaim space in InnoDB

Editor’s Note:  This post was written for MySQL 5.1/5.5 and that the default for innodb_file_per_table was turned ON in 5.6 and the behaviors/process noted below may not be necessary for someone running 5.6/5.7.
When innodb_file_per_table is OFF and all data is going to be stored in ibdata files. If you drop some tables and delete […]

Read more