Is it possible to disable keys in InnoDB tables?

If yes, how?

If not, why?


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;

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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