Is it possible to disable keys in InnoDB tables?
If yes, how?
If not, why?
Server Fault is a question and answer site for system and network administrators. It only takes a minute to sign up.Sign up to join this community
I was under the impression InnoDB can have keys disabled and enabled. I just did some digging. It cannot be done. So, I was wrong.
Key constraints, however, can be turned on and off for a specific session:
SET unique_checks = 0;
SET foreign_key_checks = 0;