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:
None 
Category:MySQL Server: InnoDB storage engine Severity:S4 (Feature request)
Version:5.5.5 OS:Any
Assigned to: CPU Architecture:Any
Triage: Needs Triage: D5 (Feature request)

[22 Sep 2010 10:59] Axel Schwenke
Description:
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:
n/a

Suggested fix:
Make innodb_file_per_table=1 the default.
[22 Sep 2010 11:02] Kristian Köhntopp
http://blog.koehntopp.de/archives/2956-MySQL-5.5-Default-Table-Type-InnoDB.html
German language article (mildly relevant, added for the benefit of Axel Schwenke)