-
Notifications
You must be signed in to change notification settings - Fork 32
/
mysql-57.cnf
50 lines (34 loc) · 1.56 KB
/
mysql-57.cnf
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
# This makes a MySQL 5.6 server behave similar to the new defaults
# in MySQL 5.7
[mysqld]
# MySQL 5.7 enables more SQL modes by default.
sql_mode="ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_DATE,NO_ZERO_IN_DATE"
# The optimizer changes the default from 10 dives to 200 dives by default
# Context: http://mysqlserverteam.com/you-asked-for-it-new-default-for-eq_range_index_dive_limit/
eq_range_index_dive_limit=200
# MySQL 5.7 contains a new internal server logging API.
# The setting log_warnings is deprecated in 5.7.2 in favour of log_error_verbosity.
# *But* the default fo log_warnings also changes to 2 as well:
log_warnings=2
# MySQL 5.7.7 changes a number of replication defaults
# Binary logging is still disabled, but will default to ROW when enabled.
binlog_format=ROW
sync_binlog=1
slave_net_timeout=60
# InnoDB defaults to the new Dynamic Row format with Barracuda file format.
# large_prefix is also enabled, which allows for longer index values.
innodb_strict_mode=1
innodb_file_format=Barracuda
innodb_large_prefix=1
innodb_purge_threads=4
innodb_checksum_algorithm=crc32
# In MySQL 5.7 only 20% of the pool will be dumped,
# But 5.6 does not support this option
innodb_buffer_pool_dump_at_shutdown=1
innodb_buffer_pool_load_at_startup=1
# These two options had different names in previous versions
binlog_error_action=ABORT_SERVER
binlog_gtid_simple_recovery=1
# 5.7 enable additional P_S consumers by default
# This one is supported in 5.6 as well.
performance-schema-consumer-events_statements_history=ON