my.cnf需要改的参数

binlog_format = ROW
transaction-isolation="READ-COMMITTED"
sync_binlog = 1
innodb_flush_log_at_trx_commit = 1
query_cache_size = 0
query_cache_type = 0
expire_logs_days = 7
slow_query_log = 1
long_query_time = 1
slow_query_log_file = /data/mysql/slow.log
max_connections = 1000
lock_wait_timeout = 3600
 
 
原文地址:https://www.cnblogs.com/l10n/p/12606363.html