Setting MySQL Database on Azure server parameters

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

Find out more about MySQL parameters.

Parameter Default value Range

Event_scheduler OFF [ON|OFF|DISABLED]
div_precision_increment 4 [0-30]
group_concat_max_len 1024 [4-16777216]
Innodb_adaptive_hash_index ON [ON|OFF]
innodb_lock_wait_timeout 50 [1-3600]
interactive_timeout 1800 [10-1800]
log_queries_not_using_indexes OFF [ON|OFF]
Log_bin_trust_function_creators OFF [ON|OFF|FALSE]
max_allowed_packet 1048576 [1024- 16777216]
server-id Random Value [1000 – 4294967295]
sql_mode Empty 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

http://dev.mysql.com/doc/refman/5.5/en/sql-mode.html

wait_timeout 120 [60-240]

Note

**In view of the limitations of Azure Traffic Manager, we have adjusted the default value for wait_timeout to 120 seconds (s) and the selectable range to 60s to 240s, but this adjustment only works on instances created after October 2015. For earlier instances, please manually set the value of wait_timeout to any number between 60s and 240s. We recommend 120s. **