MySQL locking is independent from the storage engine. It is deadlock free as we lock all tables that we plan to work with in a single lock statement. Only the locked tables can be used until the lock is released.
MySQL knows, which tables will be used throughout the command and locks all in a single go. At the end of the command the lock is released.
-- This message may have been cut off and the rest will only be shown to members. To become a member, click here --