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