线上有若干WIN环境下的MySQL,需要进行优化配置，列出以下参数方便查阅
# For advice on how to change settings please see# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the# *** default location during install, and will be replaced if you# *** upgrade to a newer version of MySQL.[mysqld]# Remove leading # and set to the amount of RAM for the most important data# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.# innodb_buffer_pool_size = 128M# Remove leading # to turn on a very important data integrity option: logging# changes to the binary log between backups.# log_bin# These are commonly set, remove the # and set as required.# basedir = .....# datadir = .....# port = .....# server_id = .....basedir = D:\\MySQL5.6datadir = D:\MySQL5.6\\datamax_connections = 1100max_user_connections = 1000max_connect_errors = 10000max_allowed_packet = 128M# Remove leading # to set options mainly useful for reporting servers.# The server defaults are faster for transactions and fast SELECTs.# Adjust sizes as needed, experiment to find the optimal values.# join_buffer_size = 128M# sort_buffer_size = 2M# read_rnd_buffer_size = 2M sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES skip_name_resolve = 1skip_external_locking = 1 lower_case_table_names = 1# logslong_query_time = 1slow_query_log = 1slow_query_log_file = D:\\MySQL5.6\\logs\\slow.log log_error = D:\\MySQL5.6\\logs\\error.log #innodb_force_recovery=1# binlogbinlog_format = rowlog_bin = D:\\MySQL5.6\\logs\\mysql-bin binlog_cache_size = 8Mmax_binlog_size = 1Gmax_binlog_cache_size = 4Gexpire_logs_days = 5log_bin_trust_function_creators = 1############ myisamkey_buffer_size = 64M#bulk_insert_buffer_size = 32M########## PGAsort_buffer_size = 8Mread_buffer_size = 8Mjoin_buffer_size = 32Mread_rnd_buffer_size = 32Mquery_cache_type = 0query_cache_size = 0Mtable_open_cache = 6144table_definition_cache = 4096open_files_limit = 65536back_log = 512thread_cache_size = 64thread_stack=192ktmp_table_size=128Mmax_heap_table_size=128Mtransaction_isolation = READ-COMMITTEDinnodb_data_home_dir = D:\MySQL5.6\\data innodb_log_group_home_dir = D:\MySQL5.6\\datainnodb_data_file_path = ibdata1:12M:autoextendinnodb_buffer_pool_size = 1Ginnodb_buffer_pool_instances = 8innodb_log_file_size = 1024Minnodb_log_buffer_size = 64Minnodb_log_files_in_group = 3innodb_flush_log_at_trx_commit = 1innodb_lock_wait_timeout = 10innodb_sync_spin_loops = 40innodb_max_dirty_pages_pct = 80innodb_thread_concurrency = 0innodb_thread_sleep_delay = 500innodb_concurrency_tickets = 1000innodb_file_per_table = 1innodb_read_io_threads = 20innodb_write_io_threads = 20innodb_io_capacity = 600innodb_file_format = Barracudainnodb_purge_threads=1innodb_purge_batch_size = 32innodb_old_blocks_pct=50innodb_stats_on_metadata=0optimizer_switch='mrr=on,mrr_cost_based=off,batched_key_access=on'[myisamchk]key_buffer_size = 64Msort_buffer_size = 512kread_buffer = 2Mwrite_buffer = 2M[mysqldump]quickmax_allowed_packet = 128M#myisam_max_sort_file_size = 10G[mysql]no-auto-rehashmax_allowed_packet = 128Mprompt = '(BI154)\u@\h [10.11.20.31]> '