Does changing a UNIQUE KEY lock the table?
Hi,
I have a large table with about 4 million rows in it. Usually ALTER TABLE operations take a significant amount of time and lock the table during the process (understandably so).
We need to remove a UNIQUE KEY that we currently have on this table and add a new UNIQUE KEY to replace it.
I have taken a look at the MySQL documentation for ALTER TABLE but I cannot see much mentioned about table locks for UNIQUE KEY. Will this operation cause a table lock?
Kind regards
Subject
Views
Written By
Posted
Does changing a UNIQUE KEY lock the table?
1566
July 03, 2014 06:46PM
753
July 05, 2014 12:25PM
764
July 06, 2014 07:21PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.