You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

memsql.cnf (MemSQL configuration)

MemSQL node settings are configured in the memsql.cnf file, which is a compatible extension of MySQL’s my.cnf file.

This file is located in your node’s MemSQL home directory, i.e.: /var/lib/memsql/master-3306/memsql.cnf. To find out the path for a specific MemSQL node, use the MEMSQL-PATH command.

Default memsql.cnf Settings

The code listing below shows the default memsql.cnf file included with MemSQL.

  • For a basic MemSQL installation, this file is handled wholly by MemSQL Ops. You should not need to change these settings at all.
  • For a customized installation, see the full list of MemSQL system variables in the System Variables topic.
  • To update MemSQL settings, we recommend using the memsql-ops MEMSQL-UPDATE-CONFIG command.
; ------------------------------------------------------------------------
; THIS CONFIGURATION FILE IS MANAGED BY MEMSQL OPS
; MemSQL Ops controls the data in this file.  Please be careful
; when editing it.
; For more information, see our documentation at http://docs.memsql.com
; ------------------------------------------------------------------------
[server]
basedir = .
bind_address = 0.0.0.0
core_file
default_partitions_per_leaf = 8
lc_messages_dir = ./share
lock_wait_timeout = 60
snapshot_trigger_size = 256m
tmpdir = .
transaction_buffer = 64m
; ------------------------------------------------------------------------
; MEMSQL OPS VARIABLES
;
; Variables below this header are controlled by MemSQL Ops.
; Please do not edit any of these values directly.
; ------------------------------------------------------------------------
port = 3306