Skip to main content

SingleStoreDB v8.1

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

In this section: