# Level of logging: [ trace|debug|info|warning|error|fatal ]
log_level: info

# Maximum strings of queries logged in the log file. 0=unlimited
max_logged_query_len: 0

# Dir the server will load db to serve from, and create new ones. Defaults to the current directory.
data_dir: ../db/

# Dir the server will load and store non-database config data from, such as permission information. Defaults $data_dir/.doltcfg.
cfg_dir: ../db/cfg

# File to load/store users and privileges. Defaults to $doltcfg-dir/privileges.db. Will be created as needed.
privilege_file: ../db/cfg/privileges.db

# File to load/store branch control permissions. Defaults to $doltcfg-dir/branch_control.db. Will be created as needed.
branch_control_file: ../db/cfg/branch_control.db

# Map of system variable name to desired value for all system variable values to override.
system_variables:
  secure_file_priv: ../db/

user:
  # Admin username, should be set to secure credentials
  name: "root"
  password: "CHANGE_ME"


listener:
  # Address the server will listen for connections on [ Domain|IPv4|IPv6 ]
  host: 127.0.0.1

  # Port the server will listen on
  port: 3306

  # Maximum number of simultaneous connections the server will accept
  max_connections: 100

  # Milliseconds the server will wait for a read operation (1sec = 1000ms)
  read_timeout_millis: 5000

  # Milliseconds the server will wait for a write operation (1sec = 1000ms)
  write_timeout_millis: 15000

  # Allows use of cleartext passwords. Defaults to false
  allow_cleartext_passwords: true

  socket: "/run/mysqld/mysqld.sock"
  # ???
  # tls_key: null
  # tls_cert: null
  # require_secure_transport: null


behavior:
  # When enabled modifications to the database are disabled.
  read_only: false

  # When enabled every statement is committed automatically. Defaults to true. (@@autocommit can also be specified in each session.)
  autocommit: false

  # When enabled all SQL transaction commits will automatically create a Dolt commit.
  dolt_transaction_commit: false

  # Load or ignore persistant global variables. Defaults to load.
  persistence_behavior: load

  # Whether the Event Scheduler is enabled and running on the server [ ON|OFF|DISABLED ]
  event_scheduler: "off"

    # ???
    # disable_client_multi_statements: false



# Replicated cluster settings. For information on setting these values, see https://docs.dolthub.com/sql-reference/server/replication#configuration-1
# cluster:
  # standby_remotes:
    # - name: standby
    #   remote_url_template: http://dolt-2.db:50051/{database}
  # bootstrap_role: primary
  # bootstrap_epoch: 1
  # remotesapi:
    # port: 50051


# remotesapi:
  # If set to a port this server will listen for API calls from clients to clone, pull, etc. databases.
  # remotesapi.port: 999

  # When enabled pushes will be disabled via the remote API.
  # read_only: true

# Map of user name to a map of session variables to set on connection for each session.
# user_session_vars: []