MariaDB Essentials

Configuring MariaDB

The MariaDB behavior is affected by a number of server variables. Before discussing the important variables, it is necessary to understand how to set such variables.

The values of the server variables are set in the following ways:

• For each variable, there exists a default value.
• One or more configuration files can be read by MariaDB at startup. Each file sets some variables, overriding the default values.
• mysqld can be called with some options. In this case, each option overrides the value of a server variable.
• At runtime, it is still possible to change the values of some variables. These variables are called dynamic variables. The values of static variables cannot be changed at runtime; thus, modifying such variables requires ...