Configuration
A Dolt SQL server can be configured at server start time, or by setting system variables in the SQL session. The simplest way to configure server behavior is to provide a config file with the --config flag. Here's an example file:
1
log_level: info
2
3
behavior:
4
read_only: false
5
autocommit: true
6
7
user:
8
name: root
9
password: ""
10
11
listener:
12
host: localhost
13
port: 3306
14
max_connections: 100
15
read_timeout_millis: 28800000
16
write_timeout_millis: 28800000
17
18
performance:
19
query_parallelism: null
Copied!
The full list of supported fields can be found in the docs for the sql-server command.

System variables

Dolt defines system variables that you can set in your session via the SET syntax. Many of these can be persisted, so they remain set after a server restart.
1
set @@dolt_transaction_commit = 1;
Copied!
A full list of available system variables can be found in the docs on system variables.
Export as PDF
Copy link
Edit on GitHub