Hi,
After some research I found 'SHOW ENGINE INNODB STATUS' is supposed to show the latest deadlock if it happens, however no deadlocks were shown on my result. And I think a deadlock would timeout after 50 second by default, set by the 'innodb_lock_wait_timeout' variable, so no reason for my...