当InnoDB存储引擎检测到死锁时，它会选择一个受影响的事务进行回滚，以打破死锁状态，而另一个事务则被允许继续执行。这种策略避免了长时间的等待，确保了数据库操作的效率。
How does the InnoDB storage engine handle deadlocks when they are detected?
A. Both the affected transactions will be rolled back.
B. The affected transactions wait for innodb_lock_wait_timeout seconds, and then roll back.
C. One of the affected transactions will be rolled back, the other is allowed to proceed.
D. The transaction isolation level determines which transaction is rolled back.
E. The innodb_locks_unsafe_for_binlog setting determines which transaction is rolled back.
Answer: C
问：当检测到死锁时，InnoDB存储引擎如何处理它们？
答：一个受影响的事务将回滚，另一个允许继续。
扫一扫
2392
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
