Customize server parameters for MySQL Database on Azure

MySQL Database on Azure supports custom settings for some parameters. These parameters, their default values, and their selectable ranges are listed in the following table:

For more information, see MySQL 5.5 Reference Manual.

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 see 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

Because of the limitations of Azure Traffic Manager, the default value for wait_timeout is 120 seconds, and the selectable range is from 60 through 240 seconds. These values apply only to instances that have been created from October 2017 onward. For earlier instances, manually set the value of wait_timeout to any number from 60 through 240 (120 is recommended).

Note

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