死锁后在 MySQL 中重新启动事务 [英] Restarting transaction in MySQL after deadlock

问题描述

我的 MySQL 遇到了死锁.如何配置 MySQL 在遇到死锁时自动重启事务?

I am facing a deadlock in my MySQL. How can I configure MySQL to restart the transaction automatically when it encounters a deadlock?

推荐答案

您无法自动执行此操作，因为发生了死锁，因为两个事务正在尝试修改相同的数据.如果您知道简单地再次重试相同的语句是正确的做法，那么您需要在您的应用程序中实现这一点.

You cannot do that automatically, as the deadlock occurred, because two transactions were trying to modify the same data. If you know that simply retrying the same statements again will be the right thing to do, you need to implement this in your application.

但是，让数据库自动执行此操作是不负责任的，因为在某些情况下，您的应用程序可能首先需要查看数据库中的新情况，然后再发出可能已修改的语句(如果有的话).

However having the database do that automatically would be irresponsible, because there might just as well be cases where your application first needs to take a look at the new situation in the database, before issuing potentially modified statements, if any at all.

这篇关于死锁后在 MySQL 中重新启动事务的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！