Bug #56923 make innodb_file_per_table=1 the default
Submitted: 22 Sep 2010 10:59
Reporter: Axel Schwenke Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: InnoDB storage engine Severity:S4 (Feature request)
Version:5.5.5 OS:Any
Assigned to: CPU Architecture:Any

[22 Sep 2010 10:59] Axel Schwenke
Beginning with MySQL-5.5.5 InnoDB will be the default engine for new tables. However innodb_file_per_table still defaults to off, though it must be turned on to get some of the InnoDB features (i.e. table compression or fast truncate).

How to repeat:

Suggested fix:
Make innodb_file_per_table=1 the default.
[22 Sep 2010 11:02] Kristian Köhntopp
German language article (mildly relevant, added for the benefit of Axel Schwenke)