--innodb-optimize-keys should ignore foreign keys
Bug #859078 reported by
Alexey Kopytov
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
Undecided
|
Alexey Kopytov | ||
| 5.1 |
Fix Released
|
Undecided
|
Alexey Kopytov | ||
| 5.5 |
Fix Released
|
Undecided
|
Alexey Kopytov | ||
Bug Description
InnoDB requires a full table rebuild for foreign key changes. So it doesn't make sense to delay their creation by moving them from CREATE TABLE to a separate ALTER TABLE in a mysqldump output.
So --innodb-
Related branches
lp:~akopytov/percona-server/bug859078-5.1
- Laurynas Biveinis (community): Approve
-
Diff: 252 lines (+123/-16)1 file modifiedpatches/innodb_expand_fast_index_creation.patch (+123/-16)
lp:~akopytov/percona-server/bug859078-5.5
- Stewart Smith (community): Approve
- Laurynas Biveinis (community): Approve
-
Diff: 251 lines (+123/-15)1 file modifiedpatches/innodb_expand_fast_index_creation.patch (+123/-15)
| description: | updated |
Revision history for this message
| Shahriyar Rzayev (rzayev-sehriyar) wrote | #1 |
To post a comment you must log in.
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/