Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

(click on this box to dismiss)

What is the default isolation level in CUBRID?

Do I ever need to change it?

link comment (0)
asked 6 years ago
1 Answer

The isolation_level parameter in $CUBRID/conf/cubrid.conf file is set by default to 3 which is equal to REPEATABLE READ CLASS with READ UNCOMMITTED INSTANCES.

This means that another transaction T2 cannot update the schema of table A while transaction T1 is viewing table A. Transaction T1 may experience R' read (dirty read) for the record that was updated but not committed by another transaction T2 which is indicated by READ UNCOMMITTED INSTANCES.

To obtain the current value of isolation_level you can execute GET TRANSACTION ISOLATION LEVEL query.

Regarding whether you ever need to change it, in most cases you will never need to, especially if you are not sure what this is for. Just leave the default values as it is. If you really understand what you're doing, consult the manual for details.

You can read more about the isolation levels in the manual

More explanation is also covered at Database Concurrency section in the manual and in CUBRID Transaction and Lock tutorial.

link comment (0)
answered 6 years ago

You are either using a very old browser or a browser that is not supported.
In order to browse you need to have one of the following browsers:

Internet Explorer: Mozilla Firefox: Google Chrome: