mysql配置优化,慢查询日志

冯元春 / 2024-11-13 / 原文

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