Azure

Azure Database for MySQL PreviewのServer parameters を確認する。

Azure Database for MySQLのServer parameters を確認して一覧にしてみました。
現状、変更可能なパラメータは動的変更可能なパラメータのみです。

変更はPortalから行えます。

MySQL5.7

PARAMETER NAME VALUE DESCRIPTION
binlog_group_commit_sync_delay 1000 Controls how many microseconds the binary log commit waits before synchronizing the binary log file to disk.
binlog_group_commit_sync_no_delay_count 0 The maximum number of transactions to wait for before aborting the current delay as specified by binlog-group-commit-sync-delay.
character_set_server LATIN1 Use charset_name as the default server character set.
div_precision_increment 4 Number of digits by which to increase the scale of the result of division operations.
group_concat_max_len 1024 Maximum allowed result length in bytes for the GROUP_CONCAT().
innodb_adaptive_hash_index ON Whether innodb adaptive hash indexes are enabled or disabled.
innodb_lock_wait_timeout 50 The length of time in seconds an InnoDB transaction waits for a row lock before giving up.
interactive_timeout 1800 Number of seconds the server waits for activity on an interactive connection before closing it.
log_bin_trust_function_creators OFF This variable applies when binary logging is enabled. It controls whether stored function creators can be trusted not to create stored functions that will cause unsafe events to be written to the binary log.
log_queries_not_using_indexes OFF Logs queries that are expected to retrieve all rows to slow query log.
log_slow_admin_statements OFF Include slow administrative statements in the statements written to the slow query log.
log_throttle_queries_not_using_indexes 0 Limits the number of such queries per minute that can be written to the slow query log.
long_query_time 10 If a query takes longer than this many seconds the server increments the Slow_queries status variable.
max_allowed_packet 536870912 The maximum size of one packet or any generated/intermediate string or any parameter sent by the mysql_stmt_send_long_data() C API function.
min_examined_row_limit 0 Can be used to cause queries which examine fewer than the stated number of rows not to be logged.
server_id 1330995299 The server ID used in replication to give each master and slave a unique identity.
slave_net_timeout 60 The number of seconds to wait for more data from the master before the slave considers the connection broken aborts the read and tries to reconnect.
slow_query_log OFF Enable or disable the slow query log
sql_mode 0 selectedTotal: 22 The current server SQL mode.
time_zone SYSTEM The server time zone
wait_timeout 120 The number of seconds the server waits for activity on a noninteractive connection before closing it.

5.6との違いは以下のパラメータが異なるぐらいです。

MySQL5.6

PARAMETER NAME VALUE DESCRIPTION
character_set_server LATIN1 Use charset_name as the default server character set.
div_precision_increment 4 Number of digits by which to increase the scale of the result of division operations.
group_concat_max_len 1024 Maximum allowed result length in bytes for the GROUP_CONCAT().
innodb_adaptive_hash_index ON Whether innodb adaptive hash indexes are enabled or disabled.
innodb_lock_wait_timeout 50 The length of time in seconds an InnoDB transaction waits for a row lock before giving up.
interactive_timeout 1800 Number of seconds the server waits for activity on an interactive connection before closing it.
log_bin_trust_function_creators OFF This variable applies when binary logging is enabled. It controls whether stored function creators can be trusted not to create stored functions that will cause unsafe events to be written to the binary log.
log_queries_not_using_indexes OFF Logs queries that are expected to retrieve all rows to slow query log.
log_slow_admin_statements OFF Include slow administrative statements in the statements written to the slow query log.
log_throttle_queries_not_using_indexes 0 Limits the number of such queries per minute that can be written to the slow query log.
long_query_time 10 If a query takes longer than this many seconds the server increments the Slow_queries status variable.
max_allowed_packet 536870912 The maximum size of one packet or any generated/intermediate string or any parameter sent by the mysql_stmt_send_long_data() C API function.
min_examined_row_limit 0 Can be used to cause queries which examine fewer than the stated number of rows not to be logged.
server_id 4083732088 The server ID used in replication to give each master and slave a unique identity.
slave_net_timeout 60 The number of seconds to wait for more data from the master before the slave considers the connection broken aborts the read and tries to reconnect.
slow_query_log OFF Enable or disable the slow query log
sql_mode 0 selectedTotal: 22 The current server SQL mode.
time_zone SYSTEM The server time zone
wait_timeout 120 The number of seconds the server waits for activity on a noninteractive connection before closing it.

SQL Mode

デフォルト設定では何も設定されていません。
その為。デプロイ後設定する必要があります。

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

Related post

  1. Azure

    Azure Application Gateway にフロントポートを追加する。

    はじめにくどうです前回の記事では、httpsポートでAzu…

  2. Azure

    AzureにVulsをインストールしてみる。コピペでどーん。Docker編

    はじめにくどうです。Vulsです。前回と一緒。いろ…

  3. Azure

    LinuxConにスタッフしてきました。Azure IoTも体験してきたよ!

    はじめにくどうです。皆さんは、LinuxConをご存知でし…

  4. Azure

    PowerMockupのAzure Icon Setを更新(ver2.5)

    更新アップデートしてたのでPowerMockupのシェイプも更新…

  5. Azure

    Azureのサービスレベル契約の早見表。詳しくは調べてください。

    サービスレベル契約 早見表くどうです。早見表(2015/08/0…

  1. Azure

    Azure Active Directory の削除方法。それ、ServiceP…
  2. 未分類

    EC-CUBE SQLインジェクション脆弱性について(2008年10月1日)
  3. AWS

    とりあえず構築!Ansible Tower !何をするかは構築した後に考える。
  4. Azure

    Application Gateway web application fire…
  5. Azure

    Azure Cloud Shell のユーザーを確認してみる。それでもrootが…
PAGE TOP