5.7mysql 配置_mysql5.7 的完整配置文件 my.cnf

cat /etc/my.cnf

# For advice on how to change settings please see

# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html

# *** DO NOT EDIT THIS FILE. It's a template which will be copied

to the

# *** default location during install, and will be replaced if

you

# *** upgrade to a newer version of MySQL.

[mysqld]

# Remove leading # and set to the amount of RAM for the most

important data

# cache in MySQL. Start at 70% of total RAM for dedicated server,

else 10%.

# innodb_buffer_pool_size = 128M

# Remove leading # to turn on a very important data integrity

option: logging

# changes to the binary log between backups.

# log_bin

general_log_file = /var/log/mysql/mysql.log

general_log = 1

# These are commonly set, remove the # and set as require