Customize server parameters for MySQL Database on Azure

MySQL Database on Azure supports custom settings for some parameters. The following table lists these parameters, their default values, and their selectable ranges.

For more information on MySQL parameters, see.

Parameter Default value Range
binlog_group_commit_sync_delay (limited to version 5.7) 1000 [0 - 0; 11 - 1000000]
binlog_group_commit_sync_no_delay_count (limited to version 5.7) 0 [0 - 1000000]
character_set_server [utf8|utf16|utf32|utf8mb4|ujis|ucs2|tis620|swe7|sjis|macroman|macce|latin1|latin2|latin5|latin7|koi8r|koi8u|keybcs2|hp8|hebrew|greek|geostd8|gbk|gb2312|euckr|eucjpms|dec8|cp850|cp852|cp866|cp932|cp1250|cp1251|cp1256|cp1257|binary|big5|ascii|armscii8]
div_precision_increment 4 [0 - 30]
eq_range_index_dive_limit 10 [0 - 4294967295]
event_scheduler OFF [ON|OFF|DISABLED]
group_concat_max_len 1024 [4-16777216]
innodb_additional_mem_pool_size (limited to version 5.6) 8388608 [2097152 - 52428800]
innodb_adaptive_hash_index ON [ON|OFF]
innodb_lock_wait_timeout 50 [1-3600]
innodb_old_blocks_pct 37 [5 - 95]
innodb_old_blocks_time 1000 [0 - 4294967295]
innodb_online_alter_log_max_size 134217728 [65536 - 2147483648]
innodb_read_ahead_threshold 56 [0 - 64]
innodb_thread_sleep_delay 10000 [0 - 1000000]
interactive_timeout 1800 [10-1800]
log_bin_trust_function_creators OFF [ON|OFF|FALSE]
log_queries_not_using_indexes OFF [ON|OFF]
long_query_time 10 [1 - 1E+100]
max_allowed_packet 1048576 [1024 - 16777216]
max_connect_errors 100 [1 - 18446744073709551615]
max_length_for_sort_data 1024 [4 - 8388608]
server_id [1000-4294967295]
slave_net_timeout 60 [30 - 3600]
slow_query_log OFF [ON|OFF]
sql_mode [ALLOW_INVALID_DATES|ANSI_QUOTES|ERROR_FOR_DIVISION_BY_ZERO|HIGH_NOT_PRECEDENCE|IGNORE_SPACE|NO_AUTO_CREATE_USER|NO_AUTO_VALUE_ON_ZERO|NO_BACKSLASH_ESCAPES|NO_DIR_IN_CREATE|NO_ENGINE_SUBSTITUTION|NO_FIELD_OPTIONS|NO_KEY_OPTIONS|NO_TABLE_OPTIONS|NO_UNSIGNED_SUBTRACTION|NO_ZERO_DATE|NO_ZERO_IN_DATE|ONLY_FULL_GROUP_BY|PAD_CHAR_TO_FULL_LENGTH|PIPES_AS_CONCAT|REAL_AS_FLOAT|STRICT_ALL_TABLES|STRICT_TRANS_TABLES] Please refer to Server SQL Modes.
table_open_cache 64 [1 - 4000]
time_zone SYSTEM [SYSTEM|[-12:00 to +12:00]
tx_isolation REPEATABLE-READ [READ-UNCOMMITTED|READ-COMMITTED|REPEATABLE-READ|SERIALIZABLE]
wait_timeout 120 [60-240]

Note

Due to the limitations of the Azure Traffic Manager, the default value for wait_timeout is 120 seconds and the selectable range is 60-240 seconds. This only applies for instances created from October onward. For earlier instances, please manually set the value of wait_timeout to any value between 60 and 240 seconds We recommend 120 seconds.

Note

For more information about how to configure time zones, see Configure time zones on MySQL on Azure.