how to disable keys in mysql innodb

Question

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

Answer 1

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;