How to configure server parameters in Azure Database for MariaDB by using the Azure portal

Azure Database for MariaDB supports configuration of some server parameters. This article describes how to configure these parameters by using the Azure portal. Not all server parameters can be adjusted.

  1. Sign in to the Azure portal, then locate your Azure Database for MariaDB server.
  2. Under the SETTINGS section, click Server parameters to open the server parameters page for the Azure Database for MariaDB server. Azure portal server parameters page
  3. Locate any settings you need to adjust. Review the Description column to understand the purpose and allowed values. Enumerate drop down
  4. Click Save to save your changes. Save or Discard changes
  5. If you have saved new values for the parameters, you can always revert everything back to the default values by selecting Reset all to default. Reset all to default

List of configurable server parameters

The list of supported server parameters is constantly growing. Use the server parameters tab in Azure portal to get the definition and configure server parameters based on your application requirements.

Non-configurable server parameters

InnoDB Buffer Pool and Max Connections are not configurable and tied to your pricing tier.

Pricing Tier vCore(s) InnoDB Buffer Pool (MB)
Basic 1 1024
Basic 2 2560
General Purpose 2 3584
General Purpose 4 7680
General Purpose 8 15360
General Purpose 16 31232
General Purpose 32 62976
General Purpose 64 125952
Memory Optimized 2 7168
Memory Optimized 4 15360
Memory Optimized 8 30720
Memory Optimized 16 62464
Memory Optimized 32 125952

These additional server parameters are not configurable in the system:

Parameter Fixed value
innodb_file_per_table in Basic tier OFF
innodb_flush_log_at_trx_commit 1
sync_binlog 1
innodb_log_file_size 512MB

Other server parameters that are not listed here are set to their MariaDB out-of-box default values for MariaDB.

Working with the time zone parameter

Populating the time zone tables

The time zone tables on your server can be populated by calling the az_load_timezone stored procedure from a tool like the MySQL command line or MySQL Workbench.


If you are running the az_load_timezone command from MySQL Workbench, you may need to turn off safe update mode first using SET SQL_SAFE_UPDATES=0;.

CALL mysql.az_load_timezone();


You should restart the server to ensure the time zone tables are properly populated. To restart the server, use the Azure portal or CLI. To view available time zone values, run the following command:

SELECT name FROM mysql.time_zone_name;

Setting the global level time zone

The global level time zone can be set from the Server parameters page in the Azure portal. The below sets the global time zone to the value "US/Pacific".

Set time zone parameter

Setting the session level time zone

The session level time zone can be set by running the SET time_zone command from a tool like the MySQL command line or MySQL Workbench. The example below sets the time zone to the US/Pacific time zone.

SET time_zone = 'US/Pacific';

Refer to the MariaDB documentation for Date and Time Functions.