Deadlock found when trying to get lock; try restarting transaction
近遇到一个MYSQL update语句出现Deadlock found when trying to get lock的问题,分析一下原因。什么情况下会出现Deadlock found when trying to get lock?https://dev.mysql.com/doc/refman/5.6/en/innodb-deadlocks.html出现死锁需要2个条件:1)至少2个client(A,B)同时在执行事务2)clientA锁定了某一行,未提交事务,此时clientB也需要upda
原创
2020-08-31 16:12:30 ·
2950 阅读 ·
0 评论