Disable innodb_file_per_table

axinos

Member
Sep 30, 2006
5
0
151
cPanel Access Level
Root Administrator
Hello,

I have 24GB RAM i7 dedicated server, running CPanel 11.36 with MySQL 5.1.68. In config file I have innodb_file_per_table enabled. Is it safe to just disable the option, not doing any damage to databases at the same time after MySQL restarts?

Thanks.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,228
463
Hello :)

Per MySQL documentation:

If you remove the innodb_file_per_table line from my.cnf and restart the server, InnoDB creates tables inside the shared tablespace files again.

This is documented at:

MySQL 5.1 - Innodb Multiple Tablespaces

Thank you.