MySQL Bugs: #56923: make innodb_file_per

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

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

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.

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)