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.