> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/server-management/variables-and-modes.md).

# Variables and Modes

{% columns %}
{% column %}
{% content-ref url="/pages/XJYVa8KVWNCBIjkzRDEa" %}
[Options, System & Status Variables](/docs/server/server-management/variables-and-modes/full-list-of-mariadb-options-system-and-status-variables.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
A comprehensive, alphabetical reference list of all server command-line options, system variables, and status variables available in MariaDB.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/Fdk8Pp58tMVtMH9Ji2Z8" %}
[Server Status Variables](/docs/server/server-management/variables-and-modes/server-status-variables.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
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`.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/xrSGScA0IcbzH0p9P6k8" %}
[Server System Variables](/docs/server/server-management/variables-and-modes/server-system-variables.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
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.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/cymAhsWdKBA1NlC5j7jP" %}
[NEW\_MODE](/docs/server/server-management/variables-and-modes/new_mode.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Explains the `NEW_MODE` system variable (from MariaDB 11.4), which lets you opt in to new behaviors and optimizations in otherwise stable versions.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/nrJXtLf9QrkCyjQfUp7A" %}
[OLD\_MODE](/docs/server/server-management/variables-and-modes/old_mode.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Describes the `OLD_MODE` system variable, used to revert specific behaviors to match older MariaDB or MySQL versions for compatibility purposes during upgrades.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/LthJr8OlJ7TPk7DPR8DO" %}
[SQL\_MODE](/docs/server/server-management/variables-and-modes/sql_mode.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Complete SQL\_MODE reference: set via SET/SET GLOBAL/--sql-mode, view @@SQL\_MODE, STRICT\_TRANS\_TABLES, ANSI\_QUOTES, TRADITIONAL, and database emulation.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/spaces/aEnK0ZXmUbJzqQrTjFyb/pages/7vFdQLGeYxDOIeWBv9xb" %}
[SQL\_MODE=MSSQL](/docs/release-notes/community-server/about/compatibility-and-differences/sql_modemssql.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
SQL\_MODE=MSSQL enables Microsoft SQL Server compatibility behaviors in MariaDB.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/spaces/aEnK0ZXmUbJzqQrTjFyb/pages/oseGr1fifoTbinBKWaaQ" %}
[SQL\_MODE=ORACLE](/docs/release-notes/community-server/about/compatibility-and-differences/sql_modeoracle.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
SQL\_MODE=ORACLE enables Oracle Database compatibility behaviors in MariaDB.
{% endcolumn %}
{% endcolumns %}