Disable innodb_file_per_table

A

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

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,258
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.
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
M Any repercussions if disable Force short prefix for MySQL? Databases 2
S How to disable way of interactive password specification when login to mysql database in command line Databases 3
imorandin Disable "status" button in PHPMyAdmin Databases 3
U SOLVED should i disable strict mode? Databases 3
B want to disable "only_full_group_by"? Databases 1
Similar threads
Any repercussions if disable Force short prefix for MySQL?
How to disable way of interactive password specification when login to mysql database in command line
Disable "status" button in PHPMyAdmin
SOLVED should i disable strict mode?
want to disable "only_full_group_by"?
Top Bottom