--innodb-optimize-keys should ignore foreign keys

Bug #859078 reported by Alexey Kopytov on 2011-09-25
6
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-optimize-keys should ignore foreign key constrains. Documentation for innodb_expand_fast_index_creation.patch should be changed to reflect that.

Related branches

description: updated

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2689

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers