Configure RAM and CPU limits for SQL containers

You can limit the CPU and RAM consumption for Docker containers that handle database-related tasks.

Configure RAM and CPU consumption

In the docker-compose.yaml file, add the following parameters in the environment block:

environment:
  ...
  [[[SQL_SESSION_MEMORY|#sql-session-memory]]]: <memory_limit>
  [[[SQL_SESSION_CPUS|#sql-session-cpus]]]: <number_of_cpus>
  [[[MAX_HEAP_SIZE|#max-heap-size]]]: <heap_size_limit>
        

Reference

SQL_SESSION_MEMORY

String

Memory limit in bytes.

Supports size suffixes (K, M, G, T, Ki, Mi, Gi, and Ti). If no suffix is provided, the value is interpreted as bytes.

Example: "3G"

SQL_SESSION_CPUS

String

Number of CPUs.

Example: 2

MAX_HEAP_SIZE

String

(Optional) Memory allocated to the Java machine.

Supports decimal suffixes (K, M, G, T, Ki, Mi, Gi, and Ti). If no suffix is provided, the value is interpreted as bytes.

Example: "2G"

19 August 2025