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