• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Liutauras Vilda
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • fred rosenberger
  • salvin francis
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Carey Brown

Transaction isolation level

 
Ranch Hand
Posts: 121
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Marshal
Posts: 25680
69
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 121
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks! I use MySQL.
 
Paul Clapham
Marshal
Posts: 25680
69
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 121
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Here is a link a found useful: http://dev.mysql.com/doc/refman/5.0/en/set-transaction.html
 
Too many men are afraid of being fools - Henry Ford. Foolish tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
    Bookmark Topic Watch Topic
  • New Topic