Примеры использования Isolation level на Английском языке и их переводы на Русский язык
{-}
-
Official
-
Colloquial
Transaction Isolation Levels.
Isolation level of automatic transaction.
Transaction isolation levels;
Isolation levels are set through OleDbConnection.
Parameters for SERIALIZABLE isolation level.
The support for isolation level CHAOS was removed.
IBProvider supports three transaction isolation levels.
If the transaction isolation level not set then ADO.
By default«auto_commit_level» determines SNAPSHOT isolation level.
You may specify other isolation level using the command.
The isolation level of inner transaction defines by auto_commit_level.
Auto_commit_level- Defines isolation level for automatic transactions.
The isolation level READ_COMMITTED_NO_VERSION is setted by default.
In consistent reads, there is an important difference from the READ COMMITTED isolation level.
Isolation level of separate transaction with database modification.
On default, a distributed transaction will have the isolation level READ COMMITTED.
Isolation level of separate transaction for re-reading of rowset data.
The first variant, without parameters,creates a transaction with ReadCommitted isolation level.
The isolation level of inner transaction defines by Autocommit Isolation Levels. .
The second variant of this method allows to specify the isolation level of the new transaction.
Automatic transaction isolation level is defined by initialization property«auto_commit_level».
Consistent read is the default mode in which InnoDB processes SELECT statements in READ COMMITTED andREPEATABLE READ isolation levels.
Auto_commit_ddl_level- Defines isolation level of automatic transactions for DDL queries.
The isolation level of an automatic transaction is defined in the initialization property«auto_commit_level».
In terms of the SQL: 1992 transaction isolation levels, the InnoDB default is REPEATABLE READ.
Isolation level of automatic transaction is defined by the property of the connection string«auto_commit_level».
Focus your attention,that after connection you can change isolation level through«Autocommit Isolation Levels» property.
The isolation level of auto-transactions can be defined as«auto_commit_level» parameter in connection string or if connection was made already by«Autocommit IsolationLevels» session parameter.
Basically, transaction isolation level defines data visibility area among simultaneously executing transactions.
In this isolation level, a lock-based concurrency control DBMS implementation keeps write locks(acquired on selected data) until the end of the transaction, butread locks are released as soon as the SELECT operation is performed so the non-repeatable reads phenomenon can occur in this isolation level.