Transaction isolation level

[Giuseppa Cefalu]

Hi,

For the 3 isolation levels 1.- SET GLOBAL TRANSACTION ISOLATION LEVEL SERIALIZABLE, 2.-
SET SESSION TRANSACTION ISOLATION LEVEL SERIALIZABLE and 3.- SET SESSION ISOLATIOn LEVEL SERIALIZABLE.
When should I used each one?

thank you

[Paul Clapham]

Well, here's somebody's explanation of what that means to MySQL; I expect it applies to other databases as well: SET TRANSACTION.

[Giuseppa Cefalu]

Thanks! I use MySQL.

[Paul Clapham]

I found that by using "SET GLOBAL TRANSACTION ISOLATION LEVEL SERIALIZABLE" as my Google keywords, by the way. However most of the first page of results weren't quite about that exact string, just resources talking about transaction isolation level in general.

[Giuseppa Cefalu]

Here is a link a found useful: http://dev.mysql.com/doc/refman/5.0/en/set-transaction.html