Skip to main content
Version: 1.6.0

Isolation levels

Supported isolation levels​

Memgraph currently supports three isolation levels:

  • SNAPSHOT ISOLATION (default)
  • READ COMMITTED
  • READ UNCOMMITTED

Setting the isolation level​

The default isolation level, SNAPSHOT ISOLATION, can be changed using the config or running a query.

Configuration​

Changing the --isolation-level configuration flag to any of the supported values will change the initial global isolation level for every query being run on that instance.

Query​

The initially set isolation level can be changed during runtime using a query of the following format:

SET <scope> TRANSACTION ISOLATION LEVEL <isolation_level>

<scope> defines the scope to which the isolation level change should apply. It can take any of the following values:

  • GLOBAL - apply the new isolation level globally
  • SESSION - apply the new isolation level only for the current session
  • NEXT - apply the new isolation level only for the next transaction in the current session

<isolation_level defines the isolation level which we want to use. It can take any of the following values:

  • SNAPSHOT ISOLATION
  • READ COMMITTED
  • READ UNCOMMITTED