本文探讨了InnoDB存储引擎中事务回滚的三种情况：表空间满导致的回滚、死锁引起的回滚以及锁等待超时时的回滚策略。特别介绍了如何通过innodb-rollback-on-timeout参数来控制超时回滚行为。
错误处理
1.如果表空间满了，innodb会回滚整个事务
If you run out of file space in a tablespace, a MySQL Table is full error occurs and InnoDB rolls back the SQL statement.
2.死锁会导致innod回滚整个事务
A transaction deadlock causes InnoDB to roll back the entire transaction
3.锁等待超时会导致innodb只回滚超时的那条sql，如果想回滚整个事务，可以启用innodb-rollback-on-timeout参数，如果启用该参数，重试也会重试整个事务
A lock wait timeout causes InnoDB to roll back only the single statement that was waiting for the lock and encountered the timeout.
To have the entire transaction roll back, start the server with the --innodb-rollback-on-timeout option.
Retry the statement if using the current behavior, or the entire transaction if using --innodb-rollback-on-timeout.
扫一扫
2558
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
