SingleStoreDB Directory Layout
For installations using the SingleStoreDB RPM and Debian packages, SingleStoreDB follows the Linux Standard Base (LSB) layout.
/var/lib/memsql/ [Default nodes installation directory.]<hashed-node-id>/auditlogs/ [When audit logging is enabled, holds a log of all database activity from the cluster.]data/ [The data on the node; the default backups directory for local backups made to “./”]logs/ [Location of transaction logs used in node recovery and replication.]snapshots/ [Location of database snapshots.]memsql.cnf/ [The configuration file for the node. Also includes system variables.]plancache/ [Location of the files for the various plans in the plancache.]tracelogs/memsql.log [The consolidated general/error log.]db_files/ [If secure_file_priv has not been set to NULL, the location where data can be loadedfrom locally; secure_file_priv can also be set to a different directory.Refer to Setting SECURE_FILE_PRIV for more information.]nodes.hcl/ [The memsqlctl state file which contains information about the nodes local to the host.]
The directory layout resembles the following when viewed as a directory tree.
/var/lib/memsql/├── <hashed-node-id>│ ├── auditlogs│ ├── data│ │ ├── logs│ │ └── snapshots│ ├── memsql.cnf│ ├── plancache│ └── tracelogs│ └── memsql.log├── db_files└── nodes.hcl
Last modified: June 22, 2022