MySQL Forums
Forum List  »  InnoDB

Does changing a UNIQUE KEY lock the table?
Posted by: Michael Nixon
Date: July 03, 2014 06:46PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Does changing a UNIQUE KEY lock the table?
1566
July 03, 2014 06:46PM


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.