--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 |
To post a comment you must log in.
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/ /jira.percona. com/browse/ PS-2689