[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sapdb-general
Subject:    AW: Isolation level 20 or 30
From:       "Zabach, Elke" <elke.zabach () sap ! com>
Date:       2004-08-05 7:12:52
Message-ID: 235EE6AC8AE9264CBF763FC6749E270105F6FC () dewdfe22 ! wdf ! sap ! corp
[Download RAW message or body]



> -----Ursprüngliche Nachricht-----
> Von: Arash Bijanzadeh [mailto:a.bijanzadeh@linuxiran.org]
> Gesendet: Donnerstag, 5. August 2004 08:46
> An: maxdb@lists.mysql.com
> Betreff: Isolation level 20 or 30
> 
> Hi all,
> I couldn't get what is the difference between isolation level 20 an
> isolation
> level 30?
> --

As you will find in the reference manual --> transactions --> isolation level
http://dev.mysql.com/doc/maxdb/en/3e/165072b8d18f47a821ff8e12790034/frameset.htm

and 

http://dev.mysql.com/doc/maxdb/en/25/88c45254cc9a40af718aa00700dc5d/frameset.htm

and there you can find that iso level 2/20 has a TEMPORARY table share lock released \
as fast as possible (directly after statement, sometimes not even set, sometimes \
released after closing the cursor needing it) holding row share locks to the end of \
the transaction and iso level 3/30 holds table share locks to the end of the session.

Elke
SAP Labs Berlin

> Television has brought back murder into the home -- where it belongs.
> 					-- Alfred Hitchcock
> 
> --
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe:    http://lists.mysql.com/maxdb?unsub=elke.zabach@sap.com

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=sapdb-general@progressive-comp.com



[prev in list] [next in list] [prev in thread] [next in thread]