Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is it possible to disable keys in InnoDB tables?

If yes, how?

If not, why?

share|improve this question
up vote 4 down vote accepted

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:

  • If you have UNIQUE secondary indexes, you can try setting this to speed up INSERTs that are disk bound: SET unique_checks = 0;
  • To disable foreign key checks for a suggestion, use Randy Melder's suggestion: SET foreign_key_checks = 0;
share|improve this answer
As for the "why", see – Pacerier Feb 24 '15 at 4:06

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.