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

    Serverless Meetup Sapporoで話てきた。

    はじめにくどうです先日12/11に札幌でServerles…

  2. Azure

    Azure Active Directory のBasic とかPremium とかのライセンスって…

    はじめにくどうです。Azure Active Direct…

  3. Azure

    Azureでは仮想マシンのパスワードをポータルからリセットできます。

    はじめにくどうです。Azureで、仮想マシンのパスワードを…

  4. Azure

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

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

  5. Azure

    HDInsightのKafkaをJolokia(REST API)でモニタリングしてみる。

    はじめにくどうですHDInsightをモニタリングしたい場…

  1. Azure

    Office365のポータルから購入できるライセンスはいっぱいあります。
  2. Azure

    Azureのアラートって簡単にPagerDutyと連携できるんです。そっからSl…
  3. Azure

    Azureの公式ドキュメントを更新しよう!だれでも更新できるんですよ。
  4. Azure

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

    Cactiでグラフに日本語が表示されないときの対処方法
PAGE TOP