MySQL has just released MySQL 8.0 DR (and yes, DR stands for Don’t Run-it-in-production-yet) so let’s jump right in and take a look at the hottest new features coming in this new release:
1. Persistent runtime configuration changes.
Love it. From now on we’ll be able to use
innodb_buffer_pool_size = X; instead of
innodb_buffer_pool_size = X; for the runtime changes to
persist during a restart. It may not make much sense if you’re
using a modern database that doesn’t even have a configuration
file, but for us who lived with MySQL for over 20 years, this is
How does it work? In a nutshell, these changes are saved in
mysqld-auto.cnf file in MySQL data directory.
2. MySQL privilege tables are now InnoDB. I think this was …[Read more]