开发者

3 way transaction deadlock in mysql innodb?

开发者 https://www.devze.com 2023-01-22 16:23 出处:网络
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\" ?

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

精彩评论

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