MySQL max_connect_errors .2 INSTALL-SOURCE

estis が 2015/07/11 (土) 01:25 に投稿

INSTALL-SOURCE
内に
Configuration Changes
という見出しで
バージョン 5.6.6 からデフォルト値が変更されたと書かれている。（10 → 100）

Configuration Changes


     * Beginning with MySQL 5.6.6, several MySQL Server
       parameters have defaults that differ from previous
       releases. The motivation for these changes is to provide
       better out-of-box performance and to reduce the need for
       the database administrator to change settings manually.
       These changes are subject to possible revision in future
       releases as we gain feedback.
       In some cases, a parameter has a different static default
       value. In other cases, the server autosizes a parameter
       at startup using a formula based on other related
       parameters or server host configuration, rather than
       using a static value. For example, the setting for
       back_log now is its previous default of 50, adjusted up
       by an amount proportional to the value of
       max_connections. The idea behind autosizing is that when
       the server has information available to make a decision
       about a parameter setting likely to be better than a
       fixed default, it will.
       The following table summarizes changes to defaults. Any
       of these can be overridden by specifying an explicit
       value at server startup.

   Parameter Old Default New Default
   back_log 50 Autosized using max_connections
   binlog_checksum NONE CRC32
   --binlog-row-event-max-size 1024 8192
   flush_time 1800 (on Windows) 0
   innodb_autoextend_increment 8 64
   innodb_buffer_pool_instances 1 8 (platform dependent)
   innodb_checksum_algorithm INNODB CRC32 (changed back to
   INNODB in MySQL 5.6.7)
   innodb_concurrency_tickets 500 5000
   innodb_file_per_table 0 1
   innodb_old_blocks_time 0 1000
   innodb_open_files 300 Autosized using innodb_file_per_table,
   table_open_cache
   innodb_stats_on_metadata ON OFF
   join_buffer_size 128KB 256KB
   max_allowed_packet 1MB 4MB
   max_connect_errors 10 100
   sync_master_info 0 10000
   sync_relay_log 0 10000
   sync_relay_log_info 0 10000
       With regard to compatibility with previous releases, the
       most important changes are:

          + innodb_file_per_table is enabled (previously
            disabled).

          + innodb_checksum_algorithm is CRC32 (previously
            INNODB and changed back to INNODB in MySQL 5.6.7).

          + binlog_checksum is CRC32 (previously NONE).
       Therefore, if you are upgrading an existing MySQL
       installation, have not already changed the values of
       these parameters from their previous defaults, and
       backward compatibility is a concern, you may want to
       explicitly set these parameters to their previous
       defaults. For example, put these lines in the server
       option file:
MySQL