paip.mysql备份慢的解决(二)
---------
log-error=d:/MySQL56/mysql_log_err.txt
thread_cache = 128
query_cache_type = 1
query_cache_size = 128M
join_buffer_size = 80M
sort_buffer_size = 20M
read_buffer_size = 20M
read_rnd_buffer_size = 20M
max_heap_table_size = 128M
tmp_table_size = 128M
binlog_cache_size = 12M
max_binlog_size = 512M
expire_logs_days = 3
# innodb_buffer_pool_size = 2G
innodb_use_sys_malloc = 1
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES