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

Was this Article Helpful?

Thanks For Your Feedback!