Storage Location for Transaction Logs and Snapshots
The datadir
engine variable stores the location of transaction logs and snapshots. Transaction logs are typically stored in the /var/lib/memsql/<node_ID>/data/logs
directory with the log file names resembling the following format: metrics_3_log_v1_15335424
. In this example,
metrics
is the database name3
is the partition numberlog
is the file typev1
is the file format version number15335424
is the log sequence number (LSN)
Snapshots are typically located in the /var/lib/memsql/<node_ID>/data/snapshots
directory with the snapshot names resembling the following format: memsql_snapshot_v1_0_28
. In this example,
memsql
is the name of the source databasesnapshot
is the file typev1
is the file format version numberthe remaining characters represent the sequence number