脏读:A 1检索a 2未提交的数据。
不过,让其事务看到未提交的数据可以带来意料之外的副作用,如更新冲突和读取不一致等。
Letting uncommitted data be seen by other transactions, however, can result in unexpected side effects, such as clashing updates and inconsistent reads.
未做任何修改地关闭数据库(将所有提交的数据写到磁盘)。
The database was cleanly shut down (All the committed data are written to disks).
将分割镜像初始化为快照时,将执行崩溃恢复,回滚所有未提交的事务,并使数据库可以被所有读或写操作访问。
The initialization of the split mirror as snapshot performs a crash recovery, rolls back all uncommitted transactions, and makes the database available for any read or write operation.
发生COMMIT时,所有未提交的语句(自最近一次COMMIT之后的所有语句)将同时生效,确保数据的完整性。
On a commit, all the uncommitted statements (statements after last commit) take effect together, ensuring data integrity.
例如,如果一个成员正在更新一行数据,那么另一个成员就不能以未提交读(uncommitted read)以外的任何隔离级别读取这一行。
For example, if one member is updating a row, it would not be proper for another member to read the row with any other isolation level than uncommitted read.
在前一主体上,客户端断开了与数据库的连接,并且未提交的事务将回滚。
On the former principal, clients are disconnected from the database and in-flight transactions are rolled back.
事务隔离:当前事务和其它事务的隔离的程度。例如,这个事务能否看到其他事务未提交的写数据?
Isolation: the degree of isolation this transaction has from the work of other transactions. For example, can this transaction see uncommitted writes from other transactions?
事务隔离:当前事务和其它事务的隔离的程度。例如,这个事务能否看到其他事务未提交的写数据?
Isolation: the degree of isolation this transaction has from the work of other transactions. For example, can this transaction see uncommitted writes from other transactions?
应用推荐