It turns out that cascading FK processing does some unnecessary FK checks, which are needed only for the purpose of getting FK parent reference for child table modifications. These can be optimized away, will continue on this part before closing this issue.
Pushed fix in revision: http:// bazaar. launchpad. net/~codership/ codership- mysql/5. 5-23/revision/ 3872
It turns out that cascading FK processing does some unnecessary FK checks, which are needed only for the purpose of getting FK parent reference for child table modifications. These can be optimized away, will continue on this part before closing this issue.