Tuesday 24 January 2017

Converting ibdata to .ibd files per table

First enabling innodb_file_per_table and then when we optimize the tables, we can see that it creates .ibd files per table. Optimize table drops and recreates table so new .ibd files are created. Below are the steps:

Mysql> set global innodb_file_per_table=1;
Mysql> optimize table table_name;

No comments:

Post a Comment