Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space ML1 and version 9.1


Transaction Lifespan
xidTransaction start id. Marks the logical beginning of the transaction.
iidInvocation id. Marks the beginning of a statement within a transaction.

Commit id. Marks the id at which transaction changes are visible to other transactions.

The following table describes MVCC visibility rules in different isolation levels. Note that ClustrixDB does not support the read uncommitted level.

Isolation Levels


ClustrixDB implements row level locks for transactions which touch a few rows at a time (a runtime configurable variable). For statements which affect a signification significant portion of a table, the query optimizer will promote row level locks to a table lock.