甲骨文MySQL部门副总裁 Tomas Ulin在MySQL Connect 2012大会上称, 甲骨文已经对MySQL Server 5.6中的默认设置进行了更改,主要如下: 设置旧值新值back_log5050 + ( max_connections / 5 ) 上限为900binlog_checksumNONECRC32binlog-row-event-max-size1k8kflush_time1800Windows平台从1800改为0host_cache_size128128 + 1 for each of the first 500 max_connections + 1 for every 20 max_connections over 500, capped at 2000innodb_autoextend_increment864innodb_buffer_pool_instances08。在32位Windows中,如果innodb_buffer_pool_size大于1300M,默认值为innodb_buffer_pool_size / 128Minnodb_concurrency_tickets5005000innodb_file_per_table01innodb_log_file_size5M48Minnodb_old_blocks_time01000innodb_open_files300300。如果innodb_file_per_table为ON,则为更高的table_open_cache值或300innodb_purge_batch_size20300innodb_purge_threads01innodb_stats_on_metadataonoffjoin_buffer_size128k256kmax_allowed_packet1M4Mmax_connect_errors10100open_files_limit05000query_cache_size01Mquery_cache_typeON/1OFF/0sort_buffer_size2M256ksql_modenoneNO_ENGINE_SUBSTITUTIONsync_master_info010000sync_relay_log010000sync_relay_log_info010000table_definition_cache400400 + table_open_cache / 2, capped at 2000table_open_cache4002000thread_cache_size08 + max_connections/100, capped at 100