Hi!
Sometimes after edit of long page I am getting the following error: "Lock wait timeout exceeded; try restarting transaction" and I can't use the wiki any more.
Thats not a deadlock! Thats lock wait timeout.
It happens when other connection acquires a lock, and doesn't release. Use 'SHOW PROCESSLIST' and see if you have any long-running or stale connections, then you can try figuring out where they come from.