how to disable keys in mysql innodb? or is this not possible? 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: