1.替换/etc/my.cnf 为 mysql5.7 的 my.cnf

1
2
3
4
5
6
7
8
9
1
0
1
1
1
2
1
3
1
4
1
5
1
6
1
7
1
8
1
9
2
0
2
1
2
2
2
3
2
4
2
5
2
6

[root@HE3 ~]

#vi /etc/my.cnf

[client]
port=3306
socket=/tmp/mysql.sock
default-character-

set

=utf8

[mysql]
no-auto-rehash
default-character-

set

=utf8

[mysqld]
port=3306
character-

set

-server=utf8

socket=/tmp/mysql.sock
basedir=/usr/local/mysql
datadir=/data/mysql
explicit_defaults_for_timestamp=

true

lower_case_table_names=1
back_log=103
max_connections=3000
max_connect_errors=100000
table_open_cache=512
external-locking=FALSE
max_allowed_packet=32M
sort_buffer_size=2M
join_buffer_size=2M
thread_cache_size=51
query_cache_size=32M

#query_cache_limit=4M

transaction_isolation=REPEATABLE-READ
tmp_table_size=96M
max_heap_table_size=96M

###***slowqueryparameters

long_query_time=1
slow_query_log = 1
slow_query_log_file=/data/slowlog/slow.log

###***binlogparameters

log-bin=mysql-bin
binlog_cache_size=4M
max_binlog_cache_size=8M
max_binlog_size=1024M
binlog_format=MIXED
expire_logs_days=7

###***relay-logparameters
#relay-log=/data/3307/relay-bin