mysql配置优化,慢查询日志
max_binlog_size = 100M
# binlog_do_db = include_database_name
# binlog_ignore_db = include_database_name
#
#
#
slow_query_log = ON
slow_query_log_file = /var/log/mysql/slow.log
long_query_time = 2
innodb_buffer_pool_size=2000M
innodb_log_buffer_size=500M
max_connections=1000
mysqlx_max_connections=1000
innodb_flush_log_at_trx_commit=0