Tag - ibdata

How to reclaim space in InnoDB when innodb_file_per_table is ON

reclaim space in InnoDB

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 some data then there is no other way to reclaim that unused disk space except dump/reload method.
When Innodb_file_per_table is ON, each table stores data and indexes in its own tablespace file. However, […]

Read more