Not the answer you need?
Register and ask your own question!

Adding foreign key on a huge table takes time

tbmvenkattbmvenkat EntrantCurrent User Role Beginner
We are using percona server 5.5. We are migrating tables from one schema into another. There are certain modifications done to the tables in target schema and is not a one to one direct movement. We are adding records into the target tables and then the constraints are created. The tables I am talking about are housing a max of half a million records. The foreign key creation is taking a lot of time. Would help if I can get a few optimization options. Thanks.



  • tbmvenkattbmvenkat Entrant Current User Role Beginner
    Would appreciate if I can get any viewpoints around this. Thanks.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.