MySQL Forums
Forum List  »  Performance

Re: Removing NOT NULL constraint takes a long time. Why?
Posted by: Rick James
Date: November 03, 2009 08:48PM

Why indeed.

Please note that newer versions (the "plugin"? 5.4?) do have better handling of ALTER TABLE in InnoDB. Older versions would rebuilt the table in virtually all cases.

What version do you have? Consider upgrading.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Removing NOT NULL constraint takes a long time. Why?
2425
November 03, 2009 08:48PM


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.