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

Create foreign key with minimal locking

EganEgan EntrantCurrent User Role Novice
I'm new to this forum. My company uses Percona in a MySQL 5.7 environment. Is there a way to create a foreign key without locking the underlying tables for a long time? Alternatively, is there a way to disable an fk, drop an index, recreate an index, then re-enable the fk without ever dropping it, without locking the underlying tables for a long time? Of course, the index is on the same column as the fk column.
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.