Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

how to disable keys in mysql innodb? or is this not possible? why?

share|improve this question

1 Answer 1

up vote 2 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

Your Answer

 
discard

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.