InnoDB should have file-per-table on by default
Bug #702571 reported by
Andrew Hutchings
This bug affects 2 people
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Drizzle |
Won't Fix
|
Wishlist
|
Monty Taylor | ||
7.0 |
Won't Fix
|
Wishlist
|
Monty Taylor |
Bug Description
Rackspace request.
MySQL 5.5 had it on right up until 5.5.7 and then turned it off due to this: http://
I don't think we will have the same problem
Related branches
lp:~mordred/drizzle/file-per-table
On hold
for merging
into
lp:~drizzle-trunk/drizzle/development
- Stewart Smith (community): Needs Fixing
- Drizzle Merge Team: Pending requested
-
Diff: 233 lines (+27/-40)7 files modifiedplugin/console/console.cc (+0/-13)
plugin/innobase/dict/dict0crea.c (+1/-1)
plugin/innobase/handler/ha_innodb.cc (+7/-7)
plugin/innobase/include/srv0srv.h (+3/-3)
plugin/innobase/os/os0file.c (+8/-8)
plugin/innobase/srv/srv0srv.c (+1/-1)
plugin/innobase/srv/srv0start.c (+7/-7)
lp:~mordred/drizzle/bug702571
Rejected
for merging
into
lp:drizzle/7.0
- Stewart Smith: Pending requested
-
Diff: 585 lines (+106/-102)13 files modifiedplugin/innobase/handler/ha_innodb.cc (+48/-50)
plugin/innobase/include/srv0srv.h (+1/-1)
plugin/innobase/include/trx0sys.h (+2/-2)
plugin/innobase/srv/srv0srv.cc (+1/-1)
plugin/innobase/srv/srv0start.cc (+10/-11)
plugin/innobase/tests/r/innodb-system-table-view.result (+9/-9)
plugin/innobase/tests/r/innodb_bug53591.result (+3/-3)
plugin/innobase/tests/r/innodb_cmpmem.result (+8/-8)
plugin/innobase/tests/r/innodb_cmpmem_reset.result (+8/-8)
plugin/innobase/tests/t/innodb-system-table-view.test (+1/-1)
plugin/innobase/tests/t/innodb_cmpmem.test (+1/-0)
plugin/innobase/tests/t/innodb_cmpmem_reset.test (+1/-0)
plugin/innobase/trx/trx0sys.cc (+13/-8)
Changed in drizzle: | |
assignee: | nobody → Monty Taylor (mordred) |
Changed in drizzle: | |
status: | In Progress → Won't Fix |
To post a comment you must log in.
Turns out - this option causes a 10-15% performance regression - so we're not really going to enable it by default.