默认安装的mysql 需要做哪些优化

Posted: 2016-11-23 in Uncategorized

# Slow Query

log-slow-queries=/var/log/mysqld-slow.log

long_query_time=1

# 02-05 end

# add by xLight

max_connections = 400

innodb_buffer_pool_size = 2G

query_cache_size = 128M

expire_logs_days = 7

Leave a Reply

Your email address will not be published. Required fields are marked *