What are SingleStore engine variables?
Singlestore offers various types of variables, controlling the behavior of the database cluster.
There are two types of engine variables - "Sync Variables" which are cluster-wide variables and "Non-Sync Variables" which are set on a per-node basis. You set sync variables on the master aggregator and they get propagated to all other nodes in the cluster, and non-sync variables need to be configured on each individual node you want the variable to apply to.
You can list all variables and their current values by executing the `SHOW VARIABLES;` command on the concerned node or by `SELECT @@<variable name>;` to check one specific variable.
Variables are set using the `SET` database command or `sdb-admin update-config`, which is the preferred method of setting database variables.
You can find more about Singlestore variables, same like the list of all available engine variables on our documentation page: