Variables and Modes

Explore MariaDB Server variables and modes. This section explains how to configure global and session variables, and how different SQL modes influence database behavior and compatibility.

Options, System & Status Variables

A comprehensive, alphabetical reference list of all server command-line options, system variables, and status variables available in MariaDB.

Server Status Variables

Documentation for server status variables, which provide information about the server's current state and operation (e.g., Aborted_connects, Uptime), accessed via SHOW STATUS.

Server System Variables

Reference for MariaDB Server system variables — how to view and set them, their scope and dynamism, and their effect on connections, caching, logging, and performance.

NEW_MODE

Explains the NEW_MODE system variable (from MariaDB 11.4), which lets you opt in to new behaviors and optimizations in otherwise stable versions.

OLD_MODE

Describes the OLD_MODE system variable, used to revert specific behaviors to match older MariaDB or MySQL versions for compatibility purposes during upgrades.

SQL_MODE

Complete SQL_MODE reference: set via SET/SET GLOBAL/--sql-mode, view @@SQL_MODE, STRICT_TRANS_TABLES, ANSI_QUOTES, TRADITIONAL, and database emulation.

SQL_MODE=MSSQL

SQL_MODE=MSSQL enables Microsoft SQL Server compatibility behaviors in MariaDB.

SQL_MODE=ORACLE

SQL_MODE=ORACLE enables Oracle Database compatibility behaviors in MariaDB.