mysql配置文件

版本1:

[root@d-mysql205 MYSQL]# egrep -v "^$|^#" /etc/my.cnf
[client]
default-character-set=utf8
[mysqld]
character-set-server=utf8
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
sql_mode='NO_ENGINE_SUBSTITUTION'
lower_case_table_names=1
skip_name_resolve
symbolic-links=0
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
max_connections = 1000
max_allowed_packet=500M
wait_timeout=288000
interactive_timeout = 288000
max_binlog_size=100M
expire_logs_days=10

posted @ 2020-03-26 15:53  水中鱼2018  阅读(121)  评论(0编辑  收藏  举报