Skip to main content

Mysql 配置文件

[mysqld]
server-id=1
bind-address=0.0.0.0
port=3306
datadir=/data/mysql/data
tmpdir=/data/mysql/temp
secure_file_priv=/data/mysql

character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci
default-time-zone=+8:00

log-bin=mysql-bin
binlog_format=ROW
log-bin-index=mysql-bin.index
relay-log=relay-log
relay_log_index=relay-log.index
log-error=/data/mysql/log/mysql.err.log
slow_query_log=on
long_query_time=10
slow_query_log_file=/data/mysql/log/mysql.slow.log

innodb_use_native_aio=0

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
default-character-set=utf8mb4
no-auto-rehash