xLight.me – building new world

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

# 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