System Variables for MariaDB Enterprise Server

Set in a Configuration File

If the specific system variable is not read-only, you can set it in a MariaDB configuration file (such as my.cnf):

[mariadb]
log_error=/var/log/mariadb/mariadb.err

Read All Values from Configuration Files

All system variables and other mariadbd command-line options in the system's MariaDB configuration file (such as my.cnf) can be read using the my_print_defaults utility with the --mysqld option:

$ my_print_defaults --mysqld

Set on the Command-Line

If the specific system variable has a corresponding mariadbd command-line option, you can set it when the server is started:

$ mariadbd --log_error=/var/log/mariadb/mariadb.err [OPTION ...]

Set the Global Value Dynamically

If the specific system variable is dynamic, you can set its global value with the SET GLOBAL statement:

SET GLOBAL log_warnings=3;

Show All Global Values

All global system variables can be queried with the SHOW GLOBAL VARIABLES statement:

SHOW GLOBAL VARIABLES;

Set the Session Value Dynamically

If the specific system variable supports session-specific values, you can set its session value with the SET SESSION statement:

SET SESSION log_warnings=3;

Show All Session Values

All system variables for the current session can be queried with the SHOW SESSION VARIABLES statement:

SHOW SESSION VARIABLES;

Show Values with a Filter

It is also possible to filter the output of SHOW VARIABLES, so that it does not return all values.

The SHOW VARIABLES statements can be filtered with a LIKE clause:

SHOW GLOBAL VARIABLES
   LIKE 'log_%';

The SHOW VARIABLES statements can also be filtered with a WHERE clause:

SHOW GLOBAL VARIABLES
   WHERE Variable_name IN(
      'log_error',
      'log_warnings'
   );

Reference Values in a Query

A specific global or session system variable can be referenced in a query by prefixing the variable name with @@global. or @@session.:

SELECT @@session.log_warnings,
   @@global.log_error;

System Variables by MariaDB Server Version

Choose a version of MariaDB Enterprise Server to see the system variables supported by that version:

• System Variables for MariaDB Enterprise Server 10.6

• System Variables for MariaDB Enterprise Server 10.5

• System Variables for MariaDB Enterprise Server 10.4

• System Variables for MariaDB Enterprise Server 10.3

• System Variables for MariaDB Enterprise Server 10.2

Choose a version of MariaDB Community Server to see the system variables supported by that version:

• System Variables for MariaDB Community Server 10.6

• System Variables for MariaDB Community Server 10.5

• System Variables for MariaDB Community Server 10.4

• System Variables for MariaDB Community Server 10.3

• System Variables for MariaDB Community Server 10.2

Summary of System Variables