Configuration settings

The main Memgraph configuration file is available in /etc/memgraph/memgraph.conf . You can modify that file to suit your specific needs. Additional configuration can be specified by including another configuration file, in a file pointed to by the MEMGRAPH_CONFIG environment variable or by passing arguments on the command line.

Each configuration setting is in the form: --setting-name=value.

You can check the current configuration by using the following query (privilege level CONFIG is required):

SHOW CONFIG;

If you are using a multi-tenant architecture, all isolated databases share identical configurations. At the moment, there is no way to specify a per-database configuration.

Bolt

Flag	Description	Type
--bolt-address=0.0.0.0	IP address on which the Bolt server should listen.	[string]
--bolt-cert-file=	Certificate file which should be used for the Bolt server.	[string]
--bolt-key-file=	Key file which should be used for the Bolt server.	[string]
--bolt-num-workers=	Number of workers used by the Bolt server. By default, this will be the number of processing units available on the machine.	[int32]
--bolt-port=7687	Port on which the Bolt server should listen.	[int32]
--bolt-server-name-for-init=	Server name which the database should send to the client in the Bolt INIT message.	[string]
--bolt-session-inactivity-timeout=1800	Time in seconds after which inactive Bolt sessions will be closed.	[int32]

note

Memgraph does not limit the maximum amount of simultaneous sessions. Transactions within all open sessions are served with a limited number of Bolt workers simultaneously.

Query

Flag	Description	Type
--query-callable-mappings-path	Path to the JSON file that contains possible alias mappings for query procedures in the form of key-value pairs.	[string]
--query-cost-planner=true	Use the cost-estimating query planner.	[bool]
--query-execution-timeout-sec=180	Maximum allowed query execution time. Queries exceeding this limit will be aborted. Value of 0 means no limit.	[uint64]
--query-max-plans=1000	Maximum number of generated plans for a query.	[uint64]
--query-modules-directory=/usr/lib/memgraph/query_modules	Directory where modules with custom query procedures are stored. NOTE: Multiple comma-separated directories can be defined.	[string]
--query-plan-cache-ttl=60	Time to live for cached query plans, in seconds.	[int32]
--query-vertex-count-to-expand-existing=10	Maximum count of indexed vertices which provoke indexed lookup and then expand to existing, instead of a regular expand. Default is 10, to turn off use -1.	[int64]

Storage

Flag	Description	Type
--storage-gc-cycle-sec=30	Storage garbage collector interval (in seconds).	[uint64]
--storage-properties-on-edges=true	Controls whether edges have properties.	[bool]
--storage-recover-on-startup=true	Deprecated and replaced with the data_recovery_on_startup flag. Controls whether the storage recovers persisted data on startup.	[bool]
--storage-snapshot-interval-sec=300	Storage snapshot creation interval (in seconds). Set to 0 to disable periodic snapshot creation.	[uint64]
--storage-snapshot-on-exit=true	Controls whether the storage creates another snapshot on exit.	[bool]
--storage-snapshot-retention-count=3	The number of snapshots that should always be kept.	[uint64]
--storage-wal-enabled=true	Controls whether the storage uses write-ahead-logging. To enable WAL periodic snapshots must be enabled.	[bool]
--storage-wal-file-flush-every-n-tx=100000	Issue a 'fsync' call after this amount of transactions are written to the WAL file. Set to 1 for fully synchronous operation.	[uint64]
--storage-wal-file-size-kib=20480	Minimum file size of each WAL file.	[uint64]
--storage-items-per-batch=1000000	The number of edges and vertices stored in a batch in a snapshot file.	[uint64]
--storage-recovery-thread-count=	The number of threads used to recover persisted data from disk.	[uint64]
--storage-parallel-index-recovery=false	Controls whether the index creation can be done in a multithreaded fashion during recovery.	[bool]

Streams

Flag	Description	Type
--kafka-bootstrap-servers	List of Kafka brokers as a comma separated list of broker host or host:port.	[string]
--pulsar-service-url	The service URL that will allow Memgraph to locate the Pulsar cluster.	[string]
--stream-transaction-conflict-retries=30	Number of times to retry a conflicting transaction of a stream.	[uint32]
--stream-transaction-retry-interval=500	The interval to wait (measured in milliseconds) before retrying to execute again a conflicting transaction.	[uint32]

Other

Flag	Description	Type
--allow-load-csv=true	Controls whether LOAD CSV clause is allowed in queries.	[bool]
--also-log-to-stderr=false	Log messages go to stderr in addition to logfiles.	[bool]
--data-directory=/var/lib/memgraph	Path to directory in which to save all permanent data.	[string]
--data_recovery_on_startup=true	Facilitates recovery of one or more individual databases and their contents during startup. Replaces --storage-recover-on-startup	[bool]
--init-file	Path to the CYPHERL file which contains queries that need to be executed before the Bolt server starts, such as creating users.	[string]
--init-data-file	Path to the CYPHERL file, which contains queries that need to be executed after the Bolt server starts.	[string]
--isolation-level=SNAPSHOT_ISOLATION	Isolation level used for the transactions. Allowed values: SNAPSHOT_ISOLATION, READ_COMMITTED, READ_UNCOMMITTED.	[string]
--log-file=/var/log/memgraph/memgraph.log	Path to where the log should be stored.	[string]
--log-level=WARNING	Minimum log level. Allowed values: TRACE, DEBUG, INFO, WARNING, ERROR, CRITICAL.	[string]
--memory-limit=0	Total memory limit in MiB. Set to 0 to use the default values which are 100% of the physical memory if the swap is enabled and 90% of the physical memory otherwise.	[uint64]
--metrics-address	Host for HTTP server for exposing metrics.	[string]
--metrics-port	Port for HTTP server for exposing metrics.	[uint64]
--memory-warning-threshold=1024	Memory warning threshold, in MB. If Memgraph detects there is less available RAM it will log a warning. Set to 0 to disable.	[uint64]
--password-encryption-algorithm=bcrypt	Algorithm used for password encryption. Defaults to BCrypt. Allowed values: bcrypt, sha256, sha256-multiple (SHA256 with multiple iterations)	[string]
--replication-replica-check-delay-sec	The time duration in seconds between two replica checks/pings. If < 1, replicas will not be checked at all. The MAIN instance allocates a new thread for each REPLICA.	[uint64]
--replication-restore-state-on-startup	Set to true when initializing an instance to restore the replication role and configuration upon restart.	[bool]
--telemetry-enabled=true	Set to true to enable telemetry. We collect information about the running system (CPU and memory information), information about the database runtime (vertex and edge counts and resource usage), and aggregated statistics about some features of the database (e.g. how many times a feature is used) to allow for an easier improvement of the product.	[bool]

Environment variables

Variable	Description	Type
MEMGRAPH_USER	Username	[string]
MEMGRAPH_PASSWORD	User password	[string]
MEMGRAPH_PASSFILE	Path to file that contains username and password for creating user. Data in file should be in format username:password if your username or password contains : just add \ before for example us\:ername:password	[string]

Additional configuration inclusion

You can define additional configuration files in the main configuration file or within a Docker command in the terminal. Additional files are processed after the main configuration file and they override the main configuration file. Additional configuration files are specified with the --flag-file flag.

Example:

--flag-file=another.conf