I have a MySQL-Server 5.5 with around 5.000.000 records in each table.
Now i want to activate the variable “innodb_file_per_table = 1”.
The Reason is for activating the option, is to optimize performance.
For rebuild the tables to store each table in its own file i must execute the below statement.
Is that correct or any other steps are needed?
ALTER TABLE table_name ENGINE=InnoDB;
Thanks and Regards