mysql标准配置文件以及参数解析
在mysql安装的时候,配置参数设置的不对往往会造成mysql启动不成功,经过无数次的安装mysql,总结出一套标准的mysql配置参数,
标准版配置参数
####################################################################################
[mysqld]
#=================general
basedir = /usr/local/mysql
datadir = /app/mysql/data
socket = /usr/local/mysql/mysql.sock
user = mysql
port = 3306
server_id = 10277
character-set-server=utf8
skip-character-set-client-handshake
skip_name_resolve
#=================logs
sync_binlog = 0
slave_skip_errors = all
log-error = /app/mysql/log/err.log
log_bin = /app/mysql/data/mysqld-bin
binlog_format = MIXED
relay-log = /app/mysql/data/mysqld-relay-bin
relay-log-index = /app/mysql/data/mysqld-relay-bin.index
relay-log-info-file = /app/mysql/data/relay-log.info
expire_logs_days = 3
long_query_time = 1
slow_query_log_file = /app/mysql/log/log-slow-queries.log
slow_query_log = 1
#========