Not the answer you need?
Register and ask your own question!

MySQL varaible innodb_file_per_table in production activate

hugchrichugchric EntrantInactive User Role Beginner
Hey Community,

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
chris
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.