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 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_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 database

• snapshot is the file type

• v1 is the file format version number

• the remaining characters represent the sequence number