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
- 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
- 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) |
Revision history for this message
| Monty Taylor (mordred) wrote | #1 |
| Changed in drizzle: | |
| status: | In Progress → Won't Fix |
Revision history for this message
| Tessa (unit3) wrote | #2 |
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.