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