Storage Location for Transaction Logs and Snapshots
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
The datadir
engine variable stores the location of transaction logs and snapshots./var/lib/memsql/<node_
directory with the log file names resembling the following format: metrics_
.
-
metrics
is the database name -
3
is the partition number -
log
is the file type -
v1
is the file format version number -
15335424
is the log sequence number (LSN)
Snapshots are typically located in the /var/lib/memsql/<node_
directory with the snapshot names resembling the following format: memsql_
.
-
memsql
is the name of the source database -
snapshot
is the file type -
v1
is the file format version number -
the remaining characters represent the sequence number
Last modified: January 10, 2022