I did some testing, and I wasn't able to reproduce described deadlock on mysql. My guess is, that mysql use different locking strategy than oracle.