Percona Server with XtraDB

--innodb-optimize-keys should ignore foreign keys

Reported by Alexey Kopytov on 2011-09-25
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server
Undecided
Alexey Kopytov
5.1
Undecided
Alexey Kopytov
5.5
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.

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

Other bug subscribers