如何解决和调试MySQL错误：ER_LOCK_WAIT_TIMEOUT：超出锁定等待超时;尝试重新启动事务

I've read a few posts here on this, but still do not understand how can I resolve the error. Also how do I decipher I've read a few posts here on this, but still d