mysql挂起事务,事务暂停在MySQL中如何工作？

最新推荐文章于 2022-09-16 16:20:15 发布

贺志成Tallis.He

最新推荐文章于 2022-09-16 16:20:15 发布

阅读量233

点赞数

文章标签： mysql挂起事务

本文详细解释了Spring框架中PROPAGATION_REQUIRES_NEW事务传播级别的含义。当需要在一个已存在的事务中开启一个新的独立事务时，原来的事务将被挂起直至新的事务完成。这种机制采用扁平事务模型，便于实现且易于处理回滚操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

In the Spring Framework manual they state that for a PROPAGATION_REQUIRES_NEW the current transaction will be suspended.

What does that "suspended transaction"?

The timer for the timeout stops counting on the current transaction?

What are the actual implication of such suspension?

Thank you,

Asaf

解决方案

It doesn't mean anything special, a suspended transaction is just a transaction that is temporarily not used for inserts, updates, commit or rollback, because a new transaction should be created due to the specified propagation properties, and only one transaction can be active at the same time.

Basically there are two transaction models: the nested and flat model. In the nested model, if you start a transaction, and you need an other one, the first one remains active, that is, the second one will be nested inside its parent, and so on. On the other hand, in the flat model, the first transaction will be suspended, that is, we won't use it until the new one has been completed.

AFAIK the flat model is used almost exclusively (including Spring and the EJB spec as well), since it's much easier to implement: there is only one active transaction at any given time, so it's easy to decide what to do in case of a rollback, say, because of an exception. More importantly, the underlying database has to support it if you need the nested model, so the flat model is just the common denominator in this case.