Menu
Does someone knows a good book where transaction isolation levels are explained with a lot of examples and advices in what case what isolation level to use?
647
Transaction isolation levels are a measure of the extent to which transaction isolation succeeds. In particular, transaction isolation levels are defined by the presence or absence of the following phenomena: Dirty Reads A dirty read occurs when a transaction reads data that has not yet been committed.
InnoDB offers all four transaction isolation levels described by the SQL:1992 standard: READ UNCOMMITTED , READ COMMITTED , REPEATABLE READ , and SERIALIZABLE .
In database systems, isolation determines how transaction integrity is visible to other users and systems. A lower isolation level increases the ability of many users to access the same data at the same time, but increases the number of concurrency effects (such as dirty reads or lost updates) users might encounter.
The SERIALIZABLE isolation level provides the most risk of blocking, but the lowest risk of lost data.
You really need a book? There's some info on wiki: http://en.wikipedia.org/wiki/Isolation_(database_systems)#, but I think also Oracle documentation should be very helpful: http://download.oracle.com/docs/cd/B14117_01/server.101/b10743/consist.htm It's conceptually quite simple (tho technically quite complex).
Hope that helps!
102
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
