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?


Thanks and Regards
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.