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
posted @ 2024-10-23 23:35  冯元春  阅读(3)  评论(0编辑  收藏  举报