开发者

3 way transaction deadlock in mysql innodb?

If innodb detects a 3 way deadlock, would it report on all the involved transactions in the "LAST DEADLOCK DETECTED" section of "show engine innodb status" ? Also when innodb reports a deadlock, why doesn't it ever report the locks TRANSACTION (1开发者_JAVA技巧) holds? It reports locks TRANSACTION (1) is waiting for, It reports locks TRANSACTION (2) is holding, It reports locks TRANSACTION (2) is waiting for. Why not that one?

Thanks, Vivek

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜