In this blog post, we’ll discuss the MySQL
default configuration changes between 5.6 and 5.7.
MySQL 5.7 has added a variety of new features that might excite
you. However, there are also changes in the current
variables that you might have overlooked. MySQL 5.7 updated
nearly 40 of the defaults from 5.6. Some of the changes could
severely impact your server performance, while others
might go unnoticed. I’m going to go over each of the changes
and what they mean.
The change that can have the largest impact on your server is
likely
sync_binlog
. My colleague, Roel Van de Paar, wrote about this impact in
depth in another blog post, so I won’t go in much detail.
…
[Read more]