Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

What is the difference between setting the transaction isolation level in the client configuration and the server configuration?
If I set the client isolation level to be serializable while the server's is read-repeatable what is the result for the transactions? Both of the same client and with transactions of other clients on the same tables?

share|improve this question
    
Where are you getting the idea that you can set the transaction isolation level in the client configuration? –  Michael - sqlbot Oct 13 '13 at 18:35
    
@Michael-sqlbot:SET @@session.tx_isolation? –  Cratylus Oct 13 '13 at 18:37
    
Ah. That's a SQL statement sent to and executed by the server, changing the isolation level for your thread (session). The client isn't aware of it. The "server configuration" is the default value for each new thread (session). You're asking how sessions with different isolation values interact, then? –  Michael - sqlbot Oct 13 '13 at 18:41
    
@Michael-sqlbot:Thanks for clarifying that.My misunderstanding.Yes you are right about the session with different isolation values in this case then –  Cratylus Oct 13 '13 at 18:43

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.